Recently I have migrated old Veeam to a new Virtual machine. The new Virtual Machine: Windows Server 2022, Veeam 12.3, PostgreSQL 15 which is running on the same VM.
Currently I am monitoring some services (CPU, Memory, Disks.. etc..) with NSClient++. I am looking for a solution to monitor the PostgreSQL server with nagios. Has someone successfully achieved the above and what plugins/clients/solutions have you used?
To monitor postreSQL process you can use NSClient++ and config for process monitoring as usual. For more information how to config it you can check this PDF.
For monitoring connections you can install posgresql client on the server and create simple script with one select to check the connections:
SELECT * FROM pg_stat_activity; For more info please check this excellent Q/A about the subject.
Of course some filtering may be required to satisfy your view.
