From: | Kong Man <kong_mansatiansin(at)hotmail(dot)com> |
---|---|
To: | <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf |
Date: | 2012-12-26 22:56:54 |
Message-ID: | DUB116-W50024D8D1C9F4BF0913FA88B390@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
So, LifeKeeper default setting of LKPGSQLDEBUG=5 on
/etc/default/LifeKeeper was the culprit for this issue, probably by
starting postmaster with -d5 option.
Thank you for pointing us to the right direction.
-Kong
From: kong_mansatiansin(at)hotmail(dot)com
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
CC: pgsql-admin(at)postgresql(dot)org
Subject: RE: [ADMIN] log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf
Date: Sun, 23 Dec 2012 21:59:35 -0800
Hi Tom,
Thank you for some clue in this. So, I assume changing log_destination (from syslog to stderr) was a way around it to override log_min_messages when the -d option is specified?
I am checking with the vender, SIOS, on what scenarios LifeKeeper would start up PostgreSQL with the -d5 option.
Best regards,
-Kong
> From: tgl(at)sss(dot)pgh(dot)pa(dot)us
> To: kong_mansatiansin(at)hotmail(dot)com
> CC: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf
> Date: Sun, 23 Dec 2012 12:21:12 -0500
>
> Kong Man <kong_mansatiansin(at)hotmail(dot)com> writes:
> > We ran into a production issue during our maintenance window when I switched over LifeKeeper/PostgreSQL nodes from one to another. We noticed that the database was 1000 times slower than it usually is, then realized that the log_min_messages setting 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
From | Date | Subject | |
---|---|---|---|
Next Message | Burgholzer, Robert (DEQ) | 2012-12-27 16:49:03 | safe to clear pg_xlog archive status directory? |
Previous Message | Robert Treat | 2012-12-26 17:27:14 | Re: allow a user to see current_query in pg_stat_activity in 8.4 |