public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Manual Failover
Date: Wed, 19 Jun 2024 13:07:56 -0400
Message-ID: <CANzqJaDi+Jb6tA+cx2Z-NMcLXVS_ZLr-7OSq3QLQmATC9_r1YA@mail.gmail.com> (raw)
In-Reply-To: <CAAu_hGv-gMAqC71JrcooYpX1-e3PNe6hCuxHox1SEzgAwz2HMg@mail.gmail.com>
References: <CAAu_hGv-gMAqC71JrcooYpX1-e3PNe6hCuxHox1SEzgAwz2HMg@mail.gmail.com>
On Wed, Jun 19, 2024 at 11:03 AM Yongye Serkfem <[email protected]> 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.
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Manual Failover
In-Reply-To: <CANzqJaDi+Jb6tA+cx2Z-NMcLXVS_ZLr-7OSq3QLQmATC9_r1YA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox