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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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