Message-ID: <4EA5E253.6020600@cisco.com>
Date: Mon, 24 Oct 2011 16:10:27 -0600
From: Krishnamurthy Radhakrishnan <kradhak@cisco.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6;
	rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Dumping data using pg_dump after chrooting to a different partition
Content-Type: multipart/alternative;
	boundary="------------040208000502040103070305"

This is a multi-part message in MIME format.
--------------040208000502040103070305
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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>

pg_dump works before chrooting to the secondary partition. Can you 
please provide a way to dump the data after chrooting?

Thanks for your help.

Radha


--------------040208000502040103070305
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hi,<br>
    <br>
    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.<br>
    <br>
    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:<br>
    <ul>
      <li>chroot to a secondary partition on the server.</li>
      <li>install the software RPMs including PostgreSQL RPMs</li>
      <li>start a secondary instance of PostgreSQL DB server using a
        different port and data directory.</li>
      <li>run pg_dump to dump the data from the primary instance to a
        file.</li>
      <li>run psql to import the data from the file into the secondary
        instance.</li>
    </ul>
    However when I tried to perform the pg_dump as mentioned above, I
    get the following error:<br>
    pg_dump: [archiver (db)] connection to database "TestDB" failed:
    could not connect to server: No such file or
    directory|&lt;LVL::Debug&gt;<br>
    Is the server running locally and accepting|&lt;LVL::Debug&gt;<br>
    connections on Unix domain socket
    "/tmp/.s.PGSQL.5432"?|&lt;LVL::Debug&gt;<br>
    <br>
    pg_dump works before chrooting to the secondary partition. Can you
    please provide a way to dump the data after chrooting?<br>
    <br>
    Thanks for your help.<br>
    <br>
    Radha<br>
    <br>
    <br>
  </body>
</html>

--------------040208000502040103070305--