Hi,
What you are trying to do should be possible as far as I know.
Did you use the custom format for your dump (pg_dump -Fc)? Try extracting a list of contents of the dump (pg_restore --list) option and check that for anything that might be causing you to lose that table. Comment out any offending lines and restore using the --use-list option.
If you used the custom format you have a lot of options for extracting individual table data and stuff like that.
Good luck,
Iain
----- Original Message ----- From: "Niall Linden" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 29, 2004 11:04 PM
Subject: [SQL] paertially restoring a DB
i am having a problem with dump and restore. basically i have 2 databases
maindb and tempdb
the databases are almost the same but the main db has some extra tables which dont change. what i need to do is get all the information form the temp db and put it in the main db. the tempdb should overwrite all the data in the main db, but the tables that exist in the maindb only should remain
ie maindb has tables: dbsettings, data1, data2 tempdb has tables: data1, data2
then the tables (and data) data1,2 from tempdb should overwrite their corresponding tables but dbsettings should remain unchanged in maindb.
any things ive tried overwrite all the tables and i loose dbsettings table completely (not good)
any help appreciated
Niall
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
