Re: Who's attached to the database?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Who's attached to the database?
Дата
Msg-id 486CE819.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Who's attached to the database?  (Carol Walter <walterc@indiana.edu>)
Ответы Re: Who's attached to the database?
Список pgsql-admin
>>> Carol Walter <walterc@indiana.edu> wrote:
> I'm trying to drop a database and I'm getting an error that says that

> the database is being accessed by other users.  Is there a way I can

> find out who these users are or if there really is a user accessing
it?

select * from pg_stat_activity where datname = 'yourdb';

-Kevin

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

Предыдущее
От: Carol Walter
Дата:
Сообщение: Who's attached to the database?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Who's attached to the database?