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

Reply via email to