linux – 连接psql时出现问题

前端之家收集整理的这篇文章主要介绍了linux – 连接psql时出现问题前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

我按照http://xadmin.info/?p=284中给出的说明安装了postgresql

@H_403_5@# pg_ctl -D /var/lib/pgsql/data -l pglog.log start server starting postgres@linux-p0pl:~> psql psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGsql.5432"?

我不知道为什么我在服务器启动时出现此错误…有人可以请帮助.

我的pglog.log文件显示以下输出

@H_403_5@2013-02-06 19:43:39 GMT FATAL: lock file "postmaster.pid" already exists 2013-02-06 19:43:39 GMT HINT: Is another postmaster (PID 23971) running in data directory "/var/lib/pgsql/data"? 2013-02-06 19:44:02 GMT FATAL: lock file "postmaster.pid" already exists 2013-02-06 19:44:02 GMT HINT: Is another postmaster (PID 23971) running in data directory "/var/lib/pgsql/data"? 2013-04-24 12:43:29 GMT FATAL: data directory "/var/lib/pgsql/data" has group or world access 2013-04-24 12:43:29 GMT DETAIL: Permissions should be u=rwx (0700). 2013-04-24 12:44:07 GMT FATAL: data directory "/var/lib/pgsql/data" has group or world access 2013-04-24 12:44:07 GMT DETAIL: Permissions should be u=rwx (0700). 2013-04-24 12:57:02 GMT FATAL: data directory "/var/lib/pgsql/data" has group or world access 2013-04-24 12:57:02 GMT DETAIL: Permissions should be u=rwx (0700). 2013-04-24 12:57:40 GMT FATAL: data directory "/var/lib/pgsql/data" has group or world access 2013-04-24 12:57:40 GMT DETAIL: Permissions should be u=rwx (0700).

ps -ef | grep postgres

@H_403_5@root 21659 21591 0 19:14 pts/0 00:00:00 grep --color=auto postgres
最佳答案
/ var / lib / pgsql / data的权限和所有权应为:

@H_403_5@# ll -d /var/lib/pgsql/data drwx------. 15 postgres postgres 4096 Apr 24 10:27 /var/lib/pgsql/data

如果他们不是root用户

@H_403_5@# chmod -R 700 /var/lib/pgsql/data # chown -R postgres /var/lib/pgsql/data

猜你在找的Linux相关文章