From: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | lock help |
Date: | 2008-03-20 13:36:37 |
Message-ID: | 20080320133637.GA6306@cns.vt.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-03-20 14:42:29 | Re: lock help |
Previous Message | Abraham, Danny | 2008-03-20 13:28:41 | Looking for performance monitoring tool for PG |