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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Daniel(dot)Crespo(at)l-3com(dot)com
Cc: 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-28 20:02:41
Message-ID: 4CC9D6E1.6020305@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/28/10 12:55 PM, Daniel(dot)Crespo(at)l-3com(dot)com wrote:
>> you want multimaster replication WITH multimaster DDL changes?
>>
>>
>> wow.
>>
>> how do you resolve conflicts?
>>
> I don't know how to get to that point yet. The question is: Can I use
> xlogs from two different servers and replay them all in one? Depending
> on how it is done, I can tell you how would I resolve the conflicts.

xlogs just contain blocks by block number. not high level SQL
operations that could be resolved.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-10-28 20:50:29 Replication Poll
Previous Message Dann Corbit 2010-10-28 20:00:49 Re: Full Text Search - Slow on common words