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 1pQXVN-0002Jx-Jr for pgsql-admin@arkaria.postgresql.org; Fri, 10 Feb 2023 17:48:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pQXVM-0002sM-HM for pgsql-admin@arkaria.postgresql.org; Fri, 10 Feb 2023 17:48:12 +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 1pQXVL-0002qo-Hj for pgsql-admin@lists.postgresql.org; Fri, 10 Feb 2023 17:48:12 +0000 Received: from resqmta-h1p-028593.sys.comcast.net ([2001:558:fd02:2446::7]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pQXVI-0000kn-CO for pgsql-admin@lists.postgresql.org; Fri, 10 Feb 2023 17:48:09 +0000 Received: from resomta-h1p-028516.sys.comcast.net ([96.102.179.207]) by resqmta-h1p-028593.sys.comcast.net with ESMTP id QTb0pM0TnJpIJQXVDpBBTC; Fri, 10 Feb 2023 17:48:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1676051283; bh=HuzroYwRM6/QyHVQVs2KHjzMQHBV3fSKKigS//68rYo=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type:Xfinity-Spam-Result; b=ign56qVAuE+ImLVS4ZTPzcZLdNlBaxy+VN7tOd9Q60fvYG0Un6Aq1wxkFFfjjmLgx rkfM7vwDO+SkrJJzOf3+k7bRMGANSdvJwy3evORISXynyhI0nN6xQTzKG/8jhehma1 04nrmJOLiAiYTgVqH3NcIkOTLkS/rHpXGp6aFDzTXW4oD4VL+C69VzkHYBrJ6R5x4r LziMcPP2OxrbcRWsqhq98Gs6m/MCeCN5vKVafTCrHEU2iBeZYQNL17jERKn3miRlN3 RIvKKoh9NmD+LC4JtFSmKF6PVGOWNoV9mpHY0V55rg8YzIXBeBjY8p+9J3INLhhPxW uSN4GTrErESCg== Received: from R9N0YC2TC3.localdomain ([208.127.71.26]) by resomta-h1p-028516.sys.comcast.net with ESMTPA id QXUipaHf1dPiEQXUlpKltn; Fri, 10 Feb 2023 17:47:40 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgedvhedrudehhedguddtfecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucevohhmtggrshhtqdftvghsihdpqfgfvfdppffquffrtefokffrnecuuegrihhlohhuthemuceftddunecunecujfgurhephffvufffkfgfgggtsehttdertddtredtnecuhfhrohhmpeflvghrrhihucfuihgvvhgvrhhsuceoghhsihgvvhgvrhhsudelsegtohhmtggrshhtrdhnvghtqeenucggtffrrghtthgvrhhnpedthefhffelhfdtjedvkeelkefhueekffetffevhfekfefgveeftefgieegveffueenucfkphepvddtkedruddvjedrjedurddvieenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhephhgvlhhopeftlefptdgjvedvvfevfedrlhhotggrlhguohhmrghinhdpihhnvghtpedvtdekrdduvdejrdejuddrvdeipdhmrghilhhfrhhomheptgihsggvrhdrhhhunhhkohestghomhgtrghsthdrnhgvthdpnhgspghrtghpthhtohepuddprhgtphhtthhopehpghhsqhhlqdgrughmihhnsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-Xfinity-VMeta: sc=0.00;st=legit Received: by R9N0YC2TC3.localdomain (Postfix, from userid 503) id C2B6C12BA9F6; Fri, 10 Feb 2023 11:47:31 -0600 (CST) From: Jerry Sievers To: pgsql-admin@lists.postgresql.org Subject: pglogical supervisor on pg15 not taking ProcSignalBarrier Date: Fri, 10 Feb 2023 11:47:31 -0600 Message-ID: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.1 (darwin) MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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!