| From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | Ben Chobot <bench(at)silentmedia(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: changing log_min_duration_statement |
| Date: | 2010-01-19 21:44:50 |
| Message-ID: | 1263937490.3166.140.camel@hp-laptop2.gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2010-01-19 at 13:27 -0800, Ben Chobot wrote:
>
> I'm having difficulties with one of my 8.1.19 installs.
> log_min_duration_statement is currently set to 500. I would like to
> change it to 0. Changing it in the config file and sending a HUP to
> the postmaster has no effect.
What do you get after reloading server and running
psql -c "SHOW log_min_duration_statement"
Maybe there are more than one log_min_duration_statement in
postgresql.conf?
Also, a distro (Gentoo) has 2 conf files which overrides some settings
in postgresql.conf -- you may suffer from something similar.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Colson | 2010-01-19 21:49:17 | Re: ISO guidelines/strategies to guard injection attacks |
| Previous Message | Andy Colson | 2010-01-19 21:39:54 | Re: ISO guidelines/strategies to guard injection attacks |