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
Ответ на
Re: [GENERAL] psql only works with -h (even localhost) (Steve Crawford)
Список
Дерево обсуждения
[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
Дата: