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

Krishnamurthy Radhakrishnan <kradhak@xxxxxxxxx> · Mon, 24 Oct 2011 16:25:21 -0600

    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@xxxxxxxxx> 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