From: Tom Lane <tgl@sss.pgh.pa.us>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Error on pg_dumpall
Date: Tue, 29 Apr 2008 10:45:30 -0400
Message-ID: <1318.1209480330@sss.pgh.pa.us> (raw)
In-Reply-To: <88728013-4F8D-4A5D-AE5F-8DB2B73D6D7A@indiana.edu>
References: <88728013-4F8D-4A5D-AE5F-8DB2B73D6D7A@indiana.edu>
Carol Walter <walterc@indiana.edu> writes:
> 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@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.
Does "which psql" say that you're using the psql in
/usr/local/pgsql/bin?
It sounds to me a bit like you have two sets of PG programs with
different default port numbers compiled into them. Which port is
the server actually listening on?
> This is a new installation of postgresql 8.3 on a Debian Linux
> machine.
Debian is a rather nasty environment for custom-built PG installations,
because they have their own ideas of where to put the PG programs
and what port numbers they should run on. I'm thinking you are
connecting to a Debian-supplied postmaster on a non-standard port,
and not to your own installation at all.
regards, tom lane
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: tgl@sss.pgh.pa.us, walterc@indiana.edu
Subject: Re: Error on pg_dumpall
In-Reply-To: <1318.1209480330@sss.pgh.pa.us>
* 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