Re: Is there any way that one of the Postgres Background/Utilityprocess may go down? - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Is there any way that one of the Postgres Background/Utilityprocess may go down?
Date
Msg-id b83773f407a652d06685fe8da087178aed05887b.camel@cybertec.at
Whole thread Raw
In response to Re: Is there any way that one of the Postgres Background/Utilityprocess may go down?  (rajan <vgmonnet@gmail.com>)
List pgsql-admin
rajan wrote:
> Ok. Let me explain my use case from where I am asking this question,
> 
> For configuring Postgres Monitoring using a tool,
> Is it enough if I just add the Postmaster process alone for Monitoring? or
> Should I add all background processes for Monitoring?

I'd have the monitoring tool establish a database connection regularly.
If that works, and you can run a simple SELECT, things look good.

Other than that, the best you can do is monitor the database log file
for nasty messages like PANIC.  Unfortunately there is no simple rule
to determine automatically which log entries are serious errors.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com



pgsql-admin by date:

Previous
From: Joe Conway
Date:
Subject: Re: plr (extension) error during make
Next
From: Natalie Wenz
Date:
Subject: Database migration across different operating systems