日志报错：contains errors； unaffected changes were applied

目录

环境

症状

问题原因

解决方案

环境

系统平台：N/A

版本：4.7.5

症状

LOG:  F0000: configuration file "/xxx/data/postgresql.auto.conf" contains errors; unaffected changes were applied

问题原因

部分数据库参数的修改需要重启生效，如果修改完这部分参数后未重启数据库，只是使用命令pg_ctl reload 或者函数select pg_reload_conf()重新装载数据库，那么日志文件中就会出下面的报错。

LOG:  00000: parameter "checkpoint_completion_target" changed to "0.8" LOG:  00000: parameter "log_destination" changed to "csvlog" LOG:  55P02: parameter "logging_collector" cannot be changed without restarting the server LOG:  00000: parameter "log_directory" changed to "../hgdb_log" LOG:  00000: parameter "log_filename" changed to "highgodb-%a.log" LOG:  00000: parameter "log_rotation_size" changed to "0" LOG:  00000: parameter "log_truncate_on_rotation" changed to "on" LOG:  00000: parameter "log_statement" changed to "ddl" LOG:  55P02: parameter "archive_mode" cannot be changed without restarting the server LOG:  55P02: parameter "wal_level" cannot be changed without restarting the server LOG:  00000: parameter "log_connections" changed to "on" LOG:  00000: parameter "log_disconnections" changed to "on" LOG:  00000: parameter "checkpoint_timeout" changed to "30 min" LOG:  F0000: configuration file "/xxx/data/postgresql.auto.conf" contains errors; unaffected changes were applied LOG:  00000: Note:new license has been applied, it is a official license.

解决方案

重启数据库完成数据库参数的修改。

pg_ctl restart -m f

更多解决方案请登录【瀚高技术支持平台】查看瀚高技术支持平台