Re: UPDATE, pglogical supervisor on pg15 not taking ProcSignalBarrier

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: UPDATE, pglogical supervisor on pg15 not taking ProcSignalBarrier
Date: 2023-02-10 20:32:35
Message-ID: m0fsbdtg64.fsf@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)taveira(at)enterprisedb(dot)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(dot)eisentraut(at)enterprisedb(dot)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(at)comcast(dot)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!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message ghadeerdarwesh58 2023-02-12 20:56:45 Upgrade from PostGIS 2.3 to 2.5.5 in PostgreSQL 11 error
Previous Message Jerry Sievers 2023-02-10 17:47:31 pglogical supervisor on pg15 not taking ProcSignalBarrier