pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedService outage list
6+ messages / 4 participants
[nested] [flat]
* Service outage list
@ 2023-09-12 07:04 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-12 08:10 ` Re: Service outage list Olivier Gautherot <ogautherot@gautherot.net>
2023-09-12 12:32 ` Re: Service outage list David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: Rajesh Kumar @ 2023-09-12 07:04 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
In postgres, is there a way to find out the list of dates of malfunctions
of db or app for one year.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Service outage list
2023-09-12 07:04 Service outage list Rajesh Kumar <rajeshkumar.dba09@gmail.com>
@ 2023-09-12 08:10 ` Olivier Gautherot <ogautherot@gautherot.net>
2023-09-12 08:30 ` Re: Service outage list Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
1 sibling, 1 reply; 6+ messages in thread
From: Olivier Gautherot @ 2023-09-12 08:10 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Service outage list
2023-09-12 07:04 Service outage list Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-12 08:10 ` Re: Service outage list Olivier Gautherot <ogautherot@gautherot.net>
@ 2023-09-12 08:30 ` Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
0 siblings, 0 replies; 6+ messages in thread
From: Dischner, Anton @ 2023-09-12 08:30 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Service outage list
2023-09-12 07:04 Service outage list Rajesh Kumar <rajeshkumar.dba09@gmail.com>
@ 2023-09-12 12:32 ` David G. Johnston <david.g.johnston@gmail.com>
2023-09-12 12:37 ` Re: Service outage list Rajesh Kumar <rajeshkumar.dba09@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: David G. Johnston @ 2023-09-12 12:32 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Tuesday, September 12, 2023, Rajesh Kumar <rajeshkumar.dba09@gmail.com>
wrote:
> In postgres, is there a way to find out the list of dates of malfunctions
> of db or app for one year.
>
It produces log entries continuously, including when starting and stopping.
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Service outage list
2023-09-12 07:04 Service outage list Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-12 12:32 ` Re: Service outage list David G. Johnston <david.g.johnston@gmail.com>
@ 2023-09-12 12:37 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-12 13:07 ` Re: Service outage list David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Rajesh Kumar @ 2023-09-12 12:37 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Seems like I have logs for only one week. How exactly to check in logs for
service outage details? Any keywords to find? How do I check service outage
details for past?
On Tue, 12 Sep, 2023, 6:02 PM David G. Johnston, <david.g.johnston@gmail.com>
wrote:
> On Tuesday, September 12, 2023, Rajesh Kumar <rajeshkumar.dba09@gmail.com>
> wrote:
>
>> In postgres, is there a way to find out the list of dates of malfunctions
>> of db or app for one year.
>>
>
> It produces log entries continuously, including when starting and stopping.
>
> David J.
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Service outage list
2023-09-12 07:04 Service outage list Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-12 12:32 ` Re: Service outage list David G. Johnston <david.g.johnston@gmail.com>
2023-09-12 12:37 ` Re: Service outage list Rajesh Kumar <rajeshkumar.dba09@gmail.com>
@ 2023-09-12 13:07 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: David G. Johnston @ 2023-09-12 13:07 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Tuesday, September 12, 2023, Rajesh Kumar <rajeshkumar.dba09@gmail.com>
wrote:
> Seems like I have logs for only one week. How exactly to check in logs for
> service outage details? Any keywords to find? How do I check service outage
> details for past?
>
Create an outage in development and see what the logs produce. If you
didn’t keep the log data out to a year ago you cannot learn what happened a
year ago. Not all outages are db related, it can be running but be
unreachable.
Please don’t top-post replies.
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-09-12 13:07 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-09-12 07:04 Service outage list Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-12 08:10 ` Olivier Gautherot <ogautherot@gautherot.net>
2023-09-12 08:30 ` Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
2023-09-12 12:32 ` David G. Johnston <david.g.johnston@gmail.com>
2023-09-12 12:37 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-12 13:07 ` David G. Johnston <david.g.johnston@gmail.com>
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