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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Krishnamurthy Radhakrishnan" <kradhak(at)cisco(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Dumping data using pg_dump after chrooting to a different partition
Date: 2011-10-24 22:17:41
Message-ID: 4EA59DB50200002500042527@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Krishnamurthy Radhakrishnan 2011-10-24 22:25:21 Re: Dumping data using pg_dump after chrooting to a different partition
Previous Message Krishnamurthy Radhakrishnan 2011-10-24 22:10:27 Dumping data using pg_dump after chrooting to a different partition