repmgr
repmgr copied to clipboard
A lightweight replication manager for PostgreSQL (Postgres)
Dear, My PG is pg14,and repmgr is 5.3.2, install pg and repmgr by source code. when I start repgmrd ,the available memory will become less and less, will raise out...
repmgr standby switchover -f /etc/postgresql/12/main/repmgr.conf --dry-run WARNING: the following problems were found in the configuration file: parameter "cluster" is deprecated and will be ignored NOTICE: checking switchover on node "node2"...
Hi, I am trying to do switchover using repmgr. It stops primary node correctly, but after that it hangs during rewind: ``` postgres@8feb0787ba67:~$ repmgr -f /etc/postgresql/13/main/repmgr.conf standby switchover NOTICE: executing...
Here issue is that after doing PITR for specific time wal replay resume at all node. For primary when I run pg_wal_replay_resume() that issue gone. When I clone from primary...
Hello. I got an error when trying to switchover after doing a postgres major update: ``` ERROR: "data_directory" parameter in "repmgr.conf" on "pg1" (ID: 1) is incorrectly configured ``` I...
When I simulated a network outage in a 4 node cluster (2 synchronous and 1 asynchronous standby, 2 data centers, 1 witness), the remaining synchronous standby made a failover as...
Hi, I'll be looking for secure authentication for Postgres where i should not use .pgpass or trust authentication method. I have come across a issue during Standby switchover, where the...
When I did switchover from node1 to node 2 it switch over successfully as like below. Here issue is that node1 is not attached with it. ``` [postgres@node2 ~]$ repmgr...
Hi, I have several postgresql clusters running postgres version 10, 12, 13 on Rocky Linux 8. Postgres is installed from postgres yum repo, and repmgr from 2ndquadrant's repo. I'm attempting...
@ibarwick we ran into problems with a chart that uses repmgr and spent some time trying to read this documentation. We were a bit confused about pieces, so I'm proposing...