Hi All,
While joining the DB_cluster i am having the below error
$repmgr -f /var/lib/postgresql/repmgr/repmgr.conf standby register
[2018-10-17 11:42:59] [ERROR] this node should be a standby (host=pgdb2 port=5432 user=repmgr dbname=repmgr)
Master:-
postgres@Master:~$ cat repmgr/repmgr.conf
cluster=db_cluster
node=1
node_name=pgdb1
conninfo='host=pgdb1 user=repmgr dbname=repmgr'
pg_bindir=/usr/lib/postgresql/9.5/bin/
master_response_timeout=5
reconnect_attempts=2
reconnect_interval=2
failover=manual
promote_command='/usr/lib/postgresql/9.5/bin/repmgr standby promote -f /var/lib/postgresql/repmgr/repmgr.conf'
follow_command='/usr/lib/postgresql/9.5/bin/repmgr standby follow -f /var/lib/postgresql/repmgr/repmgr.conf'
$postgres@Master:~$ /usr/lib/postgresql/9.5/bin/repmgr -f /var/lib/postgresql/repmgr/repmgr.conf cluster show
Role | Connection String
* master | host=pgdb1 user=repmgr dbname=repmgr
Slave:-
postgres@pgdb2:~$ vim repmgr/repmgr.conf
cluster=db_cluster
node=2
node_name=pgdb2
conninfo='host=pgdb2 port=5432 user=repmgr dbname=repmgr'
pg_bindir=/usr/lib/postgresql/9.5/bin/
master_response_timeout=5
reconnect_attempts=2
reconnect_interval=2
failover=manual
promote_command='/usr/lib/postgresql/9.5/bin/repmgr standby promote -f /var/lib/postgresql/repmgr/repmgr.conf'
follow_command='/usr/lib/postgresql/9.5/bin/repmgr standby follow -f /var/lib/postgresql/repmgr/repmgr.conf'
Pls guide me whatis wrong in my configuration
-- Thanks & Regards
Arvind rao chikne
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail
