首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >无法启动postgreSQL,附加了错误日志

无法启动postgreSQL,附加了错误日志
EN

Stack Overflow用户
提问于 2015-06-16 00:38:15
回答 1查看 251关注 0票数 0

无法启动postgreSQL服务,我今天通过运行以下命令执行了第一次安装:

代码语言:javascript
复制
sudo apt-get install postgresql postgresql-contrib

得到了以下输出:

代码语言:javascript
复制
Reading package lists... Done
Building dependency tree       
Reading state information... Done
postgresql is already the newest version.
postgresql-contrib is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 28 not upgraded.
4 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up postgresql-9.4 (9.4.2-0ubuntu0.14.10) ...
 * Starting PostgreSQL 9.4 database server                                       * The PostgreSQL server failed to start. Please check the log output:
2015-06-15 10:25:25 MDT [18101-1] FATAL:  private key file "/etc/ssl/private/ssl-cert-snakeoil.key" has group or world access
2015-06-15 10:25:25 MDT [18101-2] DETAIL:  File must be owned by the database user or root, must have no write permission for "group", and must have no permissions for "other".
                                                                         [fail]
invoke-rc.d: initscript postgresql, action "start" failed.
dpkg: error processing package postgresql-9.4 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of postgresql:
 postgresql depends on postgresql-9.4; however:
  Package postgresql-9.4 is not configured yet.

dpkg: error processing package postgresql (--configure):
 dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of postgresql-contrib-9.4:
 postgresql-contrib-9.4 depends on postgresql-9.4 (= 9.4.2-0ubuntu0.14.10); however:
  Package postgresql-9.4 is not configured yet.

dpkg: error processing package postgresql-contrib-9.4 (--configure):
 dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of postgresql-contrib:
 postgresql-contrib depends on postgresql-contrib-9.4; however:
  Package postgresql-contrib-9.4 is not configured yet.

dpkg: error processing package postgresql-contrib (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
                          No apport report written because the error message indicates its a followup error from a previous failure.
                                                    No apport report written because MaxReports is reached already
                                  Errors were encountered while processing:
 postgresql-9.4
 postgresql
 postgresql-contrib-9.4
 postgresql-contrib
E: Sub-process /usr/bin/dpkg returned an error code (1)

我试图手动更改文件上的设置,它告诉我这是导致错误的原因,以便它只有root访问权限,但没有用。有没有人有什么建议可以让它正常工作?

提前谢谢。

EN

回答 1

Stack Overflow用户

发布于 2015-06-16 00:53:05

用户Joop非常容易地回答了这个问题。我为此感谢他。这就是他的答案。

chown postgres /etc/ssl/private/ssl-cert-snakeoil.key;chmod640 /etc/ssl/private/ssl-cert-snakeoil.key (根据消息,所有者根也可以工作;而IMHO,文件模式400或440会更好。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/30850446

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档