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

2010-10-28 Thread Daniel . Crespo
> 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 wou

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

2010-10-28 Thread Daniel . Crespo
> On Wed, Oct 27, 2010 at 5:19 PM, wrote: > > 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. > > > > Again, I recommend you look

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

2010-10-27 Thread Daniel . Crespo
> On Wed, Oct 27, 2010 at 4:37 PM, Lennin Caro 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 l

[GENERAL] How to merge data from two separate databases into one (maybe using xlogs)?

2010-10-27 Thread Daniel . Crespo
Hi, The quick question is: How (if possible) can I do to get data (maybe through xlogs) from two separate databases and merge them into one? For those that want to know my situation, here it is: I have two postgresql 9.0 that are working as master/slave using streaming replication. At