RE: Patterns to look for in the PostgreSQL server log

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