Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id C0CEC632EB2
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 24 Aug 2010 10:25:35 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 11890-09 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 24 Aug 2010 13:25:27 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from outbound.afilias.info (outbound.afilias.info [69.46.124.26])
	by mail.postgresql.org (Postfix) with ESMTP id 48FE9632CA5
	for <pgsql-admin@postgresql.org>; Tue, 24 Aug 2010 10:25:28 -0300 (ADT)
Received: from ms5.yyz2.afilias-ops.info ([10.50.129.111]
	helo=smtp.afilias.info)
	by outbound.afilias.info with esmtp (Exim 4.69)
	(envelope-from <bnichols@ca.afilias.info>) id 1OntVG-0007dB-6b
	for pgsql-admin@postgresql.org; Tue, 24 Aug 2010 13:25:26 +0000
Received: from tor-gateway.afilias.info ([199.15.87.4] helo=[10.10.46.12])
	by smtp.afilias.info with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69)
	(envelope-from <bnichols@ca.afilias.info>) id 1OntVF-0008Fb-6F
	for pgsql-admin@postgresql.org; Tue, 24 Aug 2010 13:25:25 +0000
Message-ID: <4C73C843.2080301@ca.afilias.info>
Date: Tue, 24 Aug 2010 09:25:23 -0400
From: Brad Nicholson <bnichols@ca.afilias.info>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.7) Gecko/20100720 Lightning/1.0b2 Thunderbird/3.1.1
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Enterprise pg database monitoring
References: <BAY149-w182D83E88835FE657DF3CAE830@phx.gbl>
In-Reply-To: <BAY149-w182D83E88835FE657DF3CAE830@phx.gbl>
Content-Type: multipart/alternative;
	boundary="------------000608060008060509050303"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-4.209 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201008/172
X-Sequence-Number: 35421

This is a multi-part message in MIME format.
--------------000608060008060509050303
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

  On 10-08-24 05:35 AM, Kieren Scott wrote:
> Hi,
>
> I was interested in finding out how other people are monitoring their 
> postgres database estates.
> We use psql and pgAdmin for day to day dba admin tasks, but I was 
> wondering if there were any
> good tools available for monitoring such things as whether all of my 
> postgres cluster's were up and
> running (similar to oracle enterprise manager dare i say it)? Are 
> people just using shell scripts
> scheduled from cron to check such things? This could become an issue 
> if you had 100's of postgres
> instances and you need to roll out new monitoring scripts and cron 
> jobs to each...
>

Take a look at Hyperic.

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.



--------------000608060008060509050303
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#ffffff">
    On 10-08-24 05:35 AM, Kieren Scott wrote:
    <blockquote cite="mid:BAY149-w182D83E88835FE657DF3CAE830@phx.gbl"
      type="cite">
      <style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
      Hi,<br>
      <br>
      I was interested in finding out how other people are monitoring
      their postgres database estates.<br>
      We use psql and pgAdmin for day to day dba admin tasks, but I was
      wondering if there were any <br>
      good tools available for monitoring such things as whether all of
      my postgres cluster's were up and <br>
      running (similar to oracle enterprise manager dare i say it)? Are
      people just using shell scripts <br>
      scheduled from cron to check such things? This could become an
      issue if you had 100's of postgres <br>
      instances and you need to roll out new monitoring scripts and cron
      jobs to each...<br>
      <br>
    </blockquote>
    <br>
    Take a look at Hyperic.<br>
    <pre class="moz-signature" cols="72">-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.

</pre>
  </body>
</html>

--------------000608060008060509050303--