Re: How can I see which users are connected?

From: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>
To: Jacob Vennervald Madsen <jvm(at)gopinocchio(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How can I see which users are connected?
Date: 2002-03-11 14:56:31
Message-ID: 3C8CC59F.8020203@mmrd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jacob Vennervald Madsen wrote:

> Hi List
>
> I'm trying to drop a database but I get this error:
> ERROR: DROP DATABASE: database "mydb" is being accessed by other users
>
> How can I see which user that is and from where he is connected?

I'm not so sure about the user, but a regular old 'ps -ax' will show you
what IP the connections are coming from, and what query they're running.

-Fran

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2002-03-11 15:02:18 Re: Unable to identify an operator '=' for types 'numeric' and 'double precision'
Previous Message Darren Ferguson 2002-03-11 14:53:30 Re: FROM Clause subquery