Re: Investigate postgres 9.6.3 repmgr lag 4.0.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> 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@xxxxxxxxxxx
p: 312.241.7800





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux