Re: [ADMIN] wal_level not changing - Mailing list pgsql-admin

On 4 Sep 2017, at 18:42, Sumeet Shukla <sumeet.k.shukla@gmail.com> wrote:

Hi,

update pg_settings set reset_val='minimal' where name='wal_level';

ERROR:  parameter "wal_level" cannot be changed without restarting the server

 

set wal_level='minimal';

ERROR:  parameter "wal_level" cannot be changed without restarting the server

update pg_settings set setting='minimal' where name='wal_level';

ERROR:  parameter "wal_level" cannot be changed without restarting the server

Even after restarting and reloading the server multiple times the setting does not update and remains as below:

show wal_level;

+-----------+

| wal_level |

+-----------+

| replica   |

+-----------+

Thanks & Regards,

Sumeet Shukla