repmgr switch over fails
Closed this issue · 0 comments
I am using repmgr to test failover and it fails with the below error:
-bash-4.1$ repmgr standby switchover -f /etc/repmgr.conf --siblings-follow --dry-run
NOTICE: checking switchover on node node2 (ID: 2) in --dry-run mode
INFO: SSH connection to host node1 succeeded
ERROR: "data_directory" parameter in repmgr.conf on node1 is incorrectly configured
HINT: execute "repmgr node check --data-directory-config" on node1 to diagnose the issue.
[postgres@abc ~]$ repmgr --version
repmgr 5.1.0
The version of postgres is 9.3.
repmgr.conf on node 1:
node_id=1
node_name='abc.com'
conninfo='host=abc.com user=repmgr dbname=repmgr connect_timeout=2'
data_directory='/mnt/data'
pg_bindir='/usr/pgsql-9.3/bin'
repmgr.conf on node 2:
node_id=2
node_name='xyz.com'
conninfo='host=xyz.com user=repmgr dbname=repmgr connect_timeout=2'
data_directory='/mnt/data'
pg_bindir='/usr/pgsql-9.3/bin'
[postgres@abc ~]$ repmgr node check --data-directory-config -f /etc/repmgr.conf
OK (configured "data_directory" is "/mnt/data")