If you feel stuck with the likes of Nagios and Munin, then Sensu might be for you. Sensu is a new open-source monitoring framework built with and for modern technology. Learn how it works and how you can use it to monitor your PostgreSQL installations.
(originally presented at PGConf NYC 2014, http://nyc.pgconf.us/2014/event/17/)