Skip site navigation (1) Skip section navigation (2)

Need help/suggestions with backup/restore of database tables.

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 (view raw or flat)
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

In response to

pgsql-admin by date

Next:From: Anagha JoshiDate: 2003-06-25 04:34:29
Subject: database & table size
Previous:From: scott.marloweDate: 2003-06-24 14:21:28
Subject: Re: locking all databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group