Postgres Pro
Downloads
Home   >   mailing lists

Re: monitoring solutions - Mailing list pgsql-admin

From Keith
Subject Re: monitoring solutions
Date
Msg-id CAHw75vuaPONe_9-QiaZb7GDG_pURMwJ=-6nts4QrqWkTX-SJ_g@mail.gmail.com
Whole thread Raw
In response to monitoring solutions  (Kiriakos Georgiou <kg.postgresql@olympiakos.com>)
List pgsql-admin
Tree view

On Mon, Feb 29, 2016 at 4:01 PM, Kiriakos Georgiou <kg.postgresql@olympiakos.com> wrote:
Hello,

I am reviewing the database monitoring solutions listed at https://wiki.postgresql.org/wiki/Monitoring for use with our aviation related project.
I’m interested in a slick dashboard that can quickly pinpoint potential issues.  So far nothing has jumped at me as an obvious choice.

One thing I should mention is that it can’t be a SaaS solution like https://www.vividcortex.com/monitoring/postgres/
It must be able to host the solution.

Do you have any suggestions? Something you have successfully used for a while.

thanks,
Kiriakos

I'd say the easiest, complete, self-hosted monitoring solution for postgres to get up and running would be Nagios (https://www.nagios.org/) + check_postgres (https://bucardo.org/wiki/Check_postgres). Even when I'm setting up other monitoring solutions, the list of things monitored by check_postgres is a great guideline to follow to make sure you've got the important stuff covered. Plus nagios provides you with other normal system monitoring things that are also important to database health (CPU, RAM, disk usage, etc).

Keith

pgsql-admin by date:

Previous
From: Kiriakos Georgiou
Date:
Subject: monitoring solutions
Next
From: Jean-Baptiste Vedel
Date:
Subject: To avoid a database shutdown, execute a database-wide VACUUM