| From: | lin <jluwln(at)163(dot)com> | 
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> | 
| Subject: | change the value of "unix_socket_directories" , must used "-h /xx/xx" to use the Unix domain socket | 
| Date: | 2014-08-16 15:41:02 | 
| Message-ID: | 7db2358a.16a8a.147df7aa63c.Coremail.jluwln@163.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hi all,
     I change the value of "unix_socket_directories" in postgresql.conf ,  then restart the database, but it cannot connect the 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 test steps as below :
[wln(at)localhost postgres9.3]$ cat data/postgresql.conf | grep unix_socket_directories
unix_socket_directories = '/tmp/wln'    # comma-separated list of directories
[wln(at)localhost postgres9.3]$ psql -d postgres -p 5432
psql: could not connect to server: No such file or directory.
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
[wln(at)localhost postgres9.3]$ psql -d postgres -p 5432 -h /tmp/wln
psql (9.3beta2)
Type "help" for help.
postgres=# \q
[wln(at)localhost postgres9.3]$ 
    Thanks,
     waln
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2014-08-16 15:49:08 | Re: change the value of "unix_socket_directories" , must used "-h /xx/xx" to use the Unix domain socket | 
| Previous Message | Matt Silverlock | 2014-08-16 14:47:49 | pg_ident.hba on a single-user, multi-app machine |