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

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

pgsql-admin by date

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

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