pglogical supervisor on pg15 not taking ProcSignalBarrier - Mailing list pgsql-admin

From Jerry Sievers
Subject pglogical supervisor on pg15 not taking ProcSignalBarrier
Date
Msg-id m0k00ptnt8.fsf@comcast.net
Whole thread Raw
Responses Re: UPDATE, pglogical supervisor on pg15 not taking ProcSignalBarrier  (Jerry Sievers <gsievers19@comcast.net>)
List 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
forPostgreSQL
 


Any advice?

Thx!



pgsql-admin by date:

Previous
From: JP Pozzi
Date:
Subject: Re: Proxy pgadmin connection issue
Next
From: Jerry Sievers
Date:
Subject: Re: UPDATE, pglogical supervisor on pg15 not taking ProcSignalBarrier