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).