Richard Huxton wrote:
garry saddington wrote:
I have a server which has a socket of /var/run/postgresql/.s.PGSQL.5432.
This is set in the .conf file. However, when I try to run a pg_dump it
complains about the server not running on /tmp/.s.PGSQL.5432. Can anyone
explain this behaviour because if I try the -p option to pg_dump or set
the PGPORT env variable it still gives the same report?
Could you have two installations of PG - one from source, one packaged?
Oh, and the -p is useful for setting the port, not the directory for
unix-domain sockets. I think you want to have something like:
pg_dump -h /var/run/postgresql
See the manuals for details.
--
Richard Huxton
Archonet Ltd
