repmgr
repmgr copied to clipboard
A lightweight replication manager for PostgreSQL (Postgres)
Two things here: 1/ When run with e.g. Ubuntu defaults (see #715), due to service_restart_command being not set up by default, it fails on the remote end. But what I...
Hi. Setting up repmgr, and have some feedback about the 1st time experience. The main thing which complicates the process is IMHO that there are quite a few command line...
Setup: ` ID | Name | Role | Status | Upstream | Location | Priority | Timeline | Connection string ----+------+---------+----------------------+----------+----------+----------+----------+ 1 | nvme | primary | * running |...
Hi, i have a problem with replication manager 5.2.1 and Postgres 12.7. If during a failover the old master or a standby is down for some minutes, a standby rejoin...
The current repmgrd fencing technique (repmgrd invoking the child_nodes_disconnect_command) has 2 problems: 1) It only works when repmgrd is running and failover=automatic 2) It doesn't work if a failover happens...
Hello, I'm using barman for WAL archiving so that the target location is not "pg_wal" directory. However, repmgr tries to use the default "pg_wal" location. Command: `runuser -l postgres -c...
We have seen an odd problem occur where repmgrd appears to have a race condition. The primary failed, and both standbys compared LSNs and determined that they were equal. One...
Hi, We are running PostgreSQL 11.7 and repmgr 5.2.1 and repmgrd is up and running. In case of Primary database is hung, repmgrd on child node identifies it immediately as...
Hello! First of all, I want to give my thanks for providing repmgr suite for managing postgres replication and failover scenarios, we have used it with great success in my...
Hello, I have noticed an issue with repmgrd shutdown sequence. When repmgrd lost a connection to the local standby database it enters to the "degraded monitoring for the local node"...