repmgr problem with registering standby

From: Toby Corkindale <toby(dot)corkindale(at)strategicdata(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: repmgr problem with registering standby
Date: 2011-07-27 09:36:19
Message-ID: 4E2FDC13.5000208@strategicdata.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have repmgr working to some degree on a couple of servers, but am
having trouble with the "register" part on the slave.

On the master, I run:
# repmgr -f /etc/repmgr/validator/repmgr.conf \
--verbose --force master register

Opening configuration file: /etc/repmgr/validator/repmgr.conf
repmgr connecting to master database
repmgr connected to master, checking its state
finding node list for cluster 'validator'
Master node correctly registered for cluster validator with id 0
(conninfo: host=10.133.54.2 port=5432 user=repmgr dbname=repmgr)

So that looks good, but then I try this on the slave:
# repmgr -f /etc/repmgr/validator/repmgr.conf \
--verbose standby register

Opening configuration file: /etc/repmgr/validator/repmgr.conf
repmgr connecting to standby database
repmgr connected to standby, checking its state
repmgr connecting to master database
finding node list for cluster 'validator'
A master must be defined before configuring a slave

I can query the database like so though, and it seems like it's all good:
repmgr=# select * from repmgr_validator.repl_nodes;
id | cluster | conninfo
----+-----------+------------------------------------------------------
0 | validator | host=10.133.54.2 port=5432 user=repmgr dbname=repmgr
(1 row)

Does anyone have an idea of what might be going wrong here?

Thanks,
Toby

Responses

Browse pgsql-general by date

  From Date Subject
Next Message salah jubeh 2011-07-27 09:49:30 Re: variant column type
Previous Message Grzegorz Jaśkiewicz 2011-07-27 08:48:36 Re: mac installer on Lion