Re: bi-directional syncing help request - Mailing list pgsql-general

From bricklen
Subject Re: bi-directional syncing help request
Date
Msg-id CAGrpgQ_7R2cXqXwW=rF1=Uf4qVk21H3e+VXOieWN61g8sTZWdg@mail.gmail.com
Whole thread Raw
In response to Re: bi-directional syncing help request  (Bèrto ëd Sèra <berto.d.sera@gmail.com>)
Responses Re: bi-directional syncing help request  (Bèrto ëd Sèra <berto.d.sera@gmail.com>)
Re: bi-directional syncing help request  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-general
On Fri, Aug 9, 2013 at 7:36 AM, Bèrto ëd Sèra <berto.d.sera@gmail.com> wrote:
--all you need to do is switch master and slave so that "master" is the one box you are currently on

That probably isn't a reasonable solution, considering the OP mentioned that she was not a professional DBA. Setting up a hot/warm standby, failing over, resetting the slave from the new master, lather, rinse, repeat  is certainly scriptable but doesn't seem like the best option here.

I don't know of any commercial solutions, but writing some code might be required. Synchronizing data isn't that difficult, but synchronizing changes to database table structure will be a bit tricky,

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres won't start
Next
From: Bèrto ëd Sèra
Date:
Subject: Re: bi-directional syncing help request