Re: bi-directional syncing help request

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: bi-directional syncing help request
Дата
Msg-id CAGrpgQ_7R2cXqXwW=rF1=Uf4qVk21H3e+VXOieWN61g8sTZWdg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: bi-directional syncing help request  (Bèrto ëd Sèra <berto.d.sera@gmail.com>)
Ответы Re: bi-directional syncing help request
Re: bi-directional syncing help request
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres won't start
Следующее
От: Bèrto ëd Sèra
Дата:
Сообщение: Re: bi-directional syncing help request