To: pgsql-admin@lists.postgresql.org
From: S Bob <sbob@quadratum-braccas.com>
Subject: Odd config issue, cannot set log_min_duration_statement
Message-ID: <2a31bc9d-5c9b-b76e-083d-c4fb392f0834@quadratum-braccas.com>
Date: Thu, 14 Jan 2021 19:12:54 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.6.0
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------AA9CDC92603D169CE0B8552F"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------AA9CDC92603D169CE0B8552F
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

All;


I have a client running PostgreSQL v10


I set:

log_min_duration_statement = 0

and restarted the cluster but if I connect via psql and check it's still 
disabled


postgres=# show log_min_duration_statement ;
  log_min_duration_statement
----------------------------
  -1
(1 row)


I tried an alter system, now if I cat the auto.conf file i see:


$ cat postgresql.auto.conf
# Do not edit this file manually!
# It will be overwritten by the ALTER SYSTEM command.
log_min_duration_statement = '0'


However even after another restart It's still disabled:


postgres=# show log_min_duration_statement ;
  log_min_duration_statement
----------------------------
  -1
(1 row)


I grep'ed for the setting in the config file just in case:

$ grep log_min_duration_statement postgresql.conf
log_min_duration_statement = 0          # -1 is disabled, 0 logs all 
statements


I'm stumped... Thoughts?


Thanks in advance


--------------AA9CDC92603D169CE0B8552F
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>All;</p>
    <p><br>
    </p>
    <p>I have a client running PostgreSQL v10</p>
    <p><br>
    </p>
    <p>I set: <br>
    </p>
    <p>log_min_duration_statement = 0 <br>
    </p>
    <p>and restarted the cluster but if I connect via psql and check
      it's still disabled</p>
    <p><br>
    </p>
    <p><font color="#00008b">postgres=# show log_min_duration_statement
        ;<br>
         log_min_duration_statement <br>
        ----------------------------<br>
         -1<br>
        (1 row)</font><br>
    </p>
    <p><br>
    </p>
    <p>I tried an alter system, now if I cat the auto.conf file i see:</p>
    <p><br>
    </p>
    <p><font color="#00008b">$ cat postgresql.auto.conf<br>
        # Do not edit this file manually!<br>
        # It will be overwritten by the ALTER SYSTEM command.<br>
        log_min_duration_statement = '0'</font><br>
    </p>
    <p><br>
    </p>
    <p>However even after another restart It's still disabled:</p>
    <p><br>
    </p>
    <p><font color="#00008b">postgres=# show log_min_duration_statement
        ;<br>
         log_min_duration_statement <br>
        ----------------------------<br>
         -1<br>
        (1 row)</font></p>
    <p><br>
    </p>
    <p>I grep'ed for the setting in the config file just in case:</p>
    <p><font color="#00008b">$ grep log_min_duration_statement
        postgresql.conf<br>
        log_min_duration_statement = 0          # -1 is disabled, 0 logs
        all statements</font></p>
    <p><br>
    </p>
    <p>I'm stumped... Thoughts?</p>
    <p><br>
    </p>
    <p>Thanks in advance<br>
    </p>
    <p><br>
    </p>
    <p><br>
    </p>
  </body>
</html>

--------------AA9CDC92603D169CE0B8552F--