automatic switchover / switchback

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

automatic switchover / switchback

vinod kale
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
Reply | Threaded
Open this post in threaded view
|

Re: automatic switchover / switchback

dbatoCloud Solution
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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: automatic switchover / switchback

Sylvie HALAT
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 <[hidden email]> 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

Reply | Threaded
Open this post in threaded view
|

Re: automatic switchover / switchback

Amine Tengilimoglu
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 [hidden email] 

Best Regards

Sylvie HALAT <[hidden email]>, 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 <[hidden email]> 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

Reply | Threaded
Open this post in threaded view
|

Re: automatic switchover / switchback

Stephen Frost
In reply to this post by vinod kale
Greetings,

* vinod kale ([hidden email]) wrote:
> 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.

I'd suggest you check out Patroni.

Thanks,

Stephen

signature.asc (836 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: automatic switchover / switchback

jwiencek3
EnterpriseDB has a product called Enterprise Failover Manager(EFM) that has the features you mention.  Checkout their website.


John

> On Jun 23, 2020, at 5:43 AM, Stephen Frost <[hidden email]> wrote:
>
> Greetings,
>
> * vinod kale ([hidden email]) wrote:
>> 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.
>
> I'd suggest you check out Patroni.
>
> Thanks,
>
> Stephen