lock help - Mailing list pgsql-admin

From Ray Stell
Subject lock help
Date
Msg-id 20080320133637.GA6306@cns.vt.edu
Whole thread Raw
Responses Re: lock help
List pgsql-admin
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)



pgsql-admin by date:

Previous
From: Aftab Alam
Date:
Subject: Re: Postgres Performance
Next
From: "Abraham, Danny"
Date:
Subject: Looking for performance monitoring tool for PG