DB backup and connection questions

From: Carolyn Lu Wong <carolyn(at)kss(dot)net(dot)au>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: DB backup and connection questions
Date: 2000-10-03 05:27:20
Message-ID: 39D96E38.D4BA7DB8@kss.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-sql by date

  From Date Subject
Next Message Carolyn Lu Wong 2000-10-03 07:05:24 Re: trigger examples
Previous Message Carolyn Lu Wong 2000-10-03 05:20:24 trigger examples