large objects missing

[Warren Little]

In an attempt to migrate from 7.3 to 7.4 doing a pg_dumpall I did not
get any of my large objects. Is there a special process which needs to
take place and is there a way to simple copy the large objects
seperately?
--
Warren Little
Senior Vice President
Secondary Marketing
Security Lending Wholesale, LC
www.securitylending.com
Tel: [phone]
Fax: [phone]

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Warren Little]

I'm in a bit of a pickle on this, so if anyone has some immediate
suggestion it would be very much appreciated

Post by Warren Little
In an attempt to migrate from 7.3 to 7.4 doing a pg_dumpall I did not
get any of my large objects. Is there a special process which needs to
take place and is there a way to simple copy the large objects
seperately?

--
Warren Little
Senior Vice President
Secondary Marketing
Security Lending Wholesale, LC
www.securitylending.com
Tel: [phone]
Fax: [phone]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Tom Lane]

Post by Warren Little
In an attempt to migrate from 7.3 to 7.4 doing a pg_dumpall I did not
get any of my large objects. Is there a special process which needs to
take place and is there a way to simple copy the large objects
seperately?

pg_dumpall doesn't handle large objects, because it can only do textual
output format and pg_dump doesn't have a way to dump large objects
textually. What you have to do at the moment is use pg_dump
individually on each DB that contains large objects, specifying either
-Fc or -Ft (I'd recommend the former) plus -b to dump blobs. Then
pg_restore each of these dumps. I think you can use pg_restore's list
option to select just the blobs to be restored, but I'm not sure how
well that really works when the destination DB has already been modified
to some extent. You'd be well advised to experiment in a scratch copy
of the database before you try it on your live DB.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster