Hi, On Fri, Jun 12, 2009 at 12:19 PM, Kevin Kempter<kev...@consistentstate.com> wrote: > unix_socket_directory = '/var/run/postgresql' # (change requires restart) <snip> > I can ssh to a different host and connect via psql -h <host> > > but if I'm on the postgres local server I get this: > > $ psql -l > 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"? > > > Thoughts?
You need to specify the directory of unix-domain socket as follows. $ psql -h /var/run/postgresql -l HTH Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
