Postgres修改logging_collector参数后reload报错的迷惑
来源:互联网 发布:珍嗖啦淘宝上是真的吗 编辑:程序博客网 时间:2024/06/12 21:37
highgo=# select version();
version
------------------------------------
HighGo Database 3.0.2 Linux 64-bit
(1 row)
highgo=# select kernel_version();
kernel_version
----------------------------------------------------------------------------------------------------------------
PostgreSQL 9.4.10 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-11), 64-bit
(1 row)
highgo=# show logging_collector ;
logging_collector
-------------------
off
(1 row)
highgo=# alter system set logging_collector='on';
ALTER SYSTEM
highgo=# \q
[highgo@sourcedb data]$ pg_ctl reload
日志: 接收到 SIGHUP, 重载配置文件
日志: 在没有启动服务器的情况下,不能改变参数 "logging_collector"
日志: 配置文件 "/hgdata/highgo/HighGoDB/data/postgresql.auto.conf" 有错; 使用了不受影响的内容变动
server signaled
[highgo@sourcedb data]$ cat postgresql.auto.conf
# Do not edit this file manually!
# It will be overwritten by ALTER SYSTEM command.
password_encryption = 'on'
logging_collector = 'on'
[highgo@sourcedb ~]$ ps -ef |grep postgres
highgo 2838 1 0 14:17 pts/0 00:00:00 /hgdata/highgo/HighGoDB/bin/postgres
highgo 2840 2838 0 14:17 ? 00:00:00 postgres: checkpointer process
highgo 2841 2838 0 14:17 ? 00:00:00 postgres: writer process
highgo 2842 2838 0 14:17 ? 00:00:00 postgres: wal writer process
highgo 2843 2838 0 14:17 ? 00:00:00 postgres: autovacuum launcher process
highgo 2844 2838 0 14:17 ? 00:00:00 postgres: stats collector process
highgo 2872 2838 0 14:20 ? 00:00:00 postgres: highgo highgo [local] idle
highgo 2878 2222 0 14:21 pts/1 00:00:00 grep postgres
需要重启数据库服务才能生效。
[highgo@sourcedb data]$ pg_ctl stop
日志: 接到到智能 (smart) 停止请求
日志: 正在关闭autovacuum启动进程
日志: 正在关闭
waiting for server to shut down....日志: 数据库系统已关闭
done
server stopped
[highgo@sourcedb data]$
[highgo@sourcedb data]$ pg_ctl start
server starting
[highgo@sourcedb data]$ 日志: 日志输出重定向到日志收集进程
提示: 后续的日志输出将出现在目录 "pg_log"中.
[highgo@sourcedb data]$ psql
psql (3.0.2)
Type "help" for help.
highgo=# show logging_collector;
logging_collector
-------------------
on
(1 row)
version
------------------------------------
HighGo Database 3.0.2 Linux 64-bit
(1 row)
highgo=# select kernel_version();
kernel_version
----------------------------------------------------------------------------------------------------------------
PostgreSQL 9.4.10 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-11), 64-bit
(1 row)
highgo=# show logging_collector ;
logging_collector
-------------------
off
(1 row)
highgo=# alter system set logging_collector='on';
ALTER SYSTEM
highgo=# \q
[highgo@sourcedb data]$ pg_ctl reload
日志: 接收到 SIGHUP, 重载配置文件
日志: 在没有启动服务器的情况下,不能改变参数 "logging_collector"
日志: 配置文件 "/hgdata/highgo/HighGoDB/data/postgresql.auto.conf" 有错; 使用了不受影响的内容变动
server signaled
[highgo@sourcedb data]$ cat postgresql.auto.conf
# Do not edit this file manually!
# It will be overwritten by ALTER SYSTEM command.
password_encryption = 'on'
logging_collector = 'on'
[highgo@sourcedb ~]$ ps -ef |grep postgres
highgo 2838 1 0 14:17 pts/0 00:00:00 /hgdata/highgo/HighGoDB/bin/postgres
highgo 2840 2838 0 14:17 ? 00:00:00 postgres: checkpointer process
highgo 2841 2838 0 14:17 ? 00:00:00 postgres: writer process
highgo 2842 2838 0 14:17 ? 00:00:00 postgres: wal writer process
highgo 2843 2838 0 14:17 ? 00:00:00 postgres: autovacuum launcher process
highgo 2844 2838 0 14:17 ? 00:00:00 postgres: stats collector process
highgo 2872 2838 0 14:20 ? 00:00:00 postgres: highgo highgo [local] idle
highgo 2878 2222 0 14:21 pts/1 00:00:00 grep postgres
需要重启数据库服务才能生效。
[highgo@sourcedb data]$ pg_ctl stop
日志: 接到到智能 (smart) 停止请求
日志: 正在关闭autovacuum启动进程
日志: 正在关闭
waiting for server to shut down....日志: 数据库系统已关闭
done
server stopped
[highgo@sourcedb data]$
[highgo@sourcedb data]$ pg_ctl start
server starting
[highgo@sourcedb data]$ 日志: 日志输出重定向到日志收集进程
提示: 后续的日志输出将出现在目录 "pg_log"中.
[highgo@sourcedb data]$ psql
psql (3.0.2)
Type "help" for help.
highgo=# show logging_collector;
logging_collector
-------------------
on
(1 row)
阅读全文
0 0
- Postgres修改logging_collector参数后reload报错的迷惑
- nginx 修改配置文件后reload
- nginx修改nginx.conf文件后reload出现的错误
- nginx reload报错
- postgresql中参数logging_collector对数据库系统启动日志和操作日志信息目的地的影响
- nginx修改配置后reload原理初探
- nginx修改配置后reload原理初探
- postgres数据库启动报错
- postgres程序连接报错
- Postgres修改数据库的owner
- window.opener.location.reload() and href()的区别 弹出页修改后刷新父窗体
- window.opener.location.reload() and href()的区别 弹出页修改后刷新父窗体 .
- window.opener.location.reload() and href()的区别 弹出页修改后刷新父窗体
- Storm0.9.3启动后关于参数问题的报错
- JAVA中参数传递的迷惑点
- Ubuntu下reload apache报错解决
- vagrant reload命令报错:UndefinedConversionError
- 执行nginx -s reload报错
- 201612-4 压缩编码 ccf
- Solr之自动聚类。
- 扫荡倾斜摄影单体化难题
- 8
- struts2重点、精华、用法总结(六):数据处理机制之值栈
- Postgres修改logging_collector参数后reload报错的迷惑
- ROS中发布点云信息和里程计消息
- Android 4.4 SystemUI 的面板quicksettings删除
- 解决 Manifest.permission 中 permission无法解析的问题
- Median of Two Sorted Arrays
- 第三方控件
- linux下竞态分析和避免
- git常用命令,git实用命令,linux的git命令,-----2
- Android Studio 报onFatalError, processing error from engine(4)错误