Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQ3tq-0008Sb-Hg for pgsql-admin@arkaria.postgresql.org; Fri, 23 Nov 2018 05:21:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gQ3to-0006kO-37 for pgsql-admin@arkaria.postgresql.org; Fri, 23 Nov 2018 05:21:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQ3tn-0006hj-Re for pgsql-admin@lists.postgresql.org; Fri, 23 Nov 2018 05:21:03 +0000 Received: from hermes.gatewaynet.com ([193.92.121.98]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQ3tg-0004O9-85 for pgsql-admin@lists.postgresql.org; Fri, 23 Nov 2018 05:21:03 +0000 Received: from hercules.internal.net (hercules.internal.net [10.9.200.8]) by hermes.gatewaynet.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id wAN5Krns010772 for ; Fri, 23 Nov 2018 07:20:53 +0200 Received: from [10.9.251.6] (dcmchgw.internal.net [10.9.0.1]) by hercules.internal.net (Postfix) with ESMTPS id A657B1350AA5 for ; Fri, 23 Nov 2018 07:20:52 +0200 (EET) To: pgsql-admin@lists.postgresql.org From: Achilleas Mantzios Subject: Logical wal receiver (background worker) not detecting when publisher node has died Message-ID: Date: Fri, 23 Nov 2018 07:20:51 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US X-Virus-Scanned: clamav-milter 0.98.7 at hermes X-Virus-Status: Clean X-Spam-Status: No, score=-2.0 required=5.0 tests=ALL_TRUSTED autolearn=unavailable version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on hermes.gatewaynet.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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)