From: nialllinden@yahoo.com
To: pgsql-sql@postgresql.org
Subject: paertially restoring a DB
Date: 29 Oct 2004 07:04:25 -0700
Message-ID: <52684575.0410290604.5f906666@posting.google.com> (raw)
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
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: nialllinden@yahoo.com
Subject: Re: paertially restoring a DB
In-Reply-To: <52684575.0410290604.5f906666@posting.google.com>
* 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