Message-ID: <4FDA2EAC.3010407@d2.com>
Date: Thu, 14 Jun 2012 11:34:20 -0700
From: Amador Alvarez <aalvarez@d2.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US;
	rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19
MIME-Version: 1.0
To: 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

Hi,
Obviously it will always depends on the constraints in your schema, but 
why do not dump the databases out and import it into a single one 
properly? Once you get the new database, it should be easy to catch up 
with the 2 databases before the switching (with statements like 
insert/update into Newdb tables ...(select from Olddb tables)).
It is up to you, this is to avoid replication settings, however using 
replication could be a good thing for future replication experiences.

A.A.


On 06/12/2012 03:23 AM, 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? Of course when the
> merged db is created it will be only updated/inserted with new data
> from each of source DBs.
>