Skip site navigation (1) Skip section navigation (2)

Error on pg_dumpall

From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Error on pg_dumpall
Date: 2008-04-29 13:59:40
Message-ID: 88728013-4F8D-4A5D-AE5F-8DB2B73D6D7A@indiana.edu (view raw or flat)
Thread:
Lists: pgsql-admin
Greetings,

I'm having a problem that I hope you can help me with.  I am getting  
the following error when I try to run pg_dumpall.

postgres(at)machine1:~$ /usr/local/pgsql/bin/pg_dumpall
pg_dumpall: could not connect to database "template1": could not  
connect to server: No such file or directory
         Is the server running locally and accepting
         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

If I run the command "psql template1", I can connect to template1  
just fine.  It looks like pg_dumpall may be looking for template1 in  
the wrong place.

This is a new installation of postgresql 8.3 on a Debian Linux  
machine.  All my other machines are Solaris 10 running PostgreSQL 8.2.

Thanks,

Carol Walter

Responses

pgsql-admin by date

Next:From: Julian v. BockDate: 2008-04-29 14:37:38
Subject: Re: Error on pg_dumpall
Previous:From: Balaji KasthuriranganDate: 2008-04-29 13:53:39
Subject: could not bind IPv4 socket

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group