Thread: paertially restoring a DB

paertially restoring a DB

From
nialllinden@yahoo.com (Niall Linden)
Date:
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


Re: paertially restoring a DB

From
"Iain"
Date:
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" <nialllinden@yahoo.com>
To: <pgsql-sql@postgresql.org>
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