Monitoring database - Mailing list pgsql-admin

From Roman Gavrilov
Subject Monitoring database
Date
Msg-id 3C3C2A12.BB15E98@il.aduva.com
Whole thread Raw
Responses Re: Monitoring database
List pgsql-admin
Hello everybody.
Is there any way to check database status, or who is currently connected to it.
I tried to drop database and got an error saying that other users using this database.
So I wanted to see who is connected right now to the database.

One more question is how can I see all tables in the template1 ?
Thanks allot.

-- 
-----------------------------------------------------------------------------
 Roman Gavrilov                           
 Aduva Inc., Web Development Services.    
 work +972-3-7534324 mobile +972-54-834668
 romio@aduva.com, romio@netvision.net.il
 

pgsql-admin by date:

Previous
From: jairo emilio ortiz romero
Date:
Subject: I have a Question
Next
From: Mike Schroepfer
Date:
Subject: Insert Performance with WAL and Fsync