Re: [ADMIN] wal_level not changing
| От | Vasilis Ventirozos |
|---|---|
| Тема | Re: [ADMIN] wal_level not changing |
| Дата | |
| Msg-id | 44FA41F7-71F1-4B26-90BF-ACEF3B20A7A2@gmail.com обсуждение исходный текст |
| Ответ на | [ADMIN] wal_level not changing (Sumeet Shukla <sumeet.k.shukla@gmail.com>) |
| Ответы |
Re: [ADMIN] wal_level not changing
|
| Список | pgsql-admin |
try ALTER SYSTEM set wal_level = 'minimal';
and then restart , just make sure that archiving is disabled first.
Vasilis Ventirozos
On 4 Sep 2017, at 18:42, Sumeet Shukla <sumeet.k.shukla@gmail.com> wrote: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 по дате отправления: