Message-ID: <003301c4bfd6$da851d80$7201a8c0@mst1x5r347kymb>
From: "Iain" <iain@mst.co.jp>
To: "Niall Linden" <nialllinden@yahoo.com>,
	<pgsql-sql@postgresql.org>
References: <52684575.0410290604.5f906666@posting.google.com>
Subject: Re: paertially restoring a DB
Date: Mon, 1 Nov 2004 14:51:33 +0900
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="ISO-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

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