Skip site navigation (1) Skip section navigation (2)

BUG #3589: /etc/init.d/postgresql reload doesn't reflect /etc/postgresql/postgresql.conf log_statement

From: "fuminori ido" <ido(at)netlab(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3589: /etc/init.d/postgresql reload doesn't reflect /etc/postgresql/postgresql.conf log_statement
Date: 2007-08-30 03:02:54
Message-ID: 200708300302.l7U32sP9005096@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3589
Logged by:          fuminori ido
Email address:      ido(at)netlab(dot)jp
PostgreSQL version: 7.4.7
Operating system:   GNU/Linux, Debian3.1
Description:        /etc/init.d/postgresql reload doesn't reflect
/etc/postgresql/postgresql.conf log_statement
Details: 

Dear,

When I operate the following steps from command-line, postgres still
generates SQL statement.  Is this bug or spec?:

1) At first, set log_statement=true in /etc/postgresql/postgresql.conf

2) do reload by /etc/init.d/postgresql reload
  I can see a lot of SQL in /var/log/postgresql/postgres.log.

3) Then, I commented-out the log_statement=true.  This means I thought
default setting(log_statement=false) would be effective.

4) do reload as the same; /etc/init.d/postgresql reload
  Still SQL is genrated as follows:

>  (lot of SQLs in the log)
>      :
> 2007-08-30 11:32:45 [3791] LOG:  received SIGHUP, reloading configuration
files
> 2007-08-30 11:32:47 [3833] LOG:  statement: start transaction;set
transaction isolation level serializable;select last_value from
"_mrs".sl_action_seq;
>      :
>  (still lot of SQLs in the log)

This is not what I expected.  At step 3) above, I think commented-out means
set to default value.  However, this behavior means, I guess, reload does
nothing when config statement is missing.  Maybe I need to write explicitly
"log_statement=false" even though it is default value in order to be
effective on reload?

I couldn't get answer by searching Google so I'm posting this unknown
behavior here.

Much appreciate for your answer!

Best Regards

Responses

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2007-08-30 07:57:27
Subject: Re: BUG #3589: /etc/init.d/postgresql reload doesn't reflect /etc/postgresql/postgresql.conf log_statement
Previous:From: Tom LaneDate: 2007-08-30 00:00:01
Subject: Re: BUG #3588: coalesce not working in join

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group