Re: Restoring normal master-slave roles after replication failure - Mailing list pgsql-admin

From Gilberto Castillo
Subject Re: Restoring normal master-slave roles after replication failure
Date
Msg-id 38093.192.168.207.54.1427913656.squirrel@webmail.etecsa.cu
Whole thread Raw
In response to Re: Restoring normal master-slave roles after replication failure  (Alex Balashov <abalashov@evaristesys.com>)
Responses Re: Restoring normal master-slave roles after replication failure
List 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 by date:

Previous
From: Alex Balashov
Date:
Subject: Re: Restoring normal master-slave roles after replication failure
Next
From: Alex Balashov
Date:
Subject: Re: Restoring normal master-slave roles after replication failure