From: Jerry Sievers <gsievers19@comcast.net>
To: pgsql-admin@lists.postgresql.org
Subject: Re: UPDATE, pglogical supervisor on pg15 not taking ProcSignalBarrier
References: <m0k00ptnt8.fsf@comcast.net>
Date: Fri, 10 Feb 2023 14:32:35 -0600
In-Reply-To: <m0k00ptnt8.fsf@comcast.net> (Jerry Sievers's message of "Fri, 10
	Feb 2023 11:47:31 -0600")
Message-ID: <m0fsbdtg64.fsf@comcast.net>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.1 (darwin)
MIME-Version: 1.0
Content-Type: text/plain
Archived-At: 
 <https://www.postgresql.org/message-id/m0fsbdtg64.fsf%40comcast.net>
Precedence: bulk

Well, ok it's a known problem.  Patched but apparently pending the
release cycle.

> Admins,
>
> Drop database even with (force) hangs indefinately unless the pgl
> supervisor is term'd.


----

REL2_x_STABLE:pglogical$ git log -n1
commit f27d3c4 (HEAD -> REL2_x_STABLE, origin/REL2_x_STABLE, origin/HEAD)
Author: Euler Taveira <euler.taveira@enterprisedb.com>
Date:   Mon Nov 28 10:38:26 2022 -0300

    Drop database never completes in Postgres 15 (#403)
    
    Postgres 15 introduced a signal barrier for DROP DATABASE
    (4eb2176318d0561846c1f9fb3c68bede799d640f). pglogical has no logic to
    handle it in the supervisor code. Add CFI to fix it.
    
    Fix #399
REL2_x_STABLE:pglogical$ git log -n1 REL2_4_2
commit 740f1f3 (tag: REL2_4_2)
Author: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Date:   Wed Oct 12 13:55:10 2022 +0200

    pglogical 2.4.2 release notes and docs update (#357)
    
    Update release notes for 2.4.2
    
    Add PG 15 package descriptions
REL2_x_STABLE:pglogical$ 


Jerry Sievers <gsievers19@comcast.net> writes:

>
>  PostgreSQL 15.1 (Ubuntu 15.1-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
>
> This particular cluster I don't believe needs pgl but we have it
> nonetheless config'd in shared_preload_libs as to enable it if necessary
> without a restart.
>
> I"ve not checked yet the rel notes for pg15.2 in case of any change in
> this regard.
>
> Will raise this with the pglogical community also perhaps."
>
>
> dpkg says this about our pglogical version.
>
> ii  postgresql-15-pglogical               2.4.2-2.pgdg20.04+1               amd64        Logical Replication Extension for PostgreSQL
>
>
> Any advice?
>
> Thx!