Re: BUG #16086: Cannot connect using psql, however I can connect using pgadmin

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: "mzwai99(at)outlook(dot)com" <mzwai99(at)outlook(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16086: Cannot connect using psql, however I can connect using pgadmin
Date: 2019-10-29 11:14:39
Message-ID: 37198181572347679@iva4-0814df7d67c8.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ashutosh Sharma 2019-10-29 11:23:10 Re: BUG #16084: Server couldn't be contacted
Previous Message PG Bug reporting form 2019-10-29 10:25:26 BUG #16086: Cannot connect using psql, however I can connect using pgadmin