| From: | Roman Gavrilov <romio(at)il(dot)aduva(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Monitoring database |
| Date: | 2002-01-09 11:31:30 |
| Message-ID: | 3C3C2A12.BB15E98@il.aduva.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Srinivasa Rao Chava | 2002-01-09 14:57:34 | dumping users objects |
| Previous Message | Jean-Christophe ARNU | 2002-01-09 10:15:59 | Vaccum and 24/7/365 database |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | BELLON Michel | 2002-01-09 15:16:41 | Unable to start |
| Previous Message | Alaric B. Snell | 2002-01-09 10:51:48 | Re: Query planner isn't using my indices |