From: | "Chris White (cjwhite)" <cjwhite(at)cisco(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Need help/suggestions with backup/restore of database tables. |
Date: | 2003-06-24 17:01:54 |
Message-ID: | 002001c33a72$50e4f1d0$55936b80@amer.cisco.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I have four tables in a database which reference all the large objects
in the database. I need to backup and restore these 4 tables and the
large objects independently of the other tables in the database.
pg_dump only allows me to dump the whole database, if I want to dump the
large objects. I know that on restore I can create a contents file from
the pg_dump file and selectively restore only the tables I need, but
this is not suitable because:
1) Restore data is streamed from a remote ftp server.
2) Backup file is large.
3) There is not enough physical storage to copy the restore file to disk
prior to restoring the database, so I can create the contents list
without reading file twice over ftp link.
Does anybody have any suggestions apart from writing my own custom
backup/restore?
Chris White
From | Date | Subject | |
---|---|---|---|
Next Message | Anagha Joshi | 2003-06-25 04:34:29 | database & table size |
Previous Message | scott.marlowe | 2003-06-24 14:21:28 | Re: locking all databases |