Re: pg_dump

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