Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id CE828D33CC1
	for <pgsql-admin@postgresql.org>; Tue, 12 Jun 2012 23:09:10 -0300 (ADT)
Received: from mail-pz0-f46.google.com ([209.85.210.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1Sed18-0000E5-MR
	for pgsql-admin@postgresql.org; Wed, 13 Jun 2012 02:09:08 +0000
Received: by dady13 with SMTP id y13so259511dad.19
	for <pgsql-admin@postgresql.org>; Tue, 12 Jun 2012 19:08:52 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding
	:x-gm-message-state;
	bh=gTcihnPLXvYRNzq0iB4ycUTNQe1NdftTQn4aRL/KdeA=;
	b=kPVyvpUatXwCx+5lC/kxvCLaFkze6bcje3GGR06KRrUGapShaHJcTnzzRCPfhIbjuq
	q9ryCzqUQqfzMLdbQvJPGsifhy8d0OoUJtUomRhsNRyYxkXnAo3ZWhWmHCXXtVC3jrNj
	qFwhZ3m3XCmZGY9dJkGtRYxJwFrDU12SgyQyMDmkQ/Xil6TrFKgJj8ovafOaJ1Ld6kY0
	3JvXCq5/Nbcod6xV6l9i5piLzsknvYAoE8og5+R8DBFEgowzFFrGwrorvCPCcIL5itxp
	ObzGZylF5HrPcv9RoiSyVK3/7W2lgA6aGAnQOgTmJbx51q4+CBgAf1R5RL84Yj472vbe
	y2PQ==
Received: by 10.68.134.161 with SMTP id pl1mr44965191pbb.29.1339553332143;
	Tue, 12 Jun 2012 19:08:52 -0700 (PDT)
Received: from ayaki.localdomain (office1.postnewspapers.com.au.
	[150.101.171.128])
	by mx.google.com with ESMTPS id jp3sm3984108pbc.7.2012.06.12.19.08.49
	(version=SSLv3 cipher=OTHER); Tue, 12 Jun 2012 19:08:51 -0700 (PDT)
Message-ID: <4FD7F62E.9020405@ringerc.id.au>
Date: Wed, 13 Jun 2012 10:08:46 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:13.0) Gecko/20120605 Thunderbird/13.0
MIME-Version: 1.0
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Merging two databases
References: 
 <CAGWYGjU6NqpkKgLd+vv1sGKxiJc9FmtobxQz4eitMshR0zTmNA@mail.gmail.com>
In-Reply-To: 
 <CAGWYGjU6NqpkKgLd+vv1sGKxiJc9FmtobxQz4eitMshR0zTmNA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Gm-Message-State: 
 ALoCoQlVI/f1j3oFT0BvZIv1S3MIpwZyI2GpLre9WZ6ZKFCxiujIc/5eSgYO5h7mja10PkypIAKA
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201206/68
X-Sequence-Number: 39659

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