Re: Restoring normal master-slave roles after replication failure

Поиск
Список
Период
Сортировка
От Gilberto Castillo
Тема Re: Restoring normal master-slave roles after replication failure
Дата
Msg-id 38093.192.168.207.54.1427913656.squirrel@webmail.etecsa.cu
обсуждение исходный текст
Ответ на Re: Restoring normal master-slave roles after replication failure  (Alex Balashov <abalashov@evaristesys.com>)
Ответы Re: Restoring normal master-slave roles after replication failure  (Alex Balashov <abalashov@evaristesys.com>)
Список pgsql-admin

>
> Hi Gilberto,
>
> On 04/01/2015 02:29 PM, Gilberto Castillo wrote:
>
>> Have you seen pgpool or rpmgr-3?
>
> I have, but prefer not to use these tools if possible as it would
> complicate the setup.
>
> I'm not so much looking for front-end simplicity as I am looking for a
> way to avoid having to do a base backup back to the master. I am fine
> with having to reconfigure master and slave roles manually.

I commented, and I used pgpool ensures failover  a transparent manner to
end users.
Now use rpmgr-3, which allows me the same; but without the complicated
motaje of pgpool.

But if you want to do manuel, you define archive_command = "hot_stanby" on
both nodes


Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba
---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>

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

Предыдущее
От: Alex Balashov
Дата:
Сообщение: Re: Restoring normal master-slave roles after replication failure
Следующее
От: Alex Balashov
Дата:
Сообщение: Re: Restoring normal master-slave roles after replication failure