PreFailover Actions
REPMGR supports automatic failover. In a case of a failover – we need to “REJOIN” the fallen node to the cluster manually with the following commands:
sudo su - systemctl stop postgresql-10 su postgres cd ~ PGPASSWORD=<postgres user password> /usr/pgsql-10/bin/repmgr -f /etc/repmgr/10/repmgr.conf -h <new primary ip> -U repuser -d postgres standby clone --force-rewind --force exit systemctl start postgresql-10 su postgres /usr/pgsql-10/bin/repmgr standby register --force
Troubleshooting:
If the failover does not work use the following command
on the standby DB machine:
-
su - postgres
-
/usr/pgsql-10/bin/repmgr standby promote