There are various PostgreSQL plugins available for collecting the DB stats via Nagios. Like check_postgres, check_pgactivity etc. that you can configure as per your requirements or you can also create your own script for monitoring.
On Sat, Jan 12, 2019 at 3:37 AM Prince Pathria <prince.pathria@xxxxxxxxxxx> wrote:
On what stats should we actually keep a track on?On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba <shreeyansh2014@xxxxxxxxx wrote:Yes, Nagios is the best DB monitoring/alerting tool and its free opensource.On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbein@xxxxxxxxx> wrote:Hey guys,What is for you the best Monitoring/altering for PostgreSQL? Nagios?Thx