Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1B6AA9FA06E for ; Wed, 27 Dec 2006 04:46:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 56121-06 for ; Wed, 27 Dec 2006 04:46:18 -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.238]) by postgresql.org (Postfix) with ESMTP id C09429FA222 for ; Wed, 27 Dec 2006 04:46:26 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so1770245nzh for ; Wed, 27 Dec 2006 00:46:25 -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=PRiP5VxqirtRgNMjMmQazFDDRWvUn5d6nfUwvsKwHV+HiLRLOTyZ7GovLYdDBj9TWLNc1VgaDlBY0dz0/vbGrX7nbpSQ/c8x+BqePsz7G98pXw8PhK5COEMyUs3PSKOoNO5RLIpFtZokPb+WOnARMFVxtAdlOoFqxwqwYUDIQd4= Received: by 10.64.131.4 with SMTP id e4mr18763249qbd.1167209185619; Wed, 27 Dec 2006 00:46:25 -0800 (PST) Received: by 10.65.206.17 with HTTP; Wed, 27 Dec 2006 00:46:25 -0800 (PST) Message-ID: Date: Wed, 27 Dec 2006 13:46:25 +0500 From: "Shoaib Mir" To: "Rajesh Kumar Mallah" Subject: Re: About Monitoring Software Cc: iannsp@gmail.com, pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_62884_33371964.1167209185540" 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/331 X-Sequence-Number: 24123 ------=_Part_62884_33371964.1167209185540 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 'EnterpriseDB Management Server' ( http://www.enterprisedb.com/products/enterprisedb_mgmtsvr.do) can be a good option as with your requirements.... ----------------------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/27/06, Rajesh Kumar Mallah wrote: > > > > 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 fo= r > each service monitored. > > We use nagios for monitoring port 5432. It is also possible to make nagio= s > 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 you= r > > message can get through to the mailing list cleanly > > > > ------=_Part_62884_33371964.1167209185540 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 'EnterpriseDB Management Server' (http://www.enterprisedb.com/product= s/enterprisedb_mgmtsvr.do) can be a good option as with your requiremen= ts....

-----------------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/27/06, Rajesh Kumar = Mallah <mallah.rajesh@gmail.com= > wrote:


On 12/27/06, Iannsp <iannsp@gmail.com > 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 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 informa= tions 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.<= br> You may consider writing custom software using rrdtools for archiving
historical data.

Regds
mallah.
Thank you.



--
Ivo Nascimento
Iann t= ech - 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_62884_33371964.1167209185540--