CharlieYe0205/brew_install_postgres_issue.md

## brew_install_postgres_issue.md

      
    Raw
  

              brew_install_postgres_issue.md
            
          
    Install postgres via brew may have the following problem
psql: could not connect to server: No such file or directory. Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
solution: manually create empty folders
cd /usr/local/var/postgres
mkdir -p pg_commit_ts
mkdir -p pg_dynshmem
mkdir -p pg_logical/mappings
mkdir -p pg_logical/snapshots
mkdir -p pg_replslot
mkdir -p pg_serial
mkdir -p pg_snapshots
mkdir -p pg_stat
mkdir -p pg_tblspc
mkdir -p pg_twophase

rm /usr/local/var/postgres/postmaster.pid

brew services restart postgresql
psql # should be find now
Happy Coding ^_^