Re: logging settings

On Thu, Feb 02, 2006 at 06:19:53PM -0500, Mott Leroy wrote:
> On Postgres 7.4.1

That's pretty old. If you can't upgrade to 8.0 or 8.1 then at least
consider staying up to date with bug fixes by using the latest
version in the 7.4 branch (currently 7.4.11).

> I've been experiencing some strangeness with the logging settings in
> postgresql.conf.
>
> I turned on statement logging (and duration), issued a "pg_ctl reload"
> and got it working (logging to sys log and standard out). Now however,
> when i try to turn it off, it won't turn off, using the same procedure.
> I've now commented out all the lines related to logging, but it's still
> logging.

Did you change the settings to off and leave them uncommented or
did you simply comment them out? Commenting out the lines will
leave the settings at their previous values until you restart the
server; if you want to change settings with a reload (not a restart)
then change the values and leave them uncommented. Once you've
actively changed the settings back to their defaults then you could
comment them out.

> Is it possible that this is related to connection pooling? Does each
> connection hold these settings, such that a reload of the configuration
> file only affects new connections, not existing ones?

I just did some tests in 7.4.11 and settings like log_statement and
log_min_duration_statement changed within a session as I reloaded
the server, so I don't think connection pooling would matter (at
least not for those settings). I think the more likely problem is
that you commented out the settings instead of actually changing
them.

--
Michael Fuhr