public inbox for [email protected]help / color / mirror / Atom feed
Failover and Failback 3+ messages / 3 participants [nested] [flat]
* Failover and Failback @ 2024-09-19 11:16 Narendran .j <[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:32 Michael Banck <[email protected]> parent: Narendran .j <[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:35 sethu mathavan <[email protected]> parent: Narendran .j <[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