Postgres Pro
Downloads
Home   >   mailing lists

Re: log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf - Mailing list pgsql-admin

From Tom Lane
Subject Re: log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf
Date
Msg-id 26470.1356283272@sss.pgh.pa.us
Whole thread Raw
In response to log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf  (Kong Man <kong_mansatiansin@hotmail.com>)
Responses Re: log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf
List pgsql-admin
Tree view 
Kong Man <kong_mansatiansin@hotmail.com> writes:
> We ran into a production issue during our maintenance window when I switched over LifeKeeper/PostgreSQL nodes from
oneto another.  We noticed that the database was 1000 times slower than it usually is, then realized that the
log_min_messagessetting was set to 'debug5' for no reason. 

How was the postmaster started?  From memory, "-d5" on its command line
would do that, and would not have been overridable from postgresql.conf.

            regards, tom lane

pgsql-admin by date:

Previous
From: Walter Hurry
Date:
Subject: Re: log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf
Next
From: Kong Man
Date:
Subject: Re: log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf