Unix 域套接字“/var/pgsql_socket/.s.PGSQL.5432"上的 PostgreSQL 权限被拒绝错误；- Lion Server 10.7.3 或 Lion Server 10.7.4 [英] PostgreSQL Permission denied Error on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432" - Lion Server 10.7.3 or Lion Server 10.7.4

问题描述

我最近在使用 Lion Server 时遇到了严重的权限问题，其中文件夹的权限会随意更改.在此期间，我在尝试执行 rake db:migrate 命令时开始收到以下错误:

I recently had major permission problems using Lion Server where permissions would change on folders at will. During this time I had started getting the following error when trying to do a rake db:migrate command:

rake aborted!
could not connect to server: Permission denied
  Is the server running locally and accepting
  connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

当我第一次在运行 10.7.2 时创建 Rails 3.2.3 应用程序时，这一直有效.突然间我开始出现这个错误.我阅读了许多有关此错误的博客，并尝试将其删除，但没有成功.

This had been working before when I first created a Rails 3.2.3 application while running 10.7.2. All of a sudden I started having this error come up. I read many blogs about this error and tried to remove it but with no success.

我决定致电 Apple Enterprise Support，看看我能做些什么.我怀疑 Lion Server 已损坏，但想在将我的服务器擦干净并重新开始之前与支持团队确认.他们确认这是我需要做的，以便理顺它.我在周五做了这个，只安装了重建我的 Rails 应用程序所需的东西.我仍然收到错误.我再次尝试了其他一些已发布的解决方案，但仍然没有一个有效.我们继续寻找解决方案.

I decided to call Apple Enterprise Support to see what I could do. I suspected that Lion Server had gotten corrupted but wanted to confirm with the support team before wiping my server clean and starting over. They confirmed that is what I needed to do in order to straighten it out. I did this on Friday and only installed what I needed to rebuild my Rails app. I still got the error. I tried again some of the other solutions that were posted but still none of them worked. We continued to look for solutions.

推荐答案

which psql 最有可能显示/bin/psql我猜我们想调用/usr/local/bin/psql

which psql will most likely show /bin/psql I'm guessing we want to call /usr/local/bin/psql

因此，要么我们将 $PATH 更改为在/bin 之前包含/local/bin，我认为这不是一个很好的解决方案(安全性等)，要么我们通过 rm-ing(或 mv-ing)文件(并符号链接到/usr/local/bin)来删除/usr/bin/psql或卸载 psql 客户端.

So either we change the $PATH to include /local/bin prior to /bin, which I don't think is a very good solution (security and such), or We remove /usr/bin/psql by either rm-ing (or mv-ing) the file, (and symlinking to /usr/local/bin) or uninstalling the psql client.

这篇关于Unix 域套接字“/var/pgsql_socket/.s.PGSQL.5432"上的 PostgreSQL 权限被拒绝错误；- Lion Server 10.7.3 或 Lion Server 10.7.4的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！