Received: from kss.net.au ([203.41.122.41]) by hub.org (8.10.1/8.10.1) with ESMTP id e934RVr02729 for ; Tue, 3 Oct 2000 00:27:31 -0400 (EDT) Received: from kss.net.au (coco [10.10.1.9]) by kss.net.au (8.8.7/8.8.7) with ESMTP id PAA28681 for ; Tue, 3 Oct 2000 15:26:54 +1000 Message-ID: <39D96E38.D4BA7DB8@kss.net.au> Date: Tue, 03 Oct 2000 15:27:20 +1000 From: Carolyn Lu Wong Organization: Kwiker Software Solutions X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: DB backup and connection questions Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/12 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.