From: Jerry Sievers <gsievers19@comcast.net>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: Rui DeSousa <rui@crazybean.net>,  Ron <ronljohnsonjr@gmail.com>,
  pgsql-admin@lists.postgresql.org
Subject: Re: Investigate postgres 9.6.3 repmgr lag 4.0.4
References: 
 <CA+t6e1kS=B5G4KiRXDnZMexrMd9uH4iC6gd++82Qj6r0cE7f9g@mail.gmail.com>
	<A86CBFD8-B27C-409C-8332-C73B84FD3153@crazybean.net>
	<CAGHTAeOzne+6nXhOTpBRs_ggeZBc1yBhqv9_j1kdQQk=L=MGyw@mail.gmail.com>
	<e333fa64-3722-c947-ca26-762a10a481f6@gmail.com>
	<CA+t6e1n0moY-sVxgKn+giq=q-zV89nVVxdyyp5_W1QrwbXAN8Q@mail.gmail.com>
	<70C74E85-F24B-4930-8942-5662540E0B74@crazybean.net>
	<CA+t6e1mwWg0SCR0d=0fH-+YxnLwjB-_UKkhvGEvsGM9MS8jFkw@mail.gmail.com>
Date: Wed, 27 Jun 2018 10:41:02 -0500
In-Reply-To: 
 <CA+t6e1mwWg0SCR0d=0fH-+YxnLwjB-_UKkhvGEvsGM9MS8jFkw@mail.gmail.com>
	(Mariel Cherkassky's message of "Wed, 27 Jun 2018 13:02:51 +0300")
Message-ID: <87po0cjkz5.fsf@jsievers.enova.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

Mariel Cherkassky <mariel.cherkassky@gmail.com> writes:

> Hi all,
> it happened again. The weird thing is that when I query
> pg_stat_replication I see only one slave(the one that is still
> synced) and I dont see the second one. Moreover,=C2=A0 I dont see anything
> in the repmgr log of the primary and in the slave regarding the
> disconnection...

Disclaimer: I am not a repmgr admin...

I suggest you check the DB server logs on both standby node and master
for evidence of connection attempts for streaming, their success/failure
and reasons and/or what might cause an established connection to drop.

That you don't see the rogue standby in pg_stat_replication on the
master is clear evidence that it's not connected presently but this
doesn't tell the whole story.

--=20
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800