Philip Crotwell <crotwell@seis.sc.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