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
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 |