public inbox for [email protected]
help / color / mirror / Atom feedFailover and Failback
3+ messages / 3 participants
[nested] [flat]
* Failover and Failback
@ 2024-09-19 11:16 Narendran .j <[email protected]>
2024-09-19 11:32 ` Re: Failover and Failback Michael Banck <[email protected]>
2024-09-19 11:35 ` Re: Failover and Failback sethu mathavan <[email protected]>
0 siblings, 2 replies; 3+ messages in thread
From: Narendran .j @ 2024-09-19 11:16 UTC (permalink / raw)
To: [email protected]
Hello Team,
I have facing a problem in failback. I just promoted my secondary as master
by using pg_ctl promote.it was successful.so now how can I bring my old
master as primary I tried with pg_rewind it's not working. So is there any
other way to perform failback. Is there any procedure to perform failback
and failover please share with me. Additionally we don't use any tool for
it.
Regards
Narendran J
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Failover and Failback
2024-09-19 11:16 Failover and Failback Narendran .j <[email protected]>
@ 2024-09-19 11:32 ` Michael Banck <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Michael Banck @ 2024-09-19 11:32 UTC (permalink / raw)
To: Narendran .j <[email protected]>; +Cc: [email protected]
Hi,
On Thu, Sep 19, 2024 at 04:46:28PM +0530, Narendran .j wrote:
> I have facing a problem in failback. I just promoted my secondary as master
> by using pg_ctl promote.it was successful.so now how can I bring my old
> master as primary I tried with pg_rewind it's not working.
You need to bring your old primary as standby first, then switchover
back to it - otherwise, you would have two primaries, no?
In general, pg_rewind is the only reasonable way to recover a failed
over primary other than by rebuilding it from scratch as a standby.
So if pg_rewind did not work, we would need more information, like what
command did you issue exactly and what was the output/error message?
Michael
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Failover and Failback
2024-09-19 11:16 Failover and Failback Narendran .j <[email protected]>
@ 2024-09-19 11:35 ` sethu mathavan <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: sethu mathavan @ 2024-09-19 11:35 UTC (permalink / raw)
To: Narendran .j <[email protected]>; +Cc: [email protected]
Hi Narendran,
Before running rewind command,need to change few parameters in
postgresql.conf file.like primary_conninfo in old_master.
Regards,
Sethu
On Thu, 19 Sep, 2024, 4:46 pm Narendran .j, <[email protected]> wrote:
> Hello Team,
>
> I have facing a problem in failback. I just promoted my secondary as
> master by using pg_ctl promote.it was successful.so now how can I bring
> my old master as primary I tried with pg_rewind it's not working. So is
> there any other way to perform failback. Is there any procedure to perform
> failback and failover please share with me. Additionally we don't use any
> tool for it.
>
> Regards
> Narendran J
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-09-19 11:35 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-19 11:16 Failover and Failback Narendran .j <[email protected]>
2024-09-19 11:32 ` Michael Banck <[email protected]>
2024-09-19 11:35 ` sethu mathavan <[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