Re: Restoring normal master-slave roles after replication failure

>
> 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