Re: Manual Failover

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.