public inbox for [email protected]
help / color / mirror / Atom feedManual Failover
3+ messages / 3 participants
[nested] [flat]
* Manual Failover
@ 2024-06-19 15:03 Yongye Serkfem <[email protected]>
2024-06-19 15:26 ` Re: Manual Failover Rob Sargent <[email protected]>
2024-06-19 17:07 ` Re: Manual Failover Ron Johnson <[email protected]>
0 siblings, 2 replies; 3+ messages in thread
From: Yongye Serkfem @ 2024-06-19 15:03 UTC (permalink / raw)
To: pgsql-general
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Manual Failover
2024-06-19 15:03 Manual Failover Yongye Serkfem <[email protected]>
@ 2024-06-19 15:26 ` Rob Sargent <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Rob Sargent @ 2024-06-19 15:26 UTC (permalink / raw)
To: [email protected]
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Manual Failover
2024-06-19 15:03 Manual Failover Yongye Serkfem <[email protected]>
@ 2024-06-19 17:07 ` Ron Johnson <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Ron Johnson @ 2024-06-19 17:07 UTC (permalink / raw)
To: pgsql-general
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-06-19 17:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-19 15:03 Manual Failover Yongye Serkfem <[email protected]>
2024-06-19 15:26 ` Rob Sargent <[email protected]>
2024-06-19 17:07 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox