Logical wal receiver (background worker) not detecting when publisher node has died

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Logical wal receiver (background worker) not detecting when publisher node has died
Date: 2018-11-23 05:20:51
Message-ID: cd6ba6d5-d76d-4a69-a743-00544ec2dbca@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear List,
Coming back from :
https://www.postgresql.org/message-id/ae8812c3-d138-73b7-537a-a273e15ef6e1%40matrix.gatewaynet.com

and having got absolutely no helpful answer from our infrastructure
people, I would like to ask :

Is it on earth possible that the primary (publisher node) has crushed
while on the subscriber node the logical wal receiver goes on happily
like there is no problem at all, no messages in log, no timeouts, acts
if nothing happen ?

(in the meantime the second standby instantly detected the crush of the
primary and immediately restarted re-connection attempts)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Zwettler Markus (OIZ) 2018-11-23 10:14:54 pgpool2 HA + split brain
Previous Message Mark Kirkwood 2018-11-23 00:21:24 Re: Oracle to Postgres-Licensed GUI tool