we are using uptima-kuma in a professional environment with good results.
You can monitor health of PG, disk space, ping etc.
As a docker container ist very easy to install and run,
best,
Anton
https://github.com/louislam/uptime-kuma
Am 12.09.2023 um 10:10 schrieb Olivier Gautherot <ogautherot@gautherot.net>:
Hi Rajesh,
El mar, 12 sept 2023 9:04, Rajesh Kumar <rajeshkumar.dba09@gmail.com> escribió: In postgres, is there a way to find out the list of dates of malfunctions of db or app for one year.
This is a very generic question. You may want to check apps like Nagios - there are many alternatives. As there are many reasons a database may fail (CPU load, memory, network, disk...), you will probably want a list of sensors.
Just keep in mind that these apps may also fail...