Philip Crotwell <[EMAIL PROTECTED]> 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
pg_dumplo_old.tar.gz
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly