Re: dumping and reloading ONLY large objects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Frank Joerdens <frank(at)joerdens(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dumping and reloading ONLY large objects
Date: 2001-08-04 17:17:24
Message-ID: 29317.996945444@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Frank Joerdens <frank(at)joerdens(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-08-04 17:18:00 Re: HELP! BUG? pg_dump mucks up grant/revoke
Previous Message Tom Lane 2001-08-04 16:28:12 Re: HELP! BUG? pg_dump mucks up grant/revoke