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@cisco.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