On 10/24/11 3:10 PM, Krishnamurthy Radhakrishnan wrote:
Hi,
I am new to PostgreSQL. We are using PostgreSQL 9.0.2 on our linux
server. We have an instance of PostgreSQL 9.0 running using the
primary partition on the server.
We want to use the pg_dump and psql programs to migrate the data
during our software upgrade process. For upgrade, we plan to do
the following:
- chroot to a secondary partition on the server.
- install the software RPMs including PostgreSQL RPMs
- start a secondary instance of PostgreSQL DB server using a
different port and data directory.
- run pg_dump to dump the data from the primary instance to a
file.
- run psql to import the data from the file into the secondary
instance.
However when I tried to perform the pg_dump as mentioned above, I
get the following error:
pg_dump: [archiver (db)] connection to database "TestDB" failed:
could not connect to server: No such file or
directory|<LVL::Debug>
Is the server running locally and accepting|<LVL::Debug>
connections on Unix domain socket
"/tmp/.s.PGSQL.5432"?|<LVL::Debug>
I suspect the problem is that localhost sockets on Unix/Linux are
actual implemented as file-system sockets rather than TCP/IP
sockets. If you do chroot, those files won't exist. Try connecting
using a "-h hostname (e.g. -h myserver.domain.com) rather than the
default localhost. You may have to reconfigure your server to
listen on port 80.
Craig
|
