Thread: dumping and reloading ONLY large objects

Hi,

I've just dumped and reloaded a database to put it on a different
server, but forgot the large objects (silly me). Now some of the data on
the new server have already been modified, so I can't just repeat with
large objects, as in

pg_dump -Ft --blobs mydb > db.tar

What I'd need is to dump ONLY the large objects and reload those into
the new db. Such a procedure, however, does not seem to be doumented.

Is it still possible somehow?

Cheers, Frank

Frank Joerdens <frank@joerdens.de> writes:
> What I'd need is to dump ONLY the large objects and reload those into
> the new db. Such a procedure, however, does not seem to be doumented.

I don't think that the current code supports that, but it seems like
it'd be reasonably easy to modify pg_dump to dump only blobs, or to
modify pg_restore to extract only blobs from a dump file.

            regards, tom lane