Re: Include.d and warnings - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Include.d and warnings
Date
Msg-id 558AEFFB.8050000@aklaver.com
Whole thread Raw
In response to Re: Include.d and warnings  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 06/24/2015 07:43 AM, Tom Lane wrote:
> Andomar <andomar@aule.net> writes:
>> We've set up an include directory in postgresql.conf:
>>       include_dir = 'conf.d'
>
>> The include directory has a file that changes the value of
>> "max_connections".
>
>> Now when we reload Postgres, an error appears in the logs:
>
>> -----
>> parameter ""max_connections"" cannot be changed without restarting the
>> server
>> ...
>> configuration file ""/var/lib/pgsql/9.4/data/postgresql.conf"" contains
>> errors; unaffected changes were applied
>> -----
>
>> But max_connections did not change before the reload.  It is just
>> overruled in an included configuration file.
>
> This is fixed in 9.4 and up.  Since it's just cosmetic, we did not
> back-patch the change.

So is the below the cosmetic part?:

"
configuration file ""/var/lib/pgsql/9.4/data/postgresql.conf"" contains
errors; unaffected changes were applied
"
Just for my edification. If an include file contains a different value
for a setting that can only be changed on restart, Postgres is supposed
to throw out the restart message?

>
>             regards, tom lane
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)
Next
From: "David G. Johnston"
Date:
Subject: Re: checking for NULLS in aggregate