Postgres Pro
Downloads
Home   >   mailing lists

Re: change the value of "unix_socket_directories" , must used "-h /xx/xx" to use the Unix domain socket - Mailing list pgsql-general

From Steve Atkins
Subject Re: change the value of "unix_socket_directories" , must used "-h /xx/xx" to use the Unix domain socket
Date
Msg-id EBFA8B41-453A-4A01-A64F-CBBE87BE0FA7@blighty.com
Whole thread Raw
In response to Re: change the value of "unix_socket_directories" , must used "-h /xx/xx" to use the Unix domain socket  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
On Aug 16, 2014, at 8:49 AM, John R Pierce <pierce@hogranch.com> wrote:

> On 8/16/2014 8:41 AM, lin wrote:
>> I change the value of "unix_socket_directories" in postgresql.conf , then restart the database, but it cannot
connectthe database used like this 
>> "psql -d postgres -p 5432" , it must given the parameter " -h /xx/xx" to use the Unix domain socket。
>> how to fix this issue ?
>
> the client has no access to postgresql.conf, it has no idea you changed it. the default value is baked into libpq.so
atcompile time. 

You might find the environment variable PGHOST useful.

Cheers,
  Steve

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: change the value of "unix_socket_directories" , must used "-h /xx/xx" to use the Unix domain socket
Next
From: Nick Guenther
Date:
Subject: Re: change the value of "unix_socket_directories" , must used "-h /xx/xx" to use the Unix domain socket