pgadmin3 could be an option.
Server status will tell you what queries are being running, from what clients, and what tables are being locked.
It should come with your linux distro.
-----Original Message-----
From: Khangelani Gama <
Khangelani.Gama@ucs-software.co.za>
To: pgsql-admin@postgresql.org <
pgsql-admin@postgresql.org>
Subject: [ADMIN] Postgres Monitoring Tool we can use
Date: Fri, 16 Jul 2010 14:10:58 +0200
Hi
Can someone suggest the best monitoring tool we can use in out enterprise db running on version 8.3 with Linux Redhat 5.
We just need something that can tell us if there is any activity inside the database and what that activity is.
Thanks in Advanced
Khangelani (Junior DBA)