Re: monitoring solutions

On Mon, Feb 29, 2016 at 4:01 PM, Kiriakos Georgiou <
kg(dot)postgresql(at)olympiakos(dot)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