Postgres permission denied on MAC OS X
macos, osx-lion, postgresql, ruby-on-rails, ruby-on-rails-3
Solution
Instead of troubleshooting your socket file permissions, you could try a TCP connection. Add `host: localhost` to your `config/database.yml`. Of course, this will only work if postgres is listening for TCP traffic. Postgres listens on port 5432 by default, so `netstat -an | grep 5432` will tell you if it is listening.
References
- PostgreSQL Documentation: 18.3. Connections and Authentication.
Problem
I was following the ruby on rails tutorial to run with postgres but when I try the "rake db:create" I get the following error: ``` 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"? ``` I have found this question issuing some similar problem but I couldnt make it work anyway. Repairing Postgresql after upgrading to OSX 10.7 Lion I have installed homebrew after reading this question and the path is fine, brew doctor shows me no errors on path.