Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id B117163376D
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 16 Jul 2010 09:52:12 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 32835-03-3
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 16 Jul 2010 12:52:04 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62])
	by mail.postgresql.org (Postfix) with ESMTP id 9E075632C34
	for <pgsql-admin@postgresql.org>; Fri, 16 Jul 2010 09:51:57 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by hermes.vectorsf.com (Postfix) with ESMTP id 74FBA11C12F7;
	Fri, 16 Jul 2010 14:51:52 +0200 (CEST)
X-Virus-Scanned: amavisd-new at hermes.vectorsf.com
Received: from hermes.vectorsf.com ([127.0.0.1])
	by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id uIl1SUFInHyg; Fri, 16 Jul 2010 14:51:48 +0200 (CEST)
Received: from [10.70.4.200] (unknown [10.70.4.200])
	(Authenticated sender: imartinez)
	by hermes.vectorsf.com (Postfix) with ESMTP id 30EB511C12F9;
	Fri, 16 Jul 2010 14:51:48 +0200 (CEST)
Subject: Re: Postgres Monitoring Tool we can use
From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com>
To: Khangelani Gama <Khangelani.Gama@ucs-software.co.za>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <D78A8169F9436B4DB978300336168F3B34C31AE408@SWBREXCH00.ucs-software.net>
References: 
 <D78A8169F9436B4DB978300336168F3B34C31AE408@SWBREXCH00.ucs-software.net>
Content-Type: multipart/alternative; boundary="=-N+qKRpH5oqiBj9957wP+"
Date: Fri, 16 Jul 2010 14:51:50 +0200
Message-ID: <1279284710.12237.88.camel@deimos>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.3 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.791 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201007/105
X-Sequence-Number: 35124


--=-N+qKRpH5oqiBj9957wP+
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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)

 



--=-N+qKRpH5oqiBj9957wP+
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.28.3">
</HEAD>
<BODY LINK="#0000ff">
pgadmin3 could be an option.<BR>
Server status will tell you what queries are being running, from what clients, and what tables are being locked.<BR>
It should come with your linux distro.<BR>
<BR>
-----Original Message-----<BR>
<B>From</B>: Khangelani Gama &lt;<A HREF="mailto:Khangelani%20Gama%20%3cKhangelani.Gama@ucs-software.co.za%3e">Khangelani.Gama@ucs-software.co.za</A>&gt;<BR>
<B>To</B>: pgsql-admin@postgresql.org &lt;<A HREF="mailto:%22pgsql-admin@postgresql.org%22%20%3cpgsql-admin@postgresql.org%3e">pgsql-admin@postgresql.org</A>&gt;<BR>
<B>Subject</B>: [ADMIN] Postgres Monitoring Tool we can use<BR>
<B>Date</B>: Fri, 16 Jul 2010 14:10:58 +0200<BR>
<BR>
Hi <BR>
<BR>
&nbsp;<BR>
<BR>
Can someone suggest the best monitoring tool we can use in out enterprise db running on version 8.3 with Linux Redhat 5.<BR>
<BR>
&nbsp;<BR>
<BR>
We just need something that can tell us if there is any activity inside the database and what that activity is.<BR>
<BR>
&nbsp;<BR>
<BR>
Thanks in Advanced<BR>
<BR>
Khangelani (Junior DBA)<BR>
<BR>
&nbsp;<BR>
<BR>
<BR>
</BODY>
</HTML>

--=-N+qKRpH5oqiBj9957wP+--