From: Craig James <craig_james@emolecules.com>
To: pgsql-admin@postgresql.org
Subject: Re: Dumping data using pg_dump after chrooting to a different partition
Date: Mon, 24 Oct 2011 15:45:34 -0700
Message-ID: <4EA5EA8E.5090406@emolecules.com> (raw)
In-Reply-To: <4EA5E253.6020600@cisco.com>
References: <4EA5E253.6020600@cisco.com>
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
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: craig_james@emolecules.com
Subject: Re: Dumping data using pg_dump after chrooting to a different partition
In-Reply-To: <4EA5EA8E.5090406@emolecules.com>
* 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