Search Postgresql Archives

change the value of "unix_socket_directories" , must used "-h /xx/xx" to use the Unix domain socket

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@localhost postgres9.3]$ cat data/postgresql.conf | grep unix_socket_directories
unix_socket_directories = '/tmp/wln'    # comma-separated list of directories

[wln@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@localhost postgres9.3]$ psql -d postgres -p 5432 -h /tmp/wln
psql (9.3beta2)
Type "help" for help.

postgres=# \q
[wln@localhost postgres9.3]$ 

    Thanks,
     waln







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux