Re: automatic switchover / switchback

Hi;

There is no built-in solution that makes this work automatic in PostgreSQL.
As you mentioned, there are external tools that don't require any manual
intervention.
BFM is one of them. It is a PostgreSQL failover tool that is very easy to
install and configure. In addition to failover, it can also perform
switchover operations. It also performs this process independently without
affecting clients.
You can take a look at : https://infogram.com/bfm-1hd12yzdkm8w4km?live
and for more information info(at)bisoft(dot)com(dot)tr

Best Regards

Sylvie HALAT <sylvie(dot)halat(at)ac-toulouse(dot)fr>, 23 Haz 2020 Sal, 10:22
tarihinde şunu yazdı:

> Hi Vinod
>
> This tool can help you :
>
> https://repmgr.org/docs/5.1/
>
> Best Regards
>
> Sylvie Halat
>
> Le 23/06/2020 à 09:20, dbatoCloud Solution a écrit :
>
> Hi Vinod,
> We don;t have concept called switchover and switchback in Postgres
> automatically, There is only one way that we can failover then recreate the
> master db. or you can configure automatic switch using tool
>
>
>
>
>
> Thanks & Best Wishes,
>
> Ashok
>
>
>
> -------------
>
> On Tue, Jun 23, 2020 at 11:11 AM vinod kale <vinod16895(at)gmail(dot)com> wrote:
>
>> Hello Team,
>>
>> Is there automatic switchover / switchback available in postgres. Means
>> we wll not going to create recovery.conf and etc...
>> Is there a way that postgres internally manage that and perform
>> switchover OR switchback.
>> If yes then can u jst share me the steps or any link.
>>
>> Thanks in advance.
>>
>> Thanks & Regards,
>> Vinod Kale
>>
>
>