There is the following description in [17.1. Setting Parameters].
> The configuration file is reread whenever the postmaster process receives
> a SIGHUP signal
When I tried 'pg_ctl reload' with some lines commented out, I found that
the value for the commented-out parameter was staying unchanged,
rather than set to the default value.
"log_min_duration_statement" The default is set as -1 and commented out in postgresql.conf.
If I tried it to set 0 and 'reload', parameter will set to 0 at postmaster.
but I want changed to -1 at postmaster, tried it commented-out in postgresql.conf and reload,
it will still unchanged. it can chenge by 'restart'.
I think that it should supplement since it is easy to misunderstand this
at 'pg_ctl start' and 'pg_ctl reload', treatment of the line which commented out
at the time of reading postgresql.conf looks differ, cautions are required.
Therefore, I think that it should supplement.
I'd like to propose to add the following to the above "A second way to
set there configuration parameters":
When parameters in postgresql.conf are commented out and reloaded, those
values will not be changed to the default values and will stay at the
(Somebody of native English speakers check this text...)
okano katsuhiko _at_ oss ntt co jp
pgsql-docs by date
|Next:||From: Tom Lane||Date: 2006-09-15 17:20:26|
|Subject: Re: [HACKERS] New XML section for documentation |
|Previous:||From: James Cloos||Date: 2006-09-14 22:07:24|
|Subject: Re: plperl and triggers|