Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AF1532E00B6 for ; Thu, 20 Mar 2008 10:37:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 07958-09 for ; Thu, 20 Mar 2008 10:36:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by postgresql.org (Postfix) with ESMTP id 4EB1C2E0048 for ; Thu, 20 Mar 2008 10:36:39 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 9526C118A60; Thu, 20 Mar 2008 09:36:37 -0400 (EDT) Date: Thu, 20 Mar 2008 09:36:37 -0400 From: Ray Stell To: pgsql-admin@postgresql.org Subject: lock help Message-ID: <20080320133637.GA6306@cns.vt.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/166 X-Sequence-Number: 28649 I have a db wedged and need help dealing with it. How can I find out more about this, who, what, where, etc, and how to free this up: ghiza=# select * from pg_user; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig ---------+----------+-------------+----------+-----------+----------+----------+----------- pgadmin | 10 | t | t | t | ******** | | ghiza | 16385 | f | f | f | ******** | | (2 rows) ghiza=# select version(); version --------------------------------------------------------------------------------------------------- PostgreSQL 8.2.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-9) (1 row)