Re: Odd config issue, cannot set log_min_duration_statement - Mailing list pgsql-admin

From Tom Lane
Subject Re: Odd config issue, cannot set log_min_duration_statement
Date
Msg-id 1623237.1610677900@sss.pgh.pa.us
Whole thread Raw
In response to Odd config issue, cannot set log_min_duration_statement  (S Bob <sbob@quadratum-braccas.com>)
Responses Re: Odd config issue, cannot set log_min_duration_statement
List pgsql-admin
S Bob <sbob@quadratum-braccas.com> writes:
> I set:
> log_min_duration_statement = 0
> and restarted the cluster but if I connect via psql and check it's still 
> disabled

If you just did "SET" then it'd only affect the current session.

> 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'

Hmm, that should have worked.  What do you see in

select * from pg_settings where name = 'log_min_duration_statement';

(the "source..." columns are important here)

            regards, tom lane



pgsql-admin by date:

Previous
From: S Bob
Date:
Subject: Odd config issue, cannot set log_min_duration_statement
Next
From: franklin ferreira de lima
Date:
Subject: Re: Odd config issue, cannot set log_min_duration_statement