Search Postgresql Archives

Re: pg_dump

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

 



On Tue, 2006-11-21 at 17:48 +0000, Richard Huxton wrote:
> 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.

Thank you, have read the manuals and the -h section says host initially
but if you read on it tells about a leading / - that's why I missed it
first time round -skim reading!.
Perhaps you may be able to me to explain this:
I have a Zope application which speaks to postgres via psycopg. I have
packaged all components together so that the application can be
installed like 'single click' or thereabouts and I have tested it on
several Linux distributions. Usually there are no problems but
occasionally the psycopg connection will default to a different unix
domain socket to the one that is configured in the .conf file. Nothing
changes apart from the OS. Is there a way to make sure that on
installation the same socket is used irrespective of OS?
Kind Regards
Garry



[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