Thread: Any Monitoring Tools for Postgres?

Any Monitoring Tools for Postgres?

From
"Nigel Bishop"
Date:
Hi

Apart from Chapter 10/11 of the Docs and writing scripts, does anyone
know of any tools for 'real-time' monitoring of 7.3.2 DBs.

PGAdminII is fine for admin.

Thanks

Nigel Bishop


Re: Any Monitoring Tools for Postgres?

From
Robert Treat
Date:
On Fri, 2003-03-21 at 05:21, Nigel Bishop wrote:
> Hi
>
> Apart from Chapter 10/11 of the Docs and writing scripts, does anyone
> know of any tools for 'real-time' monitoring of 7.3.2 DBs.
>

I believe red hat's postgresql project has a couple of monitoring tools,
and I know Bruce has one available at
http://gborg.postgresql.org/project/pgmonitor/projdisplay.php

I'm also pretty sure there are some listed on the techdocs site.

Robert Treat



Re: Any Monitoring Tools for Postgres?

From
Tim Ellis
Date:
> > Apart from Chapter 10/11 of the Docs and writing scripts, does anyone
> > know of any tools for 'real-time' monitoring of 7.3.2 DBs.

I've been pretty happy with DBVisualizer from Minq software. The free
version of their app runs on Linux & Windows (and whatever else has a
Java runtime environment), and you can write queries that it will submit
every X seconds (you define X) such as, say, disk accesses, connections,
etc.

It doesn't graph the results, which is a bummer, but for instantaneous
monitoring, it's extremely useful.

The pay version does a lot more, but honestly, I couldn't say what more
it does, since no company I've worked for has had the stellar budget
required to pay the $80 for a client license. [/bitter sarcasm]

--
Tim Ellis
Senior Database Architect and author, tedia2sql (http://tedia2sql.tigris.org)
If this helped you, http://svcs.affero.net/rm.php?r=philovivero