From: Lazaro Garcia <lazaro3487@gmail.com>
To: pgsql-admin@postgresql.org
Subject: repmgr error with automated failover
Date: Mon, 13 Feb 2017 15:32:05 +0100
Message-ID: <005201d28605$f4204640$dc60d2c0$@gmail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hello every one in the list. First thanks to repmgr.
I took several days testing repmgr but I can't execute an automated failover
properly.
I have 2 nodes, a master(node1) and a slave(nodo2). The repmgrd service is
running on both servers. When node1 goes down an automated failover take
place and node2 is promounted as master, at this point all is ok, the
problems comes when node2 is attached again to the cluster, for
incorporating this node to the cluster I run this commands:
1. executes a clone command on node1
su -c 'repmgr -h node2 -U repmgr -d repmgr -D /var/lib/postgresql/9.6/main/
-f /etc/postgresql/9.6/main/repmgr.conf --rsync-only --force standby clone'
postgres
2. start up the postgres service on node1
3. Register this node
su -c 'repmgr -f /etc/postgresql/9.6/main/repmgr.conf --force standby
register' postgres
Then stops node2 but node1 is never promoted as master.
Why node1 is not promoted? Is there something wrong?
Regards.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lazaro3487@gmail.com
Subject: Re: repmgr error with automated failover
In-Reply-To: <005201d28605$f4204640$dc60d2c0$@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox