wal_level not changing

[Sumeet Shukla <sumeet.k.shukla@xxxxxxxxx>]

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