Re: Monitoring database

On Wednesday, January 9, 2002, at 10:31  PM, Roman Gavrilov wrote:


<excerpt>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.

</excerpt>

Take a look here maybe:

http://gborg.postgresql.org/project/pgmonitor/projdisplay.php


<excerpt>One more question is how can I see all tables in the
template1 ?

Thanks allot.

</excerpt>

in the psql client: psql template1

\dt

\h is definately worth reading too.


<fontfamily><param>Helvetica</param>==============================

David Stanaway

Personal: david@stanaway.net

Work: david@netventures.com.au</fontfamily>
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@stanaway.net
Work: david@netventures.com.au