lock help

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)