wal_level not changing

From: Sumeet Shukla <sumeet(dot)k(dot)shukla(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: wal_level not changing
Date: 2017-09-04 15:42:42
Message-ID: CABUL1344egq5suaXz=epmRRc8M4Hd8LZ2RjxyV5PeHVv1CC3XA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vasilis Ventirozos 2017-09-04 15:50:56 Re: wal_level not changing
Previous Message SEKA Bruno-Emmanuel 2017-09-04 14:28:09 Re: New to postgreSQL