Re: Moving multiple schemas when upgrading from 8.1 to 8.2

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