Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id F25686324FB for ; Tue, 20 Jan 2009 07:36:07 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88963-07 for ; Tue, 20 Jan 2009 07:35:59 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.30]) by mail.postgresql.org (Postfix) with ESMTP id 675576324E4 for ; Tue, 20 Jan 2009 07:35:57 -0400 (AST) Received: by yx-out-2324.google.com with SMTP id 8so1330234yxb.73 for ; Tue, 20 Jan 2009 03:35:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=mLkORzGCUN86I7NkRzIo0OE+2QLUikBCWKpzqlwjlfI=; b=xjXaO6EsLRiD9raA7jDF/ethWB2UfNiJP1RqE6MwAmXPXU5I/RYuzPGXo0/OOqJIaW cCCicCZ/X2eP9Pifm6E3fNppgxGcSGoIKxl7MvhoLtvQrGcnlSf5XRqhEWyiypZIt6Q9 JVkM2xoFlaYvsTskpPo+vWN6KxZ/mlQjSH48s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=qgtIeRsa4Ch18YUQ+GrIRpNMpauiBXi9MKVQ01n5OEB0gLznGyyIMUsjnh9wCotZTK 5FTXwFph6TDqe7giyYXGqKpkmnlJ+a2Eqciv5/JyHJsT2/aBPAQaYfRuHl3sgAcN/0Ci RkBKHrc1Ev95+06mZU3yew87KY5rXmf9bfUVs= MIME-Version: 1.0 Received: by 10.100.168.18 with SMTP id q18mr4722559ane.7.1232451355906; Tue, 20 Jan 2009 03:35:55 -0800 (PST) In-Reply-To: <20090120082907.GB13316@sun.ac.za> References: <14369888-7712-48EC-966C-7A0878360C22@zeroaccess.org> <4974A5DF.20002@dalibo.com> <20090120082907.GB13316@sun.ac.za> Date: Tue, 20 Jan 2009 17:05:55 +0530 Message-ID: <399c75c20901200335j2f00f911gf78fcb34ead9ab43@mail.gmail.com> Subject: Re: PostgreSQL monitoring From: ashok raj To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0016e640c6aa4592cf0460e8712d X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200901/69 X-Sequence-Number: 31116 --0016e640c6aa4592cf0460e8712d Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable RRD tool can used for drawing graphs by fetching the statics from DB servers and plotting graphs store it an image file and embedded it on the HTML page to look it nice . 2009/1/20 Johann Spies > On Mon, Jan 19, 2009 at 05:10:07PM +0100, C=E9dric Villemain wrote: > > Note that you have some plugins : > > > > * http://bucardo.org/check_postgres/ (plugin for nagios and others) > > * http://muninpgplugins.projects.postgresql.org/ (for munin) > > > > Thanks for these links. I am trying out the muninpgplugins but I get > "Global symbol "$statscope" requires explicit package name at > /etc/munin/plugins//pg_exilog_stat_database line 179". > Execution of /etc/munin/plugins/pg_exilog_stat_database aborted due to > compilation errors. > > > I have the following in /etc/munin/plugin-conf.d/munin-node > > [pg_exilog*] > user postgres > env.dbhost localhost > env.dbname exilog > env.dbpass xxxxxxxxxx > env.dbuser exilog > > Any idea why I get the error message? > > Regards > Johann > > -- > Johann Spies Telefoon: 021-808 4036 > Informasietegnologie, Universiteit van Stellenbosch > > "Neither is there salvation in any other; for there is > none other name under heaven given among men, whereby > we must be saved." Acts 4:12 > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > --=20 __________________________________________| Regards, Ashokraj 9940419867 --0016e640c6aa4592cf0460e8712d Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable  RRD tool can used for drawing graphs by fetching the statics from DB = servers and plotting graphs store it an image file and embedded it on the H= TML page to look it nice .
 

200= 9/1/20 Johann Spies <jspies@sun.ac.za>
On Mon, Jan 19, 2009 at 05:10:07PM +0100, C=E9dric Villemain wrote: > Note that you have some plugins :
>
>  * http://bucardo.org/check_postgres/ (plugin for nagios and others) >  * http://muninpgplugins.projects.postgresql.org/ (for muni= n)
>

Thanks for these links.  I am trying out the muninpgplugins but = I get
"Global symbol "$statscope" requires explicit package name a= t /etc/munin/plugins//pg_exilog_stat_database line 179".
Execution of /etc/munin/plugins/pg_exilog_stat_database aborted due to comp= ilation errors.


I have the following in /etc/munin/plugin-conf.d/munin-node

[pg_exilog*]
user postgres
env.dbhost localhost
env.dbname exilog
env.dbpass xxxxxxxxxx
env.dbuser exilog

Any idea why I get the error message?

Regards
Johann

--
Johann Spies          Telefoon: 021-808 4036
Informasietegnologie, Universiteit van Stellenbosch

    "Neither is there salvation in any other; for there is<= br>      none other name under heaven given among men, whereby<= br>      we must be saved."         &n= bsp;     Acts 4:12

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



--
___________= _______________________________|
Regards,
Ashokraj
9940419867
<= br> --0016e640c6aa4592cf0460e8712d--