Re: [HELP] Query regarding failover

From: Marlene Villanueva <villanuevamarlene906(at)gmail(dot)com>
To: Praveen Kumar K S <praveenssit(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [HELP] Query regarding failover
Date: 2020-07-02 11:33:49
Message-ID: CAA0OsZKo8JXVFqb2L54t6b1uV4C8S3vsFfBLfGci_XOEGcJvOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Cancel switch

On Thu, 2 Jul 2020, 4:26 AM Praveen Kumar K S, <praveenssit(at)gmail(dot)com>
wrote:

> Hello,
>
> Thanks for your response. I will look into it. According to you, which is
> better ? repmgr/patroni for automated switch over and switch back ?
>
> On Wed, Jul 1, 2020 at 1:08 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
> wrote:
>
>> On Tue, 2020-06-30 at 20:54 +0530, Praveen Kumar K S wrote:
>> > My requirement is to set up a process to handle failover and recovery
>> without manual intervention.
>> > I would like to know your suggestions if there is any standard way of
>> doing this or is it better to write custom scripts.
>>
>> I don't think you can do that reliably with "custom scripts".
>> There is no standard way, but have a look at Patroni.
>>
>> Yours,
>> Laurenz Albe
>> --
>> Cybertec | https://www.cybertec-postgresql.com
>>
>>
>
> --
>
>
> *Regards,*
>
>
> *K S Praveen KumarM: +91-9986855625 *
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message CRISTINA ASENJO CUELLAR 2020-07-02 11:40:43 move postgrest installation
Previous Message Praveen Kumar K S 2020-07-02 11:25:49 Re: [HELP] Query regarding failover