目录
环境
系统平台: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
更多解决方案请登录【瀚高技术支持平台】查看瀚高技术支持平台