From: Ian Barwick <ian.barwick@2ndquadrant.com>
To: Lazaro Garcia <lazaro3487@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: repmgr error with automated failover
Date: Tue, 14 Feb 2017 10:55:09 +0900
Message-ID: <ff90e580-6999-a892-ed24-169c0d4fca86@2ndquadrant.com> (raw)
In-Reply-To: <005201d28605$f4204640$dc60d2c0$@gmail.com>
References: <005201d28605$f4204640$dc60d2c0$@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi
On 02/13/2017 11:32 PM, Lazaro Garcia wrote:
> 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?
Is repmgrd running on node1? Is its repmgr.conf file configured
correctly, e.g. "failover=automatic"
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: ian.barwick@2ndquadrant.com, lazaro3487@gmail.com
Subject: Re: repmgr error with automated failover
In-Reply-To: <ff90e580-6999-a892-ed24-169c0d4fca86@2ndquadrant.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