| From: | David Stanaway <david(at)netventures(dot)com(dot)au> |
|---|---|
| To: | romio(at)il(dot)aduva(dot)com |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Monitoring database |
| Date: | 2002-01-15 00:16:04 |
| Message-ID: | 103EAC6B-094D-11D6-9DC5-0003930FDAB2@netventures.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote:
> 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.
Take a look here maybe:
http://gborg.postgresql.org/project/pgmonitor/projdisplay.php
> One more question is how can I see all tables in the template1 ?
> Thanks allot.
in the psql client: psql template1
\dt
\h is definately worth reading too.
==============================
David Stanaway
Personal: david(at)stanaway(dot)net
Work: david(at)netventures(dot)com(dot)au
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chad R. Larson | 2002-01-15 00:56:29 | Re: Using Database, 2 or more filesystem |
| Previous Message | GB Clark | 2002-01-14 21:46:07 | Re: HELP: language option software package not installed |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve | 2002-01-15 00:39:22 | Re: Having problem with initdb on my Solaris 8 box |
| Previous Message | Justin Clift | 2002-01-14 23:43:07 | Re: Very large database |