ps -ef |grep postgres

Trouver le PID du process Postgres père
Exemple : 2962

# ls -l /proc/2962/fd/ |grep socket
lrwx------. 1 postgres postgres 64 Aug  8 06:55 3 -> socket:[25104]
lrwx------. 1 postgres postgres 64 Aug  8 06:55 4 -> socket:[25106]
lrwx------. 1 postgres postgres 64 Aug  8 06:55 8 -> socket:[25118]

# #lsof -i -a -p 2962
# #find / -user postgres -type s 2>/dev/null
# #netstat -lx |egrep "25104|25106|25118"
# ss -xl |egrep "25104|25106|25118"
u_str LISTEN 0      2048                                            /tmp/.s.PGSQL.5455 25106               * 0

su - postgres

$ psql -h /tmp/.s.PGSQL.5455
psql: error: could not connect to server: Not a directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5455/.s.PGSQL.5432"?

$ psql -h /tmp
psql: error: 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"?

Solution

psql -h /tmp -p 5455