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-28 14:49:54
Message-ID: 9E33F44949583B4597BDA2D0604256700B8FEF02@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 5:19 PM, <Daniel(dot)Crespo(at)l-3com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Allan Kamau 2010-10-28 14:59:50 Re: Printing command string passed to EXECUTE command in plpgsql (after argument resolution)
Previous Message Leif Biberg Kristensen 2010-10-28 14:47:15 Re: Printing command string passed to EXECUTE command in plpgsql (after argument resolution)