On 28/07/11 03:47, Jaime Casanova wrote:
On Wed, Jul 27, 2011 at 4:36 AM, Toby Corkindale
<toby.corkindale@xxxxxxxxxxxxxxxxxxxx> wrote:
So that looks good, but then I try this on the slave:
# repmgr -f /etc/repmgr/validator/repmgr.conf \
--verbose standby register
can you show the content of /etc/repmgr/validator/repmgr.conf?
cluster=validator
node=mel-db06
conninfo='host=10.133.54.1 port=5432 user=repmgr dbname=repmgr'
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)
this is on the master or the slave?
I ran that on the slave; however I've just checked now, and the same
results are given on both nodes.
Just so you know, db06=10.133.54.1 and db07=10.133.54.2.
They also have a second address each on the 192.168.10.x network as well
though.
Toby
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
