[HELP] How to fix failed failed failover?

20 views
Skip to first unread message

Axel Rau

unread,
Feb 9, 2022, 6:31:52 AM2/9/22
to rep...@googlegroups.com
Hi all,

I rebooted primary and standby due to OS update and forgot to disable
failover (at 2022-02-05 ).
Now repmgr shows a standby as primary

ID | Name | Role | Status | Upstream |

----+-------+---------+----------------------+----------+
3 | dbo3 | standby | running | dbo5 |
4 | dbo4 | standby | ! running as primary | |
5 | dbo5 | primary | * running | |
31 | dbob3 | standby | running | dbo3 |

dbo5 is the primary.

How can I fix this?

I attach status and eventlog from dbo4 and dbo5

Any help very appreciated,
Axel
--
PGP-Key: CDE74120 ☀ computing @ chaos claudius
dbo4.txt
dbo5.txt
OpenPGP_signature

Axel Rau

unread,
Feb 9, 2022, 8:36:01 AM2/9/22
to rep...@googlegroups.com
Am 09.02.22 um 12:31 schrieb Axel Rau:
> How can I fix this?
>
The slots at dbo5 show:
pg_replication_slots;
slot_name | slot_type | active
---------------+-----------+--------
repmgr_slot_4 | physical | f
repmgr_slot_3 | physical | t


So, when I shutdown dbo4, a failover to dbo5 should happen. right?
OpenPGP_signature
Reply all
Reply to author
Forward
0 new messages