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
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 |