Re: About Monitoring Software

'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 <mallah(dot)rajesh(at)gmail(dot)com> wrote:
>
>
>
> On 12/27/06, Iannsp <iannsp(at)gmail(dot)com> 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ções com performance e segurança
> > http://www.ianntech.com.br
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
>
>