Re: bi-directional syncing help request

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: bi-directional syncing help request
Дата
Msg-id 1376083701.37700.YahooMailNeo@web162906.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на Re: bi-directional syncing help request  (bricklen <bricklen@gmail.com>)
Список pgsql-general
bricklen <bricklen@gmail.com> wrote:
> 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.

Not only that, but she mentioned that her laptop is a Mac and the
office machine is a Linux server.  A solution would probably need
to use *logical* copies like pg_dump, slony, or Londiste.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Pl/Python runtime overhead
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: plpgsql FOR LOOP CTE problem ?