Re: [GENERAL] psql only works with -h (even localhost)

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: [GENERAL] psql only works with -h (even localhost)
Дата
Msg-id
16898.1485362116@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
[GENERAL] psql only works with -h (even localhost) ProPAAS DBA <dba@propaas.com>
Re: [GENERAL] psql only works with -h (even localhost) Adrian Klaver <adrian.klaver@aklaver.com>
Re: [GENERAL] psql only works with -h (even localhost) Steve Crawford <scrawford@pinpointresearch.com>
Re: [GENERAL] psql only works with -h (even localhost) Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] psql only works with -h (even localhost) ProPAAS DBA <dba@propaas.com>
Re: [GENERAL] psql only works with -h (even localhost) Melvin Davidson <melvin6925@gmail.com>
Steve Crawford  writes:
> Adrian asks the correct questions. Lacking the answers to those I'm going
> to venture a guess that a Unix-domain socket exists but access via
> Unix-domain sockets is somehow blocked, probably by pg_hba.conf.

Actually, the more common case I've seen is that the server put the
socket file in directory X but psql (or more specifically libpq)
is looking in directory Y.  Try "show unix_socket_directories"
(or on older server versions "show unix_socket_directory") in a
successful connection, and compare to the path that psql shows when
bleating that it can't connect.

Usually this isn't operator error per se, but inconsistent defaults
between builds obtained from different sources.

			regards, tom lane

В списке pgsql-general по дате отправления
От: Melvin Davidson
Дата:
От: Alfredo Palhares
Дата:
FAQ