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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Craig James | 2011-10-24 22:45:34 | Re: Dumping data using pg_dump after chrooting to a different partition |
Previous Message | Kevin Grittner | 2011-10-24 22:17:41 | Re: Dumping data using pg_dump after chrooting to a different partition |