| 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: | Whole Thread | Raw Message | 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
| 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 |