public inbox for [email protected]  

help / color / mirror / Atom feed

Manual Failover
3+ messages / 3 participants
[nested] [flat]

* Manual Failover
@ 2024-06-19 15:03  Yongye Serkfem <[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:26  Rob Sargent <[email protected]>
  parent: Yongye Serkfem <[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 17:07  Ron Johnson <[email protected]>
  parent: Yongye Serkfem <[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