pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jerry Sievers <gsievers19@comcast.net>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: Rui DeSousa <rui@crazybean.net>
Cc: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Investigate postgres 9.6.3 repmgr lag 4.0.4
Date: Wed, 27 Jun 2018 10:41:02 -0500
Message-ID: <87po0cjkz5.fsf@jsievers.enova.com> (raw)
In-Reply-To: <CA+t6e1mwWg0SCR0d=0fH-+YxnLwjB-_UKkhvGEvsGM9MS8jFkw@mail.gmail.com>
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>

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,  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.

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




view thread (10+ messages)

Message-ID: <87po0cjkz5.fsf@jsievers.enova.com>
Permalink:  ../87po0cjkz5.fsf@jsievers.enova.com/
Also on:    postgresql.org/message-id/87po0cjkz5.fsf@jsievers.enova.com

 · 

reply
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: gsievers19@comcast.net, mariel.cherkassky@gmail.com, rui@crazybean.net, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Investigate postgres 9.6.3 repmgr lag 4.0.4
  In-Reply-To: <87po0cjkz5.fsf@jsievers.enova.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