| From: | Michael Banck <mbanck(at)gmx(dot)net> |
|---|---|
| To: | "Narendran (dot)j" <jnarendran3(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Failover and Failback |
| Date: | 2024-09-19 11:32:54 |
| Message-ID: | 66ec0be7.170a0220.48a0.7d07@mx.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sethu mathavan | 2024-09-19 11:35:06 | Re: Failover and Failback |
| Previous Message | Narendran .j | 2024-09-19 11:16:28 | Failover and Failback |