From: bock@openit.de
To: pgsql-admin@postgresql.org
Subject: Re: Error on pg_dumpall
Date: Tue, 29 Apr 2008 16:37:38 +0200
Message-ID: <lpwsmgg219.fsf@warpcore.i.openit.de> (raw)
In-Reply-To: <88728013-4F8D-4A5D-AE5F-8DB2B73D6D7A@indiana.edu>
References: <88728013-4F8D-4A5D-AE5F-8DB2B73D6D7A@indiana.edu>
Hi
>>>>> "CW" == Carol Walter <walterc@indiana.edu> writes:
CW> postgres@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bock@openit.de
Subject: Re: Error on pg_dumpall
In-Reply-To: <lpwsmgg219.fsf@warpcore.i.openit.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox