dumping and reloading ONLY large objects

From: Frank Joerdens <frank(at)joerdens(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: dumping and reloading ONLY large objects
Date: 2001-08-04 11:43:22
Message-ID: 20010804134322.A24241@rakete.joerdens.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message robewald 2001-08-04 12:41:47 Variable number of arguments
Previous Message GH 2001-08-04 10:30:48 Re: Index-speeds