Re: How to merge data from two separate databases into one (maybe using xlogs)?

From: Daniel(dot)Crespo(at)l-3com(dot)com
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to merge data from two separate databases into one (maybe using xlogs)?
Date: 2010-10-27 21:19:20
Message-ID: 9E33F44949583B4597BDA2D0604256700B8FEBC9@FLS-EXCHANGE.corp.sds.l-3com.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Wed, Oct 27, 2010 at 4:37 PM, Lennin Caro <lennin(dot)caro(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Hunsaker 2010-10-27 21:30:43 Re: Should PQconsumeInput/PQisBusy be expensive to use?
Previous Message Michael Clark 2010-10-27 21:02:24 Should PQconsumeInput/PQisBusy be expensive to use?