OS X Yosemite升级后，自制软件将无法启动Postgresql服务器 [英] Postgresql server will not start after OS X Yosemite upgrade, homebrew

问题描述

重新创建错误的步骤：

• brew卸载postgresql


• 酿造梅子


• 酿造postgresql


• 运行postgresql启动命令


• psql

• brew uninstall postgresql
• brew prune
• brew install postgresql
• run postgresql start commands
• 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"?

我尝试的建议修复方法不起作用：

创建缺少的符号链接：

• sudo mkdir / var / pgsql_socket /


• sudo ln -s /private/tmp/.s.PGSQL.5432 / var / pgsql_socket /

• sudo mkdir /var/pgsql_socket/
• sudo ln -s /private/tmp/.s.PGSQL.5432 /var/pgsql_socket/

删除postmaster.pid文件（与上面的链接相同）：

remove postmaster.pid file (same link as above):

• rm /usr/local/var/postgres/postmaster.pid

• rm /usr/local/var/postgres/postmaster.pid

通过升级创建可能清理的目录：

• mkdir -p / usr / local / var / postgres / {pg_tblspc，pg_twophase，pg_stat_tmp} /
touch / usr / local / var / postgres / {pg_tblspc，pg_twophase，pg_stat_tmp} /。keep

• mkdir -p /usr/local/var/postgres/{pg_tblspc,pg_twophase,pg_stat_tmp}/ touch /usr/local/var/postgres/{pg_tblspc,pg_twophase,pg_stat_tmp}/.keep

相关的GitHub问题

编辑1：

本文正确推测正在使用多种版本的postgres，并且必须指定以下 pg_ctl 。奇怪的是，在 / usr / local / var 中有两个目录： postgre & postgres 。如果有人知道要更新哪些设置以直接使用正确的 pg_ctl 命令，我将不胜感激！

This article correctly speculates that there are multiple versions of postgres in use, and which pg_ctl must be specified (below). Strangely, there are two directories in /usr/local/var: postgre & postgres. If anybody knows which settings to update to use the proper pg_ctl command directly, I would appreciate it!

/usr/local/Cellar/postgresql/9.3.5_1/bin/pg_ctl -D / usr / local / var / postgre start

推荐答案

我遇到了同样的问题，在查看日志文件后，我发现一个目录丢失了：

I ran into the same issue and after looking at the log file I found one directory was missing:

$ tail /usr/local/var/postgres/server.log
FATAL:  could not open directory "pg_tblspc": No such file or directory

然后我做了 $ mkdir / usr / local / var / postgres / pg_tblspc ，重新启动了PostgreSQL并得到：

Then I did $ mkdir /usr/local/var/postgres/pg_tblspc, restarted PostgreSQL and got:

$ tail /usr/local/var/postgres/server.log
FATAL:  could not open directory "pg_replslot": No such file or directory

重做该过程后，我可能会重新创建以下目录，然后成功启动PostgreSQL：

After redoing the process may times I eneded up creating the following directories and then successfully started PostgreSQL:

/usr/local/var/postgres/pg_tblspc
/usr/local/var/postgres/pg_replslot
/usr/local/var/postgres/pg_twophase
/usr/local/var/postgres/pg_logical
/usr/local/var/postgres/pg_logical/mappings

我希望这会有所帮助。

这篇关于OS X Yosemite升级后，自制软件将无法启动Postgresql服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！