Re: wal_level not changing

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(dot)k(dot)shukla(at)gmail(dot)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
>