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?
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.
In response to
pgsql-admin by date
|Next:||From: Craig James||Date: 2011-10-24 22:45:34|
|Subject: Re: Dumping data using pg_dump after chrooting to a different
|Previous:||From: Kevin Grittner||Date: 2011-10-24 22:17:41|
|Subject: Re: Dumping data using pg_dump after chrooting to a different partition|