Re: [ADMIN] Monitoring database

From: "Tim Barnard" <tbarnard(at)povn(dot)com>
To: <romio(at)il(dot)aduva(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: [ADMIN] Monitoring database
Date: 2002-01-14 15:36:29
Message-ID: 005b01c19d11$3c7e4e80$a519af3f@hartcomm.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

I don't think there is currently a way to check the database for connections (someone correct me if I'm wrong). But to get a list of all of the tables in template1:

\c template1
select relname from pg_class

Tim
----- Original Message -----
From: Roman Gavrilov
To: pgsql-admin(at)postgresql(dot)org
Sent: Wednesday, January 09, 2002 3:31 AM
Subject: [ADMIN] Monitoring database

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(at)aduva(dot)com, romio(at)netvision(dot)net(dot)il

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-01-14 16:43:57 Re: template database
Previous Message Rodrigo Miguel 2002-01-14 12:00:30 Using Database, 2 or more filesystem

Browse pgsql-general by date

  From Date Subject
Next Message Roderick A. Anderson 2002-01-14 15:44:31 Re: articles [was: mysql-pgsql comparison]
Previous Message Colm McCartan 2002-01-14 15:21:57 OT: anon CVS hassles