Re: Asynchronous streaming replication in postgresql

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Asynchronous streaming replication in postgresql
Дата
Msg-id CA+U5nMK7jWSp3tx5Ab_UMHyQ2-MxyY3Jr7PNWMAVxaQ20=AHqQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Asynchronous streaming replication in postgresql  ("Deole, Pushkar (Pushkar)" <pdeole@avaya.com>)
Список pgsql-cluster-hackers
Дерево обсуждения 
On 13 March 2015 at 10:28, Deole, Pushkar (Pushkar) <pdeole@avaya.com> wrote:
> Can you elaborate on " Bad idea to do that automatically."
>
> In production, that has to happen automatically, isn't it? There won't be an administrator available all the time to
doa failover in case primary goes down.. 

Automatic failover is OK. Automatic failback is not OK.

>> For #3, this seems to be quite complicated. Is this possible using
>> streaming replication and if yes then how can this be achieved?
>
> Bad idea to do that automatically.


--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services

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

Предыдущее
От: "Deole, Pushkar (Pushkar)"
Дата:
Сообщение: Re: Asynchronous streaming replication in postgresql
Следующее
От: Radovan Jablonovsky
Дата:
Сообщение: postgresq foreign data wrapper with foreign constrain checking, distributed (multi nodes) query execution.