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

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