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 по дате отправления: