BUG #12828: False positive "parameter shared_buffers cannot be changed" error

Поиск
Список
Период
Сортировка
От vindrg@gmail.com
Тема BUG #12828: False positive "parameter shared_buffers cannot be changed" error
Дата
Msg-id 20150304195028.2544.21499@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12828
Logged by:          Vincas Dargis
Email address:      vindrg@gmail.com
PostgreSQL version: 9.4.1
Operating system:   Debian Wheezy amd64
Description:

To reproduce:

Install postgresql-9.4 from pgdg repository.

Check (default) shared buffers size:
su - postgres -c "psql -c 'show shared_buffers' postgres"
 shared_buffers
----------------
 128MB
(1 row)

Edit /etc/postgresql/9.4/main/postgresql.conf to add line at the end of
file:
include = 'custom.postgresql.conf'

Create file /etc/postgresql/9.4/main/custom.postgresql.conf with single
line:
shared_buffers = 256MB

Now, restart:

service postgresql restart

And check if shared_buffers have changed (yes it is):
su - postgres -c "psql -c 'show shared_buffers' postgres"
 shared_buffers
----------------
 256MB
(1 row)

But now, we ask to reload configuration without doing any more config
changes:

service postgresql reload

Then in file /var/log/postgresql/postgresql-9.4-main.log these lines
appears:

2015-03-04 21:39:27 EET [5290-2] LOG:  received SIGHUP, reloading
configuration files
2015-03-04 21:39:27 EET [5290-3] LOG:  parameter "shared_buffers" cannot be
changed without restarting the server
2015-03-04 21:39:27 EET [5290-4] LOG:  configuration file
"/etc/postgresql/9.4/main/postgresql.conf" contains errors; unaffected
changes were applied

It warns that shared_buffers cannot be changed without restart, but there is
nothing to change, it's already 256MB as it where since the start of the
cluster!

So, "configuration file "X" contains errors" is a false positive.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Functional indexes with slow functions are misplanned
Следующее
От: Venkata Balaji N
Дата:
Сообщение: Re: [BUGS] Truncate cascade doesn´t work with BDR