Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lgnZm-00026q-Ue for pgsql-bugs@arkaria.postgresql.org; Wed, 12 May 2021 12:02:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lgnZl-0003FG-M9 for pgsql-bugs@arkaria.postgresql.org; Wed, 12 May 2021 12:02:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lgnJZ-0008Nt-8t for pgsql-bugs@lists.postgresql.org; Wed, 12 May 2021 11:46:09 +0000 Received: from mail.voipfuture.com ([213.238.34.195]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lgnJT-0004jl-QU for pgsql-bugs@lists.postgresql.org; Wed, 12 May 2021 11:46:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=voipfuture.com; s=mail; h=from:subject:date:message-id:to:cc:mime-version:content-type; bh=ZuhkE/+2G9NQpG//SdWudWxFV4A02jkLtB5PXUwAUV8=; b=nSO2RCyj+y4N+0dRNTNiZ3z7g1xCjHdkcanOD8NAC8PIYhoMMO4CWJR88PUfTxut8ZPzNoi/QuuRN UDZYK7G88Thole9DhNTZVgouZfS4tJRMvqJ6YCy8S268erUNIyL9srw9lMhA2V9XjR6K38bX9OBc/2 9qv2UxUlU7sLxjxQ= X-Footer: dm9pcGZ1dHVyZS5jb20= Received: from localhost ([127.0.0.1]) by mail.voipfuture.com with ESMTPSA (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256 bits)); Wed, 12 May 2021 13:45:56 +0200 To: Daniel Danzberger , Alvaro Herrera , "Robert Welin , Tom Lane , Sergei Kornilov , pgsql-hackers@postgresql.org, Peter Eisentraut , Marc Dean , Petr Jelinek , "michael.paul.powers@gmail.com" , "pgsql-bugs@lists.postgresql.org" From: Valentin Nastasache Subject: Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events Message-ID: Date: Wed, 12 May 2021 13:45:55 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.10.1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------1DB8CBD45A3A488618B6491C" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------1DB8CBD45A3A488618B6491C Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hi, We also encountered this and is still an issue even for version 13 (https://github.com/valentin-nasta/postgresql-bug-15293-demo ). Current workaround is to have a java thread sending each 500ms a notify to the channel from the subscriber server to sync the queue. Is there an update on this? Kind regards, Valentin Nastasache --- Senior Java Developer Voipfuture GmbH --------------1DB8CBD45A3A488618B6491C Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit

Hi,

We also encountered this and is still an issue even for version 13 (https://github.com/valentin-nasta/postgresql-bug-15293-demo).

Current workaround is to have a java thread sending each 500ms a notify to the channel from the subscriber server to sync the queue.

Is there an update on this?

Kind regards,

Valentin Nastasache

---

Senior Java Developer

Voipfuture GmbH

--------------1DB8CBD45A3A488618B6491C--