From: | bock(at)openit(dot)de (Julian v(dot) Bock) |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Error on pg_dumpall |
Date: | 2008-04-29 14:37:38 |
Message-ID: | lpwsmgg219.fsf@warpcore.i.openit.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi
>>>>> "CW" == Carol Walter <walterc(at)indiana(dot)edu> writes:
CW> postgres(at)machine1:~$ /usr/local/pgsql/bin/pg_dumpall pg_dumpall:
CW> could not connect to database "template1": could not connect to
CW> server: No such file or directory Is the server running locally
CW> and accepting connections on Unix domain socket
CW> "/tmp/.s.PGSQL.5432"?
CW> If I run the command "psql template1", I can connect to template1
CW> just fine. It looks like pg_dumpall may be looking for template1
CW> in the wrong place.
Debian uses /var/run/postgresql instead of /tmp as directory for unix
domain sockets. Try
/usr/local/pgsql/bin/pg_dumpall -h /var/run/postgresql
--
Julian v. Bock Projektleitung Software-Entwicklung
OpenIT GmbH Tel +49 211 239 577-0
Jahnstr. 18 Fax +49 211 239 577-10
D-40215 Düsseldorf http://www.openit.de
________________________________________________________________
HRB 38815 Amtsgericht Düsseldorf USt-Id DE 812951861
Geschäftsführer:
Susanne Schultz, Oliver Haakert, Maurice Kemmann
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-04-29 14:45:30 | Re: Error on pg_dumpall |
Previous Message | Carol Walter | 2008-04-29 13:59:40 | Error on pg_dumpall |