On Wed, Jun 19, 2024 at 11:03 AM Yongye Serkfem <yserk...@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.
