Re: automatic switchover / switchback

Amine Tengilimoglu <aminetengilimoglu@xxxxxxxxx> · Tue, 23 Jun 2020 11:16:35 +0300

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

Best Regards

Sylvie HALAT <sylvie.halat@xxxxxxxxxxxxxx>, 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@xxxxxxxxx> 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