Obviously it will always depends on the constraints in your schema, but
why do not dump the databases out and import it into a single one
properly? Once you get the new database, it should be easy to catch up
with the 2 databases before the switching (with statements like
insert/update into Newdb tables ...(select from Olddb tables)).
It is up to you, this is to avoid replication settings, however using
replication could be a good thing for future replication experiences.
On 06/12/2012 03:23 AM, Lukasz Brodziak wrote:
> Hi there,
> Is there a way of merging two databases in postgresql in the way of
> differential replication? The thing is that we have two DBs with same
> schemas and we want to merge the data within them into one single
> replica. Are there any tools/ways of doing this? Of course when the
> merged db is created it will be only updated/inserted with new data
> from each of source DBs.
In response to
pgsql-admin by date
|Next:||From: Vishwas Dwivedi||Date: 2012-06-15 13:16:31|
|Subject: Issue in save and retreive file in postgres|
|Previous:||From: Fabricio||Date: 2012-06-14 07:33:45|
|Subject: Re: (new thread) could not rename temporary statistics file
"pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": No such file or