Обсуждение: Patterns to look for in the PostgreSQL server log

Поиск
Список
Период
Сортировка

Patterns to look for in the PostgreSQL server log

От
Mageshwaran Janarthanam
Дата:
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?

Re: Patterns to look for in the PostgreSQL server log

От
Adrian Klaver
Дата:
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.klaver@aklaver.com

RE: Patterns to look for in the PostgreSQL server log

От
Kevin Brannen
Дата:

>From: Mageshwaran Janarthanam <mageshwaran.janarthanam@gmail.com>

> 

>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?

 

I'd treat it like any other log and apply negative filters; i.e. filter out

things that aren't a problem, which leaves things you do care about and

anything unexpected (which might cause you to add another filter to remove

it for next time if you find it's not really a problem).

 

Adrian is giving good advice too. Understand the log levels and set your configappropriately for your situation and comfort level.

This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.