Re: pg_dump and large object?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Paul Skinner" <skin(at)skin(dot)dhs(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_dump and large object?
Date: 2000-08-20 17:41:47
Message-ID: 10573.966793307@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Paul Skinner" <skin(at)skin(dot)dhs(dot)org> writes:
> How should one go about backing up large objects from a DB as pg_dump only
> handles the internal data and structures?

There is a pg_dumplo utility in contrib/ in current sources. I don't
think it existed in 7.0.*, but you could probably grab the current
snapshot and compile up pg_dumplo against your 7.0.* installation.
(Disclaimer: I haven't tried it personally, don't know if it works.)

> Do I just copy the files? If the worst does happen, I can restore from the
> pg_dump file and copy all the xinv and invx files back?

That will not work...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message doug 2000-08-21 18:29:31 Re: How to connect applet to different SQL server.
Previous Message Mike White 2000-08-20 13:38:00 starting postgres