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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #16086: Cannot connect using psql, however I can connectusing pgadmin
Дата
Msg-id CAMkU=1zrraUm9ySaooqm_8_aN4PxD7BeJdXW=NuF9R0vCeCUkw@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16086: Cannot connect using psql, however I can connect using pgadmin  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16086: Cannot connect using psql, however I can connectusing pgadmin  (Ashutosh Sharma <ashu.coek88@gmail.com>)
Re: BUG #16086: Cannot connect using psql, however I can connectusing pgadmin  (Muziwandile Zwane <mzwai99@outlook.com>)
Список pgsql-bugs
Дерево обсуждения

LOG:  listening on Unix socket "/u01/postgresql/.s.PGSQL.5437"
LOG:  listening on Unix socket "/tmp/.s.PGSQL.5437"

...


[root@zardplpsmasdev01 ~]# su - postgres -c "psql"
psql: error: could not connect to server: could not connect to server: No
such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?

You probably have multiple binaries installed coming from different packages or package managers.  psql is searching for the socket in one place, which is not either of the two places the server is listening.  You could explicitly tell it where to connect with either `-h /tmp`, or `-h 127.0.0.1`.  Or you could find the correct "psql" to run (the one that came with the running server) so that it just knows where to look, possibly uninstalling the wrong psql to minimize future confusion.

Cheers,

Jeff

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Ashutosh Sharma
Дата:
Сообщение: Re: BUG #16084: Server couldn't be contacted
Следующее
От: Ashutosh Sharma
Дата:
Сообщение: Re: BUG #16086: Cannot connect using psql, however I can connectusing pgadmin