From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexander Stanier <alexander.stanier@egsgroup.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Moving multiple schemas when upgrading from 8.1 to 8.2
Date: Thu, 18 Oct 2007 15:29:44 -0400
Message-ID: <27396.1192735784@sss.pgh.pa.us> (raw)
In-Reply-To: <47177426.1050801@egsgroup.com>
References: <47177426.1050801@egsgroup.com>
Alexander Stanier <alexander.stanier@egsgroup.com> writes:
> I also thought maybe I could run the 8.2.x pg_dump binary against the
> 8.1.5 cluster? But I wasn't sure if this was 'allowed' and if it would
> produce a valid data dump?
Not only is that allowed, it's recommended. The case that won't work
(or at least doesn't work in some combinations, I'm not sure about 8.1
vs 8.2 specifically) is trying to load the output of 8.2 pg_dump back
into 8.1, since the newer pg_dump may make use of commands that didn't
exist before. But for an upgrade, using the newer pg_dump is considered
good practice.
> Am I missing a really obvious way to accomplish this?
For the record, you could also have fixed it by using pg_restore's
-l and -L switches --- that is, create a table-of-contents listing,
edit out the unwanted objects, and use that to select what to restore.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, alexander.stanier@egsgroup.com
Subject: Re: Moving multiple schemas when upgrading from 8.1 to 8.2
In-Reply-To: <27396.1192735784@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox