Merging two databases

From: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Merging two databases
Date: 2012-06-12 10:23:41
Message-ID: CAGWYGjU6NqpkKgLd+vv1sGKxiJc9FmtobxQz4eitMshR0zTmNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

--
Łukasz Brodziak

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Magnus Hagander 2012-06-12 14:27:43 Re: could not rename temporary statistics file "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": No such file or directory
Previous Message Craig Ringer 2012-06-12 08:11:26 Re: How to setup PostgreSQL using Windows Authentication?