【PostgreSQL-9.6.3】LOG: unrecognized configuration parameter "dynamic_shared_memory_type"
来源:互联网 发布:pdf 编辑软件 免费 编辑:程序博客网 时间:2024/05/20 14:26
报错如下:
输入如下命令启动PG数据库时,报错:
[postgres@drz ~]$ pg_ctl -D /opt/postgresql/data/ startserver starting[postgres@drz ~]$ LOG: unrecognized configuration parameter "dynamic_shared_memory_type" in file "/opt/postgresql/data/postgresql.conf" line 127FATAL: configuration file "/opt/postgresql/data/postgresql.conf" contains errors
解决方式:
#给启动命令加上绝对路径,问题得到解决[postgres@drz ~]$ /opt/postgresql/bin/pg_ctl -D /opt/postgresql/data/ startserver starting[postgres@drz ~]$ LOG: database system was shut down at 2017-08-11 11:22:34 CSTLOG: MultiXact member wraparound protections are now enabledLOG: database system is ready to accept connectionsLOG: autovacuum launcher started#如果输入绝对路径启动时像我一样出现gmon.out文件权限问题[postgres@drz ~]$ /opt/postgresql/bin/pg_ctl -D /opt/postgresql/data/ start_mcleanup: gmon.out: Permission deniedserver starting_mcleanup: gmon.out: Permission denied[postgres@drz ~]$ LOG: database system was shut down at 2017-08-11 11:22:55 CSTLOG: MultiXact member wraparound protections are now enabledLOG: database system is ready to accept connectionsLOG: autovacuum launcher started #则要修改gmon.out文件的权限[postgres@drz ~]$ chmod 777 /home/postgres/gprof/27265/gmon.out#关闭数据库[postgres@drz ~]$ /opt/postgresql/bin/pg_ctl stop -D /opt/postgresql/data/#再次启动数据库[postgres@drz ~]$ /opt/postgresql/bin/pg_ctl -D /opt/postgresql/data/ startserver starting[postgres@drz ~]$ LOG: database system was shut down at 2017-08-11 11:30:30 CSTLOG: MultiXact member wraparound protections are now enabledLOG: database system is ready to accept connectionsLOG: autovacuum launcher started
The End!
2017-09-01
阅读全文
0 0
- 【PostgreSQL-9.6.3】LOG: unrecognized configuration parameter "dynamic_shared_memory_type"
- 【PostgreSQL-9.6.3】设置log参数
- postgresql db_user_namespace parameter
- postgresql server configuration
- SecureCRT log configuration
- Jboss log configuration file
- 异常信息:Unrecognized configuration section 'connectionStrings'
- Unrecognized configuration section system.web.extensions
- PostgreSQL View current log
- PostgreSQL log配置
- OCM_Session1_8_Schema Statistics and Parameter File Configuration
- JVM GC log file configuration
- web.config报 "Unrecognized configuration section dataConfiguration"错
- Unrecognized configuration section 'system.webServer' CKFinder - Setup Wizard for ASP
- 【PostgreSQL-9.6.3】约束
- 【PostgreSQL-9.6.3】分区表
- ubuntu u盘启动错位:missing parameter in configuration file
- 如何创建EPSG Geodetic Parameter Dataset for Postgresql 8
- 贪吃蛇无敌版 1.0
- JS数组和对象的一些原生方法(常用API)
- 谈谈射频电路设计及经验
- C# 动态调用com
- java项目生成可执行文件(exe)
- 【PostgreSQL-9.6.3】LOG: unrecognized configuration parameter "dynamic_shared_memory_type"
- 图解LSTM神经网络架构及其11种变体(附论文)
- 测试maven镜像是否可用
- HDU 6000 优先队列+快速IO
- 将wordpress admin bar中用户登出后跳转至登陆页面修改为登出前页面
- 1018:尼科彻斯定理
- scikit-learn Tutorials-KNN
- 【poj 2785】4 Values whose Sum is 0 【折半枚举】
- ajax常用参数