Skip site navigation (1) Skip section navigation (2)

Re: Merging two databases

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Merging two databases
Date: 2012-06-13 02:08:46
Message-ID: 4FD7F62E.9020405@ringerc.id.au (view raw or flat)
Thread:
Lists: pgsql-admin
On 06/12/2012 06:23 PM, 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?
I think you'll want Bucardo or Slony-I for this. You certainly can't do 
it with the built-in replication.

--
Craig Ringer

In response to

pgsql-admin by date

Next:From: Craig RingerDate: 2012-06-13 02:20:34
Subject: Re: How to setup PostgreSQL using Windows Authentication?
Previous:From: Peter CheungDate: 2012-06-13 00:24:47
Subject: How to install Postgresql with GSSAPI support using One click installer?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group