From: Craig Ringer <ringerc@ringerc.id.au>
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Merging two databases
Date: Wed, 13 Jun 2012 10:08:46 +0800
Message-ID: <4FD7F62E.9020405@ringerc.id.au> (raw)
In-Reply-To: <CAGWYGjU6NqpkKgLd+vv1sGKxiJc9FmtobxQz4eitMshR0zTmNA@mail.gmail.com>
References: <CAGWYGjU6NqpkKgLd+vv1sGKxiJc9FmtobxQz4eitMshR0zTmNA@mail.gmail.com>
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
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-admin@postgresql.org
Cc: ringerc@ringerc.id.au, lukasz.brodziak@gmail.com
Subject: Re: Merging two databases
In-Reply-To: <4FD7F62E.9020405@ringerc.id.au>
* 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