pgbadger is a very nice reporting tool, overall, albeit not exactly at the system side, but more to the DBA side.
For system level monitoring maybe take a look here :
https://wiki.postgresql.org/wiki/Monitoring#check_postgres .
Also you might want to write a script that parses logs for FATAL and PANIC and sends out emails.
On 24/07/2017 14:27, PAWAN SHARMA wrote:
Hi All,
Please provide me a list of tools which we can use for monitoring PostgreSQL.
-Monitor all the services and health of server
-Able to send critical and warning alert on mail.
OS: Redhat-7
PostgreSQL Version: 9.5.7
-Pawan
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
