Re: PostgreSQL admin or monitor program?

> Is there a PostgreSQL equivalent for the MySQL program mysqladmin? My
> system load jumped and using top I saw that it was due to postmaster. With
> mysqladmin I can show the mysql processlist and see the list of connections
> and who is doing what. I've looked through the indexes for all the
> documentation at http://www.postgresql.org/devel-corner/docs/ (and I've read
> most of them) but I don't see an equivalent function.
>
> What is the best way to do mundane things like list active users and their
> state, list stats about the server (mysqladmin will list uptime, number of
> queries issued, queries per second etc), kill a user, etc? Can psql do
> this or do I need a seperate client?

Sure, try my new pgmonitor tool:

http://greatbridge.org/project/pgmonitor/projdisplay.php

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026