osx – 如何检查PostgreSQL服务器Mac OS X的状态

前端之家收集整理的这篇文章主要介绍了osx – 如何检查PostgreSQL服务器Mac OS X的状态前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
如何知道我的Postgresql服务器是否正在运行?

我收到此消息:

[~/dev/working/sw] sudo bundle exec rake db:migrate 
rake aborted!
could not connect to server: Connection refused
    Is the server running on host "localhost" and accepting
    TCP/IP connections on port 5432?

更新:

> which postgres
/usr/local/bin/postgres
> pg_ctl -D /usr/local/bin/postgres -l /usr/local/bin/postgres/server.log start
pg_ctl: could not open PID file "/usr/local/bin/postgres/postmaster.pid": Not a directory

更新2:

>pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
server starting
sh: /usr/local/var/postgres/server.log: No such file or directory
检查正在运行的进程的最简单的方法
ps auxwww | grep postgres

并查找看起来像这样的命令(您的版本可能不是8.3):

/Library/Postgresql/8.3/bin/postgres -D /Library/Postgresql/8.3/data

要启动服务器,请执行以下操作:

/Library/Postgresql/8.3/bin/pg_ctl start -D /Library/Postgresql/8.3/data -l postgres.log

猜你在找的Postgre SQL相关文章