From: Iain <iain@mst.co.jp>
To: Niall Linden <nialllinden@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: paertially restoring a DB
Date: Mon, 1 Nov 2004 14:51:33 +0900
Message-ID: <003301c4bfd6$da851d80$7201a8c0@mst1x5r347kymb> (raw)
References: <52684575.0410290604.5f906666@posting.google.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: iain@mst.co.jp, nialllinden@yahoo.com
Subject: Re: paertially restoring a DB
In-Reply-To: <003301c4bfd6$da851d80$7201a8c0@mst1x5r347kymb>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox