pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
About Monitoring Software
3+ messages / 3 participants
[nested] [flat]

* About Monitoring Software
@ 2006-12-27 01:05  Iannsp <iannsp@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Iannsp @ 2006-12-27 01:05 UTC (permalink / raw)
  To: pgsql-admin

Hi,
I did like to know with some one here use some think like nagios to 
monitoring postgresql.
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, number of connections, user logged,
more commom values listed by field in the table,Use of disk, index and 
another things.
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 ?

Thank you.



-- 
Ivo Nascimento
Iann tech - Desenvolvendo soluções com performance e segurança
http://www.ianntech.com.br





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: About Monitoring Software
@ 2006-12-27 03:48  Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  parent: Iannsp <iannsp@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Rajesh Kumar Mallah @ 2006-12-27 03:48 UTC (permalink / raw)
  To: iannsp@gmail.com; +Cc: pgsql-admin

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
> 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@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: About Monitoring Software
@ 2006-12-27 08:46  Shoaib Mir <shoaibmir@gmail.com>
  parent: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Shoaib Mir @ 2006-12-27 08:46 UTC (permalink / raw)
  To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>; +Cc: iannsp@gmail.com; pgsql-admin

'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.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
> > 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@postgresql.org so that your
> >        message can get through to the mailing list cleanly
> >
>
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-12-27 08:46 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-27 01:05 About Monitoring Software Iannsp <iannsp@gmail.com>
2006-12-27 03:48 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2006-12-27 08:46   ` Shoaib Mir <shoaibmir@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox