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

From Sumeet Shukla
Subject [ADMIN] wal_level not changing
Date
Msg-id CABUL1344egq5suaXz=epmRRc8M4Hd8LZ2RjxyV5PeHVv1CC3XA@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] wal_level not changing  (Vasilis Ventirozos <v.ventirozos@gmail.com>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: SEKA Bruno-Emmanuel
Date:
Subject: Re: [ADMIN] New to postgreSQL
Next
From: Vasilis Ventirozos
Date:
Subject: Re: [ADMIN] wal_level not changing