postgresql

error pgsql /tmp/.s.PGSQL.5432
# mac 
 cara 1 
 restart service 
 ``` brew services restart postgresql ``` 
 cara 2 
 buang pid 
 ``` rm /opt/homebrew/var/postgres/postmaster.pid ``` 
 cara 3 
 upgrade pgsql 
 ``` brew postgresql-upgrade-database ```

postgis
``` postgis <@> 
 CREATE EXTENSION postgis; 
 CREATE EXTENSION cube; CREATE EXTENSION earthdistance; ``` 
 ## docker image 
 ``pull postgis/postgis`` 
 param key 
 ``` POSTGRES_PASSWORD POSTGRES_USER ``` 
 ## centos 
 ``` sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm ``` 
 ## install pgsql 
 ``` sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm ``` 
 ``` sudo dnf module enable postgresql:16 sudo dnf install postgresql-server sudo systemctl start postgresql ``` 
 ``` sudo postgresql-setup --initdb sudo systemctl start postgresql sudo systemctl enable postgresql sudo systemctl enable postgresql-11 ``` 
 ``` sudo dnf -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm sudo dnf install dnf-plugins-core sudo dnf config-manager --set-enabled powertools ``` 
 ``` sudo -i -u postgres psql ``` 
 ``` createuser --interactive sudo -u postgres postgres --interactive 
 sudo -u postgres createdb sammy 
 yum install postgis34_16 ``` 
 pg hba conf. 
 vi /var/lib/pgsql/data/pg_hba.conf