repmgr: this node should be a standby

From: rugging24 <rugging24(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: repmgr: this node should be a standby
Date: 2016-10-24 13:49:00
Message-ID: 1477316940522-5927408.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2016-10-24 13:52:41 Re: On conflict update & hint bits
Previous Message Bruce Momjian 2016-10-24 13:37:59 Re: Renaming of pg_xlog and pg_clog