Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 341BC2E0041 for ; Tue, 29 Apr 2008 12:01:15 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47391-01 for ; Tue, 29 Apr 2008 12:01:05 -0300 (ADT) X-Greylist: delayed 00:23:27.631686 by SQLgrey-1.7.5 Received: from mx.openit.de (mx.openit.de [217.69.65.200]) by developer.postgresql.org (Postfix) with ESMTP id E60F32E0032 for ; Tue, 29 Apr 2008 12:01:04 -0300 (ADT) Received: from warpcore.openit.de (warpcore.openit.de [217.69.64.254]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mx.openit.de (Postfix) with ESMTP id 4BBDC100107 for ; Tue, 29 Apr 2008 16:37:39 +0200 (CEST) Received: from warpcore.openit.de (localhost [127.0.0.1]) by warpcore.openit.de (8.13.1/8.13.1) with ESMTP id m3TEbcnB015130 for ; Tue, 29 Apr 2008 16:37:39 +0200 Received: (from julian@localhost) by warpcore.openit.de (8.13.1/8.13.1/Submit) id m3TEbcLO015129; Tue, 29 Apr 2008 16:37:38 +0200 X-Authentication-Warning: warpcore.i.openit.de: julian set sender to bock@openit.de using -f To: pgsql-admin@postgresql.org Subject: Re: Error on pg_dumpall X-Face: $~?g2!-On|QWPz8qkxU3V^DL7_Tli#/R8{t\$SYTT,/`5"; d|]YB@q/9_|NP; |:tK&kx:n7f=%y:G)b0$[Y{}F_@"gb6WsI_LV8"%F7-|Kd="x6g18{t|/Gan9"&C!t_$6(HTf-1.}t/]RUW4k-; O6j5+FEyG29jrf,f?hKqa*l]*DVr; nhJN)+~H5&Xm&M\m_&rX/+WL Organization: OpenIT GmbH From: bock@openit.de (Julian v. Bock) In-Reply-To: <88728013-4F8D-4A5D-AE5F-8DB2B73D6D7A@indiana.edu> (Carol Walter's message of "Tue, 29 Apr 2008 09:59:40 -0400") References: <88728013-4F8D-4A5D-AE5F-8DB2B73D6D7A@indiana.edu> Date: Tue, 29 Apr 2008 16:37:38 +0200 Message-ID: User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/281 X-Sequence-Number: 29045 Hi >>>>> "CW" =3D=3D Carol Walter 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 --=20 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=FCsseldorf http://www.openit.de ________________________________________________________________ HRB 38815 Amtsgericht D=FCsseldorf USt-Id DE 812951861 Gesch=E4ftsf=FChrer: Susanne Schultz, Oliver Haakert, Maurice Kemmann