Postgres Pro
Downloads
Home   >   mailing lists

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

From John R Pierce
Subject Re: How to merge data from two separate databases into one (maybe using xlogs)?
Date
Msg-id 4CC9D6E1.6020305@hogranch.com
Whole thread Raw
In response to Re: How to merge data from two separate databases into one (maybe using xlogs)?  (Daniel.Crespo@l-3com.com)
List pgsql-general
Tree view 
On 10/28/10 12:55 PM, Daniel.Crespo@l-3com.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.

pgsql-general by date:

Previous
From: Dann Corbit
Date:
Subject: Re: Full Text Search - Slow on common words
Next
From: "Joshua D. Drake"
Date:
Subject: Replication Poll