Обсуждение: How can I see which users are connected?

Поиск
Список
Период
Сортировка

How can I see which users are connected?

От
"Jacob Vennervald Madsen"
Дата:
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?

Jacob

Re: How can I see which users are connected?

От
Fran Fabrizio
Дата:
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