Skip site navigation (1) Skip section navigation (2)

lock help

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 (view raw or flat)
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)



Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2008-03-20 14:42:29
Subject: Re: lock help
Previous:From: Abraham, DannyDate: 2008-03-20 13:28:41
Subject: Looking for performance monitoring tool for PG

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group