pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMonitoring Tool
15+ messages / 12 participants
[nested] [flat]
* Monitoring Tool
@ 2007-11-14 09:50 Hutger Hauer <hutger@gmail.com>
0 siblings, 1 reply; 15+ messages in thread
From: Hutger Hauer @ 2007-11-14 09:50 UTC (permalink / raw)
To: pgsql-admin
Dear all,
I'm looking for a monitoring tool that helps me to pick performance
informations (heap blocks, buffer hits, etc) about a specific PostgreSQL DB
or table, such as MRTG does.
Does someone know a tool that can provide me such information?
Thanks in advance.
Hutger
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Monitoring Tool
@ 2007-11-14 10:11 Cédric Villemain <cedric.villemain@dalibo.com>
parent: Hutger Hauer <hutger@gmail.com>
0 siblings, 0 replies; 15+ messages in thread
From: Cédric Villemain @ 2007-11-14 10:11 UTC (permalink / raw)
To: Hutger Hauer <hutger@gmail.com>; +Cc: pgsql-admin
Hutger Hauer a écrit :
> Dear all,
>
>
>
> I'm looking for a monitoring tool that helps me to pick performance
> informations (heap blocks, buffer hits, etc) about a specific PostgreSQL DB
> or table, such as MRTG does.
>
>
>
> Does someone know a tool that can provide me such information?
>
>
Have a look at munin, it is simple to use. http://munin.projects.linpro.no/
>
>
> Thanks in advance.
>
>
>
> Hutger
>
>
>
>
>
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* monitoring tool
@ 2018-09-13 11:48 Pierre Ochsenbein <pierreochsenbein@gmail.com>
0 siblings, 1 reply; 15+ messages in thread
From: Pierre Ochsenbein @ 2018-09-13 11:48 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi Guy's,
What is for you the best monitoring tool for PostgreSQL which we can
monitor a lot of databases?
Cheers,
Pierre
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: monitoring tool
@ 2018-09-13 12:43 flatley <tflatley@gmail.com>
parent: Pierre Ochsenbein <pierreochsenbein@gmail.com>
0 siblings, 0 replies; 15+ messages in thread
From: flatley @ 2018-09-13 12:43 UTC (permalink / raw)
To: pierreochsenbein@gmail.com; +Cc: pgsql-admin@lists.postgresql.org
1) pgwatch2 - excellent metrics / performance dashboard - easy to
configure https://www.cybertec-postgresql.com/en/products/pgwatch2/
2) pghero - great for highlighting problems at the db level - easy to
configure as well - https://github.com/ankane/pghero
pgdash is supposed to be very good - https://pgdash.io/
netdata is an awesome product - more of a system monitoring tool but it
does have a postgres plugin - this tool is very slick -
https://github.com/firehol/netdata/wiki
datadog is another system wide metrics tool - very impressive -
https://docs.datadoghq.com/integrations/postgres/
On Thu, Sep 13, 2018 at 7:49 AM Pierre Ochsenbein <
pierreochsenbein@gmail.com> wrote:
> Hi Guy's,
>
> What is for you the best monitoring tool for PostgreSQL which we can
> monitor a lot of databases?
>
> Cheers,
> Pierre
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Monitoring tool
@ 2019-01-11 15:53 Pierre Ochsenbein <pierreochsenbein@gmail.com>
0 siblings, 2 replies; 15+ messages in thread
From: Pierre Ochsenbein @ 2019-01-11 15:53 UTC (permalink / raw)
To: pgsql-admin
Hey guys,
What is for you the best Monitoring/altering for PostgreSQL? Nagios?
Thx
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Monitoring tool
@ 2019-01-11 16:04 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: Pierre Ochsenbein <pierreochsenbein@gmail.com>
1 sibling, 2 replies; 15+ messages in thread
From: Shreeyansh Dba @ 2019-01-11 16:04 UTC (permalink / raw)
To: Pierre Ochsenbein <pierreochsenbein@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [MASSMAIL]Re: Monitoring tool
@ 2019-01-11 16:32 gilberto.castillo@etecsa.cu
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
1 sibling, 0 replies; 15+ messages in thread
From: gilberto.castillo@etecsa.cu @ 2019-01-11 16:32 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Monitoring tool
@ 2019-01-11 18:35 Ibrahim Edib Kokdemir <kokdemir@gmail.com>
parent: Pierre Ochsenbein <pierreochsenbein@gmail.com>
1 sibling, 1 reply; 15+ messages in thread
From: Ibrahim Edib Kokdemir @ 2019-01-11 18:35 UTC (permalink / raw)
To: Pierre Ochsenbein <pierreochsenbein@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Monitoring tool
@ 2019-01-11 18:54 Ervin Weber <webervin@gmail.com>
parent: Ibrahim Edib Kokdemir <kokdemir@gmail.com>
0 siblings, 0 replies; 15+ messages in thread
From: Ervin Weber @ 2019-01-11 18:54 UTC (permalink / raw)
To: Ibrahim Edib Kokdemir <kokdemir@gmail.com>; +Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql-admin
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...
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 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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Monitoring tool
@ 2019-01-11 22:06 Prince Pathria <prince.pathria@goevive.com>
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
1 sibling, 3 replies; 15+ messages in thread
From: Prince Pathria @ 2019-01-11 22:06 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql-admin
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
>>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* RE: Monitoring tool
@ 2019-01-11 22:23 Kaido Vaikla <Kaido.Vaikla@telia.ee>
parent: Prince Pathria <prince.pathria@goevive.com>
2 siblings, 1 reply; 15+ messages in thread
From: Kaido Vaikla @ 2019-01-11 22:23 UTC (permalink / raw)
To: Prince Pathria <prince.pathria@goevive.com>; Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Monitoring tool
@ 2019-01-12 00:14 Ramesh naik <ramesh.esl@gmail.com>
parent: Prince Pathria <prince.pathria@goevive.com>
2 siblings, 0 replies; 15+ messages in thread
From: Ramesh naik @ 2019-01-12 00:14 UTC (permalink / raw)
To: Prince Pathria <prince.pathria@goevive.com>; +Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; Shreeyansh Dba <shreeyansh2014@gmail.com>; pgsql-admin
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
https://github.com/CrunchyData/pgmonitor
And check the latest slide pack on PostgreSQL monitoring using
Prometheus n Grafana from Gregory Stark
https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2166/slides/147/monitoring.pdf
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Monitoring tool
@ 2019-01-12 05:26 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: Prince Pathria <prince.pathria@goevive.com>
2 siblings, 0 replies; 15+ messages in thread
From: Shreeyansh Dba @ 2019-01-12 05:26 UTC (permalink / raw)
To: Prince Pathria <prince.pathria@goevive.com>; +Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql-admin
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
>>>
>>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Monitoring tool
@ 2019-01-12 14:57 Pierre Ochsenbein <pierreochsenbein@gmail.com>
parent: Kaido Vaikla <Kaido.Vaikla@telia.ee>
0 siblings, 1 reply; 15+ messages in thread
From: Pierre Ochsenbein @ 2019-01-12 14:57 UTC (permalink / raw)
To: Kaido Vaikla <Kaido.Vaikla@telia.ee>; +Cc: Prince Pathria <prince.pathria@goevive.com>; Shreeyansh Dba <shreeyansh2014@gmail.com>; pgsql-admin
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
pierreochsenbein@gmail.com
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Monitoring tool
@ 2019-01-12 16:19 Bharat Telange <bharattelange@gmail.com>
parent: Pierre Ochsenbein <pierreochsenbein@gmail.com>
0 siblings, 0 replies; 15+ messages in thread
From: Bharat Telange @ 2019-01-12 16:19 UTC (permalink / raw)
To: Pierre Ochsenbein <pierreochsenbein@gmail.com>; +Cc: Kaido Vaikla <Kaido.Vaikla@telia.ee>; Prince Pathria <prince.pathria@goevive.com>; Shreeyansh Dba <shreeyansh2014@gmail.com>; pgsql-admin
In opensource, nagios and zabbix are already referred in trail mail.
Similarly, pgwatch2 is also a good option.
https://github.com/cybertec-postgresql/pgwatch2
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
> pierreochsenbein@gmail.com
>
^ permalink raw reply [nested|flat] 15+ messages in thread
end of thread, other threads:[~2019-01-12 16:19 UTC | newest]
Thread overview: 15+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-14 09:50 Monitoring Tool Hutger Hauer <hutger@gmail.com>
2007-11-14 10:11 ` Cédric Villemain <cedric.villemain@dalibo.com>
2018-09-13 11:48 monitoring tool Pierre Ochsenbein <pierreochsenbein@gmail.com>
2018-09-13 12:43 ` Re: monitoring tool flatley <tflatley@gmail.com>
2019-01-11 15:53 Monitoring tool Pierre Ochsenbein <pierreochsenbein@gmail.com>
2019-01-11 16:04 ` Re: Monitoring tool Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:32 ` Re: [MASSMAIL]Re: Monitoring tool gilberto.castillo@etecsa.cu
2019-01-11 22:06 ` Re: Monitoring tool Prince Pathria <prince.pathria@goevive.com>
2019-01-11 22:23 ` RE: Monitoring tool Kaido Vaikla <Kaido.Vaikla@telia.ee>
2019-01-12 14:57 ` Re: Monitoring tool Pierre Ochsenbein <pierreochsenbein@gmail.com>
2019-01-12 16:19 ` Re: Monitoring tool Bharat Telange <bharattelange@gmail.com>
2019-01-12 00:14 ` Re: Monitoring tool Ramesh naik <ramesh.esl@gmail.com>
2019-01-12 05:26 ` Re: Monitoring tool Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 18:35 ` Re: Monitoring tool Ibrahim Edib Kokdemir <kokdemir@gmail.com>
2019-01-11 18:54 ` Re: Monitoring tool Ervin Weber <webervin@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