Skip site navigation (1) Skip section navigation (2)

Re: Moving multiple schemas when upgrading from 8.1 to 8.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Stanier <alexander(dot)stanier(at)egsgroup(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Moving multiple schemas when upgrading from 8.1 to 8.2
Date: 2007-10-18 19:29:44
Message-ID: 27396.1192735784@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Alexander Stanier <alexander(dot)stanier(at)egsgroup(dot)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

In response to

pgsql-admin by date

Next:From: Sarah MaaroufDate: 2007-10-18 20:51:41
Subject: unable to install postgresql-8.1.3-1.zip for winxp
Previous:From: Irina SourikovaDate: 2007-10-18 18:59:27
Subject: Re: does vacuumlo removes BLOBs from deleted tables?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group