Re: Dumping data using pg_dump after chrooting to a different partition - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Dumping data using pg_dump after chrooting to a different partition
Date
Msg-id 4EA59DB50200002500042527@gw.wicourts.gov
Whole thread Raw
In response to Dumping data using pg_dump after chrooting to a different partition  (Krishnamurthy Radhakrishnan <kradhak@cisco.com>)
Responses Re: Dumping data using pg_dump after chrooting to a different partition
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Krishnamurthy Radhakrishnan
Date:
Subject: Dumping data using pg_dump after chrooting to a different partition
Next
From: Krishnamurthy Radhakrishnan
Date:
Subject: Re: Dumping data using pg_dump after chrooting to a different partition