Re: Find who is connected to a database

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Naomi Walker" <nwalker(at)mhs(dot)mphasis(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Find who is connected to a database
Date: 2007-10-31 14:42:13
Message-ID: dcc563d10710310742x7c709021lb36b9551d5cec62b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 10/26/07, Naomi Walker <nwalker(at)mhs(dot)mphasis(dot)com> wrote:
> I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris
> 10 OS), but someone is connected to
> the database. What is the best way to find out exactly who is connected?

select * from pg_stat_activity;

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jessica Richard 2007-10-31 14:50:51 how to check objects dependency??
Previous Message yogesh 2007-10-31 11:29:34 PL/JAVA issues