pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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)





view thread (3+ messages)  latest in thread

Message-ID: <20080320133637.GA6306@cns.vt.edu>
Permalink:  ../20080320133637.GA6306@cns.vt.edu/
Also on:    postgresql.org/message-id/20080320133637.GA6306@cns.vt.edu

 · 

reply

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