Skip site navigation (1) Skip section navigation (2)

Re: Dumping data using pg_dump after chrooting to a different partition

From: Krishnamurthy Radhakrishnan <kradhak(at)cisco(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Dumping data using pg_dump after chrooting to a different partition
Date: 2011-10-24 22:25:21
Message-ID: 4EA5E5D1.8020804@cisco.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Kevin,

Can you please elaborate how to do the following?

connecting through a TCP connection and piping directly
from pg_dump to psql

Since we could have DB schema changes between the versions, we may not 
be able to copy the data directory.

Does pg_upgrade support changes to the schema?

Thanks.

Radha

On 10/24/11 4:17 PM, Kevin Grittner wrote:
> Krishnamurthy Radhakrishnan<kradhak(at)cisco(dot)com>  wrote:
>
>> pg_dump works before chrooting to the secondary partition. Can
>> you please provide a way to dump the data after chrooting?
>
> How about connecting through a TCP connection and piping directly
> from pg_dump to psql?
>
> Of course, these days you have the option of just using pg_upgrade
> against the original or a deep copy of the data directory.
>
> -Kevin

In response to

pgsql-admin by date

Next:From: Craig JamesDate: 2011-10-24 22:45:34
Subject: Re: Dumping data using pg_dump after chrooting to a different partition
Previous:From: Kevin GrittnerDate: 2011-10-24 22:17:41
Subject: Re: Dumping data using pg_dump after chrooting to a different partition

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group