On Mon, Feb 29, 2016 at 4:01 PM, Kiriakos Georgiou <kg.postgresql@xxxxxxxxxxxxxx> 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
