Обсуждение: DB backup and connection questions

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

DB backup and connection questions

От
Carolyn Lu Wong
Дата:
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.