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: pglogical supervisor on pg15 not taking ProcSignalBarrier
Date: 2023-02-10 17:47:31
Message-ID: m0k00ptnt8.fsf@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Admins,

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

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!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2023-02-10 20:32:35 Re: UPDATE, pglogical supervisor on pg15 not taking ProcSignalBarrier
Previous Message JP Pozzi 2023-02-10 14:14:00 Re: Proxy pgadmin connection issue