DB backup and connection questions - Mailing list pgsql-sql

From Carolyn Lu Wong
Subject DB backup and connection questions
Date
Msg-id 39D96E38.D4BA7DB8@kss.net.au
Whole thread Raw
List 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 by date:

Previous
From: drfrog@smartt.com
Date:
Subject: Re: trigger examples
Next
From: Tom Lane
Date:
Subject: Re: Something I'd like to try...