每当我使用命令启动PostgreSQL时:
$ sudo /etc/init.d/postgresql start
Pg无法启动。报告的错误为:
* Starting PostgreSQL 8.4 database server
* The PostgreSQL server failed to start. Please check the log output:
2010-01-21 22:10:00 PST FATAL: private key file "server.key" has group or world access
2010-01-21 22:10:00 PST 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".
... 当我尝试以 postgres
用户身份访问 psql
时,使用以下命令:
$ sudo su postgres
$ psql
它给我一个错误:
could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
server.key
是如何到达那里的,有什么改变。我相信@swair的回答是正确的,所以我主要是为了下一次解释。 - Craig Ringer