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 Daniel.Crespo@l-3com.com
Subject Re: How to merge data from two separate databases into one (maybe using xlogs)?
Date
Msg-id 9E33F44949583B4597BDA2D0604256700B8FEF02@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)?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
> On Wed, Oct 27, 2010 at 5:19 PM,  <Daniel.Crespo@l-3com.com> 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 at Bucardo if you want multi-master
> replication.

Thanks for your response, Vick.

Unfortunately, I need to replicate DDLs, therefore Bucardo is not an
option. I was thinking about having a way to replay xlogs from different
servers into one, to have "all" data. I just don't know if it's
possible. Anybody knows?

Thanks,
-Daniel

pgsql-general by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: Printing command string passed to EXECUTE command in plpgsql (after argument resolution)
Next
From: Allan Kamau
Date:
Subject: Re: Printing command string passed to EXECUTE command in plpgsql (after argument resolution)