Thread

1. Manual Failover

   Yongye Serkfem <yserkfem@gmail.com> — 2024-06-19T15:03:30Z

   Hello Engineers,
   I am facing an issue with the manual failover of the standby to the master
   role. I was able to promote the standby and got it out of recovery mode.
   How do I direct applications to point to the standby which has assumed the
   role of the current master, and what should I do after completing
   maintenance on the previous master to assume its original role as master?
   I would appreciate any input, and thank you for your time.
   
   Yongye Serkfem
   

2. Re: Manual Failover

   Rob Sargent <robjsargent@gmail.com> — 2024-06-19T15:26:06Z

   
   On 6/19/24 09:03, Yongye Serkfem wrote:
   > Hello Engineers,
   > I am facing an issue with the manual failover of the standby to the 
   > master role. I was able to promote the standby and got it out of 
   > recovery mode. How do I direct applications to point to the standby 
   > which has assumed the role of the current master, and what should I do 
   > after completing maintenance on the previous master to assume its 
   > original role as master?
   > I would appreciate any input, and thank you for your time.
   >
   > Yongye Serkfem
   You need to show your set up (failover script, etc) but usually the 
   standby get the ip address of the now-dead master and the apps are none 
   the wiser.
   
   
   
   

3. Re: Manual Failover

   Ron Johnson <ronljohnsonjr@gmail.com> — 2024-06-19T17:07:56Z

   On Wed, Jun 19, 2024 at 11:03 AM Yongye Serkfem <yserkfem@gmail.com> wrote:
   
   > Hello Engineers,
   > I am facing an issue with the manual failover of the standby to the master
   > role. I was able to promote the standby and got it out of recovery mode.
   > How do I direct applications to point to the standby which has assumed the
   > role of the current master,
   >
   
   A typical solution is a separate service which manages a virtual IP that
   points to whichever DB server you choose.
   
   
   > and what should I do after completing maintenance on the previous master
   > to assume its original role as master?
   >
   
   pg_basebackup is guaranteed to get previous-master in sync with
   now-active.  pg_rewind might also work.