A special tool for PostgreSQL which checks its operability

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

A special tool for PostgreSQL which checks its operability

AYahorau
Hello PostgreSQL Community,

As far as I know there is a number of tools which collect some statistics concerning some PostgreSQL issues
(connections, disconnections, queries, the  most frequent events etc.). Some of them rely on Postgres Log or use other approaches.

I have a question.
Do you know is there such a tool or a set of some actions which can give a precise correct information whether db server is operable or not?
As I understand unfortunately not all the high-severity(FATAL or PANIC) messages in Postgres Log are really serious.



Best regards,
Andrei Yahorau
Reply | Threaded
Open this post in threaded view
|

Re: A special tool for PostgreSQL which checks its operability

bricklen

On Mon, Apr 22, 2019 at 11:47 PM <[hidden email]> wrote:
As far as I know there is a number of tools which collect some statistics concerning some PostgreSQL issues
(connections, disconnections, queries, the  most frequent events etc.). Some of them rely on Postgres Log or use other approaches.

I have a question.
Do you know is there such a tool or a set of some actions which can give a precise correct information whether db server is operable or not?
As I understand unfortunately not all the high-severity(FATAL or PANIC) messages in Postgres Log are really serious.

It depends on what "operable" means in your context. To answer the basic "is Postgres up and accepting connections?" question, have a look at pg_isready:
The only FATAL I can think of offhand that _may_ be ignorable (depending on your situation), is the FATAL thrown by too many connections. My opinion is that every FATAL, and certainly every PANIC, is grounds for immediate investigation.