try ALTER SYSTEM set wal_level = 'minimal';
and then restart , just make sure that archiving is disabled first.
Vasilis Ventirozos
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