Postgres.app无法在端口5432上启动 [英] Postgres.app Could not start on port 5432

问题描述

我正在使用 http://postgresapp.com 。在菜单栏中，它显示错误无法在端口5432上启动。同样，如果尝试从终端启动服务器，则会得到：

I'm using http://postgresapp.com. In the menubar it gives the error " Could not start on port 5432." Similarly if I try to start the server from the terminal, I get:

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"?

我还运行了 pg_ctl -D / usr / local / var / postgres- l /usr/local/var/postgres/server.log start
并得到输出 server startup ，但仍然出现相同的错误

I also ran pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start and got the output server starting but still get the same errors when connecting to psql.

推荐答案

您有另一个postgres实例正在运行，这是对此端口感兴趣的唯一应用程序。您应该使用netstat和ps来确定这一点。然后停止实例并卸载它，例如，您可能已经安装了enterpiseDb。

You my have another instance of postgres running, that is the only application interested in this port. You should use netstat and ps to determine this. Then stop the instance and uninstall it, you mayhave installed enterpiseDb for example, that is what I did.

这篇关于Postgres.app无法在端口5432上启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！