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 D4B5BD815A for ; Thu, 25 Aug 2005 11:28:11 -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 93505-05 for ; Thu, 25 Aug 2005 14:28:10 +0000 (GMT) Received: from hotmail.com (bay108-f30.bay108.hotmail.com [65.54.162.40]) by svr1.postgresql.org (Postfix) with ESMTP id 68BDFD814E for ; Thu, 25 Aug 2005 11:28:08 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 25 Aug 2005 07:28:13 -0700 Message-ID: Received: from 65.54.162.200 by by108fd.bay108.hotmail.msn.com with HTTP; Thu, 25 Aug 2005 14:28:13 GMT X-Originating-IP: [65.54.162.200] X-Originating-Email: [kevinrkeith@hotmail.com] X-Sender: kevinrkeith@hotmail.com From: "Kevin Keith" To: pgsql-admin@postgresql.org Subject: Question regarding blocking locks Date: Thu, 25 Aug 2005 09:28:13 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 25 Aug 2005 14:28:13.0559 (UTC) FILETIME=[39CDC870:01C5A981] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.582 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0, RCVD_IN_BL_SPAMCOP_NET=1.832] X-Spam-Level: *** X-Archive-Number: 200508/315 X-Sequence-Number: 18634 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). This was a personal development system so this was no big deal to reboot it. I would like to know what other options I have so if this was to occur in a production environment in the future I had a less drastic measure to take to resolve the issue. I saw the locks in the pg_locks view (the mode was Exclusivelock), Can someone point me in the right direction to addressing such a problem should it occur in the future? Thanks, Kevin _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/