Re: wal_level not changing

[Vasilis Ventirozos <v.ventirozos@xxxxxxxxx>]

try ALTER SYSTEM  set wal_level = 'minimal';

and then restart , just make sure that archiving is disabled first.

Vasilis Ventirozos

On 4 Sep 2017, at 18:42, Sumeet Shukla <sumeet.k.shukla@xxxxxxxxx> 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