Message-ID: <4EA6269A.7040803@cisco.com>
Date: Mon, 24 Oct 2011 21:01:46 -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: Craig James <craig_james@emolecules.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Dumping data using pg_dump after chrooting to a different
	partition
References: <4EA5E253.6020600@cisco.com> <4EA5EA8E.5090406@emolecules.com>
In-Reply-To: <4EA5EA8E.5090406@emolecules.com>
Content-Type: multipart/alternative;
	boundary="------------040506060109010801030202"

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

Thanks Craig.

After configuring to accept TCP connections on port 5432, I tried to 
specify the hostname as shown below and that didn't help. Is there 
anything else that needs to be configured?
pg_dump -h bldr-ccm36.cisco.com -p 5432 -a -U postgres
pg_dump: [archiver (db)] connection to database "postgres" failed: could 
not connect to server: Connection refused
     Is the server running on host "bldr-ccm36.cisco.com" and accepting
     TCP/IP connections on port 5432?

Radha

On 10/24/11 4:45 PM, Craig James wrote:
> 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


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

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Thanks Craig. <br>
    <br>
    After configuring to accept TCP connections on port 5432, I tried to
    specify the hostname as shown below and that didn't help. Is there
    anything else that needs to be configured?<br>
    pg_dump -h bldr-ccm36.cisco.com -p 5432 -a -U postgres<br>
    pg_dump: [archiver (db)] connection to database "postgres" failed:
    could not connect to server: Connection refused<br>
    &nbsp;&nbsp;&nbsp; Is the server running on host "bldr-ccm36.cisco.com" and
    accepting<br>
    &nbsp;&nbsp;&nbsp; TCP/IP connections on port 5432?<br>
    <br>
    Radha<br>
    <br>
    On 10/24/11 4:45 PM, Craig James wrote:
    <blockquote cite="mid:4EA5EA8E.5090406@emolecules.com" type="cite">
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="Content-Type">
      On 10/24/11 3:10 PM, Krishnamurthy Radhakrishnan wrote:
      <blockquote cite="mid:4EA5E253.6020600@cisco.com" type="cite">
        <meta http-equiv="content-type" content="text/html;
          charset=ISO-8859-1">
        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>
      </blockquote>
      I suspect the problem is that localhost sockets on Unix/Linux are
      actual implemented as file-system sockets rather than TCP/IP
      sockets.&nbsp; If you do chroot, those files won't exist.&nbsp; Try
      connecting using a "-h hostname (e.g. -h myserver.domain.com)
      rather than the default localhost.&nbsp; You may have to reconfigure
      your server to listen on port 80.<br>
      <br>
      Craig<br>
    </blockquote>
    <br>
  </body>
</html>

--------------040506060109010801030202--