Re: Patterns to look for in the PostgreSQL server log

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Mageshwaran Janarthanam <mageshwaran(dot)janarthanam(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Patterns to look for in the PostgreSQL server log
Date: 2020-03-11 00:32:03
Message-ID: 0d5b9e61-8cd4-3c78-6586-e7278d558cf4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/10/20 9:57 AM, Mageshwaran Janarthanam wrote:
> Hi Team...I am trying to setup some monitoring over the PostgreSQL
> server log. I am not clear which error I should be most concerned about.
> Could you please share your thoughts on what pattern I should search in
> the log file?

That really depends on you. To get an idea of what the message levels
are being triggered for take a look at:

https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT

Table 19.1. Message Severity Levels

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-03-11 00:33:41 Re: How to discover what table is
Previous Message Peter J. Holzer 2020-03-10 23:21:17 Re: Real application clustering in postgres.