On Wed, Jul 27, 2011 at 7:24 PM, Toby Corkindale <toby.corkindale@xxxxxxxxxxxxxxxxxxxx> wrote: > 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' > sorry for the delay on this... do you still have this problem? the node parameter should be an integer value, i don't think that string should work for you >>> 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) >> if in the standby that string you're using as node value ends up as a 0 then it never asks for the node 0 (it couldn't be the master because you're just registering as a standby) so i bet that's the problem, use numbers in the node parameter and everything will be ok i will have to add a check against this case in repmgr, though -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
