| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | garry saddington <garry(at)schoolteachers(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump |
| Date: | 2006-11-21 17:48:03 |
| Message-ID: | 45633BD3.7040600@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2006-11-21 17:49:56 | Re: [HACKERS] statement_timeout |
| Previous Message | Magnus Hagander | 2006-11-21 17:43:22 | Re: Download |