Re: How can I see which users are connected?

Поиск
Список
Период
Сортировка
От Fran Fabrizio
Тема Re: How can I see which users are connected?
Дата
Msg-id 3C8CC59F.8020203@mmrd.com
обсуждение исходный текст
Ответ на How can I see which users are connected?  ("Jacob Vennervald Madsen" <jvm@gopinocchio.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Program lose the connection to backend
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: Unable to identify an operator '=' for types 'numeric' and 'double precision'