Re: Who's attached to the database?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Who's attached to the database?
Дата
Msg-id 6657.1215114865@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Who's attached to the database?  (Carol Walter <walterc@indiana.edu>)
Список pgsql-admin
Carol Walter <walterc@indiana.edu> writes:
> 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?

pg_stat_activity ... or if you turned that off, "ps auxww | grep postgres"
(or local equivalent) might help.

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Who's attached to the database?
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: Who's attached to the database?