PostgreSQL admin or monitor program?

From: "Gary Huntress" <ghuntress(at)mediaone(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL admin or monitor program?
Date: 2001-04-08 00:06:00
Message-ID: IXNz6.45128$Wz.11517066@typhoon.ne.mediaone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

--
Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-04-08 03:04:23 Re: updates way slower than selects?
Previous Message Joel Burton 2001-04-07 19:52:00 Better Features document?