Homebrew OSX Sierra No such PSQL file or directory postgres@9.5

I have a problem starting psqlafter installation using Homebrew

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"?

And they read other messages and tried their suggestions, but nothing happened: 1.

$brew services list

postgresql@9.5 started johndoe /Users/johndoe/Library/LaunchAgents/homebrew.mxcl.postgresql@9.5.plist

2.

$sudo find / -name .s.PGSQL.5432 -ls

1202295        8 lrwxr-xr-x    1 root             wheel                  26 Sep 26 17:09 /private/var/pgsql_socket/.s.PGSQL.5432 -> /private/tmp/.s.PGSQL.5432

3.

$cat /usr/local/var/postgres/server.log

LOG:  database system was shut down at 2017-09-16 16:39:45 PDT
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
FATAL:  lock file "postmaster.pid" already exists
HINT:  Is another postmaster (PID 25089) running in data directory "/usr/local/var/postgres"?

4.

$cd /usr/local/var/postgres
$ls -a

.                    base                 pg_commit_ts         pg_ident.conf        pg_notify            pg_snapshots         pg_subtrans          pg_xlog              postmaster.opts
..                   global               pg_dynshmem          pg_logical           pg_replslot          pg_stat              pg_tblspc            postgresql.auto.conf server.log
PG_VERSION           pg_clog              pg_hba.conf          pg_multixact         pg_serial            pg_stat_tmp          pg_twophase          postgresql.conf

It seems that pidsomewhere, but where? I tried to look in private/var/pgsql_socket, but he was not there. I also disconnected and launched postgres brew.

+4
source share

Source: https://habr.com/ru/post/1686449/


All Articles