postgre sql 9.4.5不会启动

Question

我无法启动我的新安装postgre，即9.4.5。请参阅下面的错误。

root@0f51e9aa2afc:/actinbox# service postgresql *启动PostgreSQL 9.4数据库服务器 * PostgreSQL服务器启动失败。请检查日志输出: LOG:跳过缺少的配置文件"/var/lib/postgresql/9.4/main/postgresql.auto.conf“2015-12-02 07:14:48 UTC 312-2致命:无法访问私钥文件”/etc/ssl/私有/ssl-cert-snake.key“：权限被拒绝

我在守护进程上使用ubuntu14.04.3 LTS。有人能帮我吗？

Answer 1

试试看：

sudo chown postgres /etc/ssl/private/ssl-cert-snakeoil.key
sudo chown postgres /etc/ssl/certs/ssl-cert-snakeoil.pem  

如果它不起作用，试试以下几个：

(as root)
# go to PGDATA directory
cd /var/lib/postgresql/9.1/main 
ls -l server.crt server.key

# confirm both of those files are symbolic links
# to files in /etc/ssl before going further

# remove symlinks to SSL certs
rm server.crt
rm server.key 

# copy the SSL certs to the local directory
cp /etc/ssl/certs/ssl-cert-snakeoil.pem server.crt
cp /etc/ssl/private/ssl-cert-snakeoil.key server.key

# set permissions on ssl certs
# and postgres ownership on everything else
# just in case
chown postgres *
chmod 640 server.crt server.key

service postgresql start