Search Postgresql Archives

Re: pg_dump

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

 



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


[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