Hello, I am using repmgr 3.2 (PostgreSQL 9.6.0), postgresql-9.5. I have a master, a slave and a third server for my setup. The third server is used to house the rep mgr database. my config is as below :
===MASTER===== cluster=test node=1 node_name=node1 conninfo='host=192.168.2.33 user=repuser password=repuser dbname=replication_manager connect_timeout=10' loglevel=INFO logfacility=STDERR logfile='/var/log/postgresql/repmgr.log' pg_bindir=/usr/lib/postgresql/9.5/bin/ #service control commands service_start_command = service postgresql start service_stop_command = service postgresql stop service_restart_command = service postgresql restart service_reload_command = service postgresql reload service_promote_command = pg_ctlcluster 9.5 main promote pg_basebackup_options='--xlog-method=s' ==== Slave ========= cluster=test node=2 node_name=node2 conninfo='host=192.168.2.33 user=repuser password=repuser dbname=replication_manager connect_timeout=10' loglevel=INFO logfacility=STDERR logfile='/var/log/postgresql/repmgr.log' pg_bindir=/usr/lib/postgresql/9.5/bin/ #service control commands service_start_command = service postgresql start service_stop_command = service postgresql stop service_restart_command = service postgresql restart service_reload_command = service postgresql reload service_promote_command = pg_ctlcluster 9.5 main promote pg_basebackup_options='--xlog-method=s' ========= The third server=========== this holds the rep mgr database . - I was able to register the master to the cluster master node correctly registered for cluster test with id 1 (conninfo: host= 192.168.2.31 user=repuser password=repuser dbname=repmgr connect_timeout=10) But when I tried registering the slave node, I get the following error : this node should be a standby (host= 192.168.2.33 user=repuser password=repuser dbname=replication_manager connect_timeout=10) Is there a way to run repmgr with the rep mgr table on a separate server ? regards rugging24 -- View this message in context: http://postgresql.nabble.com/repmgr-this-node-should-be-a-standby-tp5927408.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers