X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BBF5ED6EC0 for ; Thu, 25 Aug 2005 13:08:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26173-01 for ; Thu, 25 Aug 2005 16:08:17 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 74785D6EBB for ; Thu, 25 Aug 2005 13:08:17 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7PG8BsK029587; Thu, 25 Aug 2005 12:08:11 -0400 (EDT) To: "Kevin Keith" Cc: pgsql-admin@postgresql.org Subject: Re: Question regarding blocking locks In-reply-to: References: Comments: In-reply-to "Kevin Keith" message dated "Thu, 25 Aug 2005 09:28:13 -0500" Date: Thu, 25 Aug 2005 12:08:11 -0400 Message-ID: <29586.1124986091@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/317 X-Sequence-Number: 18636 "Kevin Keith" writes: > I have a question regarding blocking locks in the pg database. I ran into a > process which terminated abnormally, and to fully clear the locks it left > behind I had to reboot the system (probably restarting postmaster would have > had the same effect). Define "terminated abnormally". You really aren't going to get helpful answers without giving full details of what happened. (If the postmaster thought the backend had crashed, it would have forced a database restart which would have wiped shared memory. So it's not clear from your comment what did happen.) Also, exactly which PG version is this? regards, tom lane