本文介绍了一种常见的PostgreSQL启动问题及其解决方案。当pg_hba.conf文件权限被意外更改导致PostgreSQL服务器无法读取该文件时，将出现启动错误。通过使用sudo chmod +r pg_hba.conf命令恢复文件权限，并执行sudo service postgresql start命令即可重启服务。
I am just posting this for anyone who is feeling lost and hopeless as I did when I found this question. It seems that sometimes by editing some psotgresql-related config files, one can accidentally change the permissions of the file:
Note how pg_hba.conf belongs to root, and users cannot even read it. This causes postgres to not be able to open this file and therefore not be able to start the server, throwing the error seen in the original question.
By running
sudo chmod +r pg_hba.conf
I was able to make this file once again accessible to the postgres user and then after running
sudo service postgresql start
Was able to get the server running again.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
