DB backup and connection questions

Поиск
Список
Период
Сортировка
От Carolyn Lu Wong
Тема DB backup and connection questions
Дата
Msg-id 39D96E38.D4BA7DB8@kss.net.au
обсуждение исходный текст
Список pgsql-sql
Can someone help me with the following?

1) Is there a command I can check which users are currently connecting
to a particular database? Is it possible to disconnect certain users who
are currently using the database? Can it also apply to connections to
the database via ODBC?

2) When doing database backup (pg_dump), is it necessary to 'kick' all
users connecting to the db?

Thanks in advance for any helps.


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

Предыдущее
От: drfrog@smartt.com
Дата:
Сообщение: Re: trigger examples
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Something I'd like to try...