Search Postgresql Archives

Re: Include.d and warnings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 06/24/2015 07:43 AM, Tom Lane wrote:
Andomar <andomar@xxxxxxxx> 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@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux