Re: BUG #16086: Cannot connect using psql, however I can connect using pgadmin - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: BUG #16086: Cannot connect using psql, however I can connect using pgadmin
Date
Msg-id 37198181572347679@iva4-0814df7d67c8.qloud-c.yandex.net
Whole thread Raw
In response to BUG #16086: Cannot connect using psql, however I can connect using pgadmin  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Hello

> SAST [98628] LOG: listening on Unix socket
> "/u01/postgresql/.s.PGSQL.5437"
> Oct 29 10:59:59 zardplpsmasdev01 postmaster[98628]: 2019-10-29 10:59:59.505
> SAST [98628] LOG: listening on Unix socket "/tmp/.s.PGSQL.5437"

Seems you have modified unix_socket_directories setting. Your psql tries another path (also was changed from /tmp to
/var/run/postgresql/during compilation).
 

So this is not bug, just misconfiguration. Possible you want add /var/run/postgresql/ to unix_socket_directories

regards, Sergei



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16086: Cannot connect using psql, however I can connect using pgadmin
Next
From: Ashutosh Sharma
Date:
Subject: Re: BUG #16084: Server couldn't be contacted