Обсуждение: Monitoring tool

Поиск
Список
Период
Сортировка

Monitoring tool

От
Pierre Ochsenbein
Дата:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx

Re: Monitoring tool

От
Shreeyansh Dba
Дата:
Yes, Nagios is the best DB monitoring/alerting tool and its free opensource.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx

Re: [MASSMAIL]Re: Monitoring tool

От
gilberto.castillo@etecsa.cu
Дата:
Similarly CHECK_MK

El 2019-01-11 11:04, Shreeyansh Dba escribió:
> Yes, Nagios is the best DB monitoring/alerting tool and its free
> opensource.
> 
> Thanks & Regards,
> SHREEYANSH DBA TEAM
> www.shreeyansh.com [1]
> 
> On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein
> <pierreochsenbein@gmail.com> wrote:
> 
>> Hey guys,
>> 
>> What is for you the best Monitoring/altering for PostgreSQL? Nagios?
>> 
>> Thx
> 
> 
> Links:
> ------
> [1] http://www.shreeyansh.com


Re: Monitoring tool

От
Ibrahim Edib Kokdemir
Дата:
What exactly is your expectation from a monitoring system? If it is just a postgres server that you want to monitor and and regular alerts, nagios is the shortest path. But if you want more, for example enterprise level monitoring system (graphs, history, maps, predictions) and if you have  many other servers along with postgres server(s), I personally suggest you zabbix, but zabbix needs some additional helpers like mamonsu or libzbxpgsql for  for postgres monitoring. 

Regards,
Ibrahim.

On Fri, 11 Jan 2019, 18:56 Pierre Ochsenbein <pierreochsenbein@gmail.com wrote:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx

Re: Monitoring tool

От
Ervin Weber
Дата:
Hello, Pierre.

In last postgresql.eu conference https://prometheus.io/  was mentioned
in several talks.

https://www.postgresql.eu/events/pgconfeu2018/schedule/session/2190-using-prometheus-and-grafana-for-postgresql-monitoring-in-tomtom/
for example.

That said I had a lot of time invested in munin (and to teach it to
use auto-discovery of everything), so personally did not yet switch to
use prometheus.

I'm most interested in advanced alert criteria that one could setup in
prometheus, and if you are looking for best alerting - it is worth
investigating.

Nagios may still be more popular choice, because it is older, and more
widespread. Yet when I was picking monitoring - I needed easy setup
and ability to write own plugins with little effort, so I picked munin
over nagios several years ago. Also there is opinion worth getting
your attention, if you do research on nagios -  saying  that nagios
may be too old for competition -
https://www.slideshare.net/superdupersheep/stop-using-nagios-so-it-can-die-peacefully

Best,
Ervin


On Fri, 11 Jan 2019 at 20:35, Ibrahim Edib Kokdemir <kokdemir@gmail.com> wrote:
>
> What exactly is your expectation from a monitoring system? If it is just a postgres server that you want to monitor
andand regular alerts, nagios is the shortest path. But if you want more, for example enterprise level monitoring
system(graphs, history, maps, predictions) and if you have  many other servers along with postgres server(s), I
personallysuggest you zabbix, but zabbix needs some additional helpers like mamonsu or libzbxpgsql for  for postgres
monitoring.
>
> Regards,
> Ibrahim.
>
> On Fri, 11 Jan 2019, 18:56 Pierre Ochsenbein <pierreochsenbein@gmail.com wrote:
>>
>> Hey guys,
>>
>> What is for you the best Monitoring/altering for PostgreSQL? Nagios?
>>
>> Thx


Re: Monitoring tool

От
Prince Pathria
Дата:
On what stats should we actually keep a track on?

On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba <shreeyansh2014@gmail.com wrote:
Yes, Nagios is the best DB monitoring/alerting tool and its free opensource.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx

RE: Monitoring tool

От
Kaido Vaikla
Дата:

And, what is your budget?
Or should it be a freeware?

br
Kaido

 

From: Prince Pathria [mailto:prince.pathria@goevive.com]
Sent: Saturday, January 12, 2019 12:06 AM
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Monitoring tool

 

On what stats should we actually keep a track on?

 

On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba <shreeyansh2014@gmail.com wrote:

Yes, Nagios is the best DB monitoring/alerting tool and its free opensource.

 

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:

Hey guys,

 

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

 

Thx

Re: Monitoring tool

От
Ramesh naik
Дата:
Hi Pierre,

Zabbix and nagios  are old school monitoring tools. 
Try to setup your own monitoring stack using  (node_exporter+ postgres_exporter), Prometheus and  Grafana.   
Checkout pgmonitor from crunchydata 

And check the latest   slide pack  on PostgreSQL monitoring using Prometheus n Grafana from Gregory Stark 
Regards,
Ramesh 


On Sat, 12 Jan 2019 at 6:07 AM, Prince Pathria <prince.pathria@goevive.com> wrote:
On what stats should we actually keep a track on?

On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba <shreeyansh2014@gmail.com wrote:
Yes, Nagios is the best DB monitoring/alerting tool and its free opensource.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx
--
Regards,
Ramesh Naik E 

+65 8202 7519


Re: Monitoring tool

От
Shreeyansh Dba
Дата:
There are various PostgreSQL plugins available for collecting the DB stats via Nagios.  Like check_postgres, check_pgactivity etc. that you can configure as per your requirements or you can also create your own script for monitoring.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Sat, Jan 12, 2019 at 3:37 AM Prince Pathria <prince.pathria@goevive.com> wrote:
On what stats should we actually keep a track on?

On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba <shreeyansh2014@gmail.com wrote:
Yes, Nagios is the best DB monitoring/alerting tool and its free opensource.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx

Re: Monitoring tool

От
Pierre Ochsenbein
Дата:
Thanks a lot for your feedback guys !

I would like a free monitoring tool

Le ven. 11 janv. 2019 à 23:23, Kaido Vaikla <Kaido.Vaikla@telia.ee> a écrit :
And, what is your budget?
Or should it be a freeware?

br
Kaido

From: Prince Pathria [mailto:prince.pathria@goevive.com]
Sent: Saturday, January 12, 2019 12:06 AM
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Monitoring tool

On what stats should we actually keep a track on?

On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com> wrote:
Yes, Nagios is the best DB monitoring/alerting tool and its free opensource.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com<http://www.shreeyansh.com>


On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbein@gmail.com<mailto:pierreochsenbein@gmail.com>> wrote:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx


--
Cordialement,

Pierre Ochsenbein
Mobile: +33668295394

Re: Monitoring tool

От
Bharat Telange
Дата:
In opensource, nagios and zabbix are already referred in trail mail. Similarly, pgwatch2 is also a good option. 


Regards,
Bharat

On Sat, 12 Jan, 2019, 8:28 PM Pierre Ochsenbein <pierreochsenbein@gmail.com wrote:
Thanks a lot for your feedback guys !

I would like a free monitoring tool

Le ven. 11 janv. 2019 à 23:23, Kaido Vaikla <Kaido.Vaikla@telia.ee> a écrit :
And, what is your budget?
Or should it be a freeware?

br
Kaido

From: Prince Pathria [mailto:prince.pathria@goevive.com]
Sent: Saturday, January 12, 2019 12:06 AM
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Monitoring tool

On what stats should we actually keep a track on?

On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com> wrote:
Yes, Nagios is the best DB monitoring/alerting tool and its free opensource.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com<http://www.shreeyansh.com>


On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbein@gmail.com<mailto:pierreochsenbein@gmail.com>> wrote:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx


--
Cordialement,

Pierre Ochsenbein
Mobile: +33668295394