Re: How to merge data from two separate databases into one (maybe using xlogs)? - Mailing list pgsql-general

From Daniel.Crespo@l-3com.com
Subject Re: How to merge data from two separate databases into one (maybe using xlogs)?
Date
Msg-id 9E33F44949583B4597BDA2D0604256700B8FEBC9@FLS-EXCHANGE.corp.sds.l-3com.com
Whole thread Raw
In response to Re: How to merge data from two separate databases into one (maybe using xlogs)?  (Vick Khera <vivek@khera.org>)
Responses Re: How to merge data from two separate databases into one (maybe using xlogs)?  (Vick Khera <vivek@khera.org>)
List pgsql-general
> On Wed, Oct 27, 2010 at 4:37 PM, Lennin Caro <lennin.caro@yahoo.com>
wrote:
> IMHO pgpool is the solution
>
> How does that solve the problem of having two disconnected networks,
each thinking their DB is the master?

The original question is how can I do to merge the data of the two
master databases. The answer I'm looking for is the answer to your
question as well. My solution does not solve that problem. I was
thinking about the possibility of shipping all xlogs of both databases
and putting them into the final master (one of them), and replay them to
have all data. Later, I would take care of the conflicts.

Any ideas?

Thanks,
-Daniel

pgsql-general by date:

Previous
From: Michael Clark
Date:
Subject: Should PQconsumeInput/PQisBusy be expensive to use?
Next
From: Alex Hunsaker
Date:
Subject: Re: Should PQconsumeInput/PQisBusy be expensive to use?