From: Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Service outage list
Date: Tue, 12 Sep 2023 08:30:25 +0000
Message-ID: <a94d9cbb6cc74cbca1fec9d7a3edeb7d@med.uni-muenchen.de> (raw)
In-Reply-To: <CAJ7S9TVUt07qJkTypJJwS22C9t2gv68eJ0mKLDwOAynJWty9LA@mail.gmail.com>
References: <CAJk5AtYXdH+4hF0eVWHBtx1GHifOAWDx5YwRHKwxeQ9wR-xpMA@mail.gmail.com>
<CAJ7S9TVUt07qJkTypJJwS22C9t2gv68eJ0mKLDwOAynJWty9LA@mail.gmail.com>
Hi Rajesh,
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...
Regards
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Anton.Dischner@med.uni-muenchen.de, pgsql-admin@lists.postgresql.org
Subject: Re: Service outage list
In-Reply-To: <a94d9cbb6cc74cbca1fec9d7a3edeb7d@med.uni-muenchen.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox