Re: pgdump, large objects and 7.0->7.1

Philip Crotwell <crotwell(at)seis(dot)sc(dot)edu> writes:
> So, 3 questions that basically boil down to "What is the best way to move
> large objects from 7.0 to 7.1."

> 1) Can I use the 7.1 pgdumpall to dump a 7.0.3 database? The docs say no,
> but worth a try.

The docs say no, and they mean no.

There is a new contrib utility that can be used to pull large objects
from a 7.0 (or older) database. Unfortunately the version that's in
contrib right now will only talk to 7.1 :-(. I've attached a tarfile
for a version that works with 7.0.*.

> 3) Do I need to preserve oid's when with pgdump using large objects?

No, pg_dumplo takes care of that.

regards, tom lane