Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 088E09F93A2 for ; Tue, 26 Dec 2006 23:48:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 30218-03 for ; Tue, 26 Dec 2006 23:48:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.228]) by postgresql.org (Postfix) with ESMTP id A85CD9F938C for ; Tue, 26 Dec 2006 23:48:14 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so1750974nzh for ; Tue, 26 Dec 2006 19:48:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=V6xEzu0PoRZHNXKc8Ydanzp55d7VzWi2lx4/Tl7afJdqtNPJmXEBnCTmIGy3Af24e9iO/nHK9ynHPaMzdsWKKDbl1QYn8wVY+q4E935U2+2EXwUT0+TuSrDoYi/+ofos9JzH/YtMU2q7B4ez/UqkZlWf9hkBg3yKfN0GULeSLYA= Received: by 10.35.103.12 with SMTP id f12mr25682359pym.1167191293296; Tue, 26 Dec 2006 19:48:13 -0800 (PST) Received: by 10.35.80.4 with HTTP; Tue, 26 Dec 2006 19:48:13 -0800 (PST) Message-ID: Date: Wed, 27 Dec 2006 09:18:13 +0530 From: "Rajesh Kumar Mallah" To: iannsp@gmail.com Subject: Re: About Monitoring Software Cc: pgsql-admin@postgresql.org In-Reply-To: <4591C6F1.5020908@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_27436_26534309.1167191293246" References: <17884.22499-2302-1529746209-1167145841@seznam.cz> <45913EFB.5050506@mailnetwork.co.uk> <4591B932.7090307@gmail.com> <4591BB63.9080408@mailnetwork.co.uk> <4591C6F1.5020908@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/330 X-Sequence-Number: 24122 ------=_Part_27436_26534309.1167191293246 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 12/27/06, Iannsp wrote: > > Hi, > I did like to know with some one here use some think like nagios to > monitoring postgresql. Dear Iannsp, Nagios is a general purpose monitoring and alerting tool. Any service can have only three states NORMAL , WARNING and CRITICAL, there are plugins(program) both inbuilt or custom made that can probe for a parameter and update nagios database. Threshold for warning and critical states are defined for each service monitored. We use nagios for monitoring port 5432. It is also possible to make nagios run "SELECT 1;" so that you really know that database is answering queries. I said this because I'm work in one software to make this and I never > find onde tool to monitoring postgresql with adminsitractive data like > actual run proccess and the query's Possible. , number of connections, Possible user logged, > more commom values listed by field in the table,Use of disk, index and > another things. Diskspace monitoring Some one people know one tool to monitoring this informations using web > browser and have permission to change some one datas in the > postgresql.conf, pg_hba.conf ? Nagios is not suitable for above, its monitoring and alerting tool mainly. You may consider writing custom software using rrdtools for archiving historical data. Regds mallah. > Thank you. > > > > -- > Ivo Nascimento > Iann tech - Desenvolvendo solu=E7=F5es com performance e seguran=E7a > http://www.ianntech.com.br > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > ------=_Part_27436_26534309.1167191293246 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

On 12/27/06, Iannsp <iannsp@gmail.co= m> wrote:
Hi,
I did like to know with some one here use some think like nagios to<= br>monitoring postgresql.

Dear  Iannsp,

Nagios is a general purpose monitoring and alerting tool. Any service can h= ave only
three states NORMAL , WARNING and CRITICAL, there are plugins(program)
both inbuilt or custom made that can probe for a  parameter and update=
nagios database. Threshold for warning and critical states are defined for<= br> each service monitored.

We use nagios for monitoring port 5432. It is also possible to make nagios<= br> run "SELECT 1;"  so that you really know that database is an= swering
queries.
 

I= said this because I'm work in one software to make this and I neverfind onde tool to monitoring postgresql with adminsitractive data like
actual run proccess and the query's

Possible.
 

,= number of connections,

Possible

user l= ogged,
more commom values listed by field in the table,Use of disk, inde= x and
another things.

Diskspace monitoring
 

S= ome one people know one tool to monitoring this informations using web
b= rowser and have permission to change some one datas in the
postgresql.conf, pg_hba.conf ?

Nagios is not suitable for above, its monitoring and alerting tool mainly.<= br> You may consider writing custom software using rrdtools for archiving
historical data.

Regds
mallah.
Thank = you.



--
Ivo Nascimento
Iann tech - Desenvolvendo solu= =E7=F5es com performance e seguran=E7a
http://www.ianntech.com.br


---------------------------(end of broadcast)----------------= -----------
TIP 1: if posting/reading through Usenet, please send an app= ropriate
       subscribe-nomail command to majordomo@postgresql.org so that = your
       message can get through to the= mailing list cleanly

------=_Part_27436_26534309.1167191293246--