systemctl status postgresql-9.6
● postgresql-9.6.service - PostgreSQL 9.6 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-9.6.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2017-09-04 11:25:42 EDT; 27min ago
Process: 28093 ExecStop=/opt/postgresql/9.6/bin/pg_ctl stop -m fast -w -D /data/9.6/data (code=exited, status=1/FAILURE)
Process: 28052 ExecStart=/opt/postgresql/9.6/bin/pg_ctl start -w -t ${TimeoutSec} -D /data/9.6/data -l /data/9.6/data/pg_log/startup.log (code=exited, status=0/SUCCESS)
Main PID: 28054 (code=exited, status=0/SUCCESS)
Sep 04 11:25:36 ashprmlpdb-p05 systemd[1]: Starting PostgreSQL 9.6 database server...
Sep 04 11:25:36 ashprmlpdb-p05 systemd[1]: Started PostgreSQL 9.6 database server.
Sep 04 11:25:42 ashprmlpdb-p05 systemd[1]: postgresql-9.6.service: control process exited, code=exited status=1
Sep 04 11:25:42 ashprmlpdb-p05 systemd[1]: Unit postgresql-9.6.service entered failed state.
Sep 04 11:25:42 ashprmlpdb-p05 systemd[1]: postgresql-9.6.service failed.
try ALTER SYSTEM set wal_level = 'minimal';and then restart , just make sure that archiving is disabled first.Vasilis VentirozosOn 4 Sep 2017, at 18:42, Sumeet Shukla <sumeet.k.shukla@xxxxxxxxx> 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
