From: Ray Stell <stellr@cns.vt.edu>
To: pgsql-admin@postgresql.org
Subject: lock help
Date: Thu, 20 Mar 2008 09:36:37 -0400
Message-ID: <20080320133637.GA6306@cns.vt.edu> (raw)
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stellr@cns.vt.edu
Subject: Re: lock help
In-Reply-To: <20080320133637.GA6306@cns.vt.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox