CODEWITHSUNDEEP
ruby-on-railsruby-on-rails-3macospostgresqlosx-lion
Andre Cytryn
Andre Cytryn

Reputation: 2705

Postgres permission denied on MAC OS X

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.

Upvotes: 24

Views: 34306

Answers (6)

Zender
Zender

Reputation: 1

Just check if your config/database.yml has------host: localhost and port: (check for yourself by netstat -an | grep 5432 or 5433)

Upvotes: 0

Jared Beck
Jared Beck

Reputation: 17528

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

Upvotes: 58

Jillian Hoenig
Jillian Hoenig

Reputation: 247

I had the same issue. After unsuccessfully trying all the suggestions posted above, I finally quit out of terminal and restarted it.

This worked.

Upvotes: 0

duykhoa
duykhoa

Reputation: 2302

Oh, may be you are open postgre in another application, like pgadmin http://www.pgadmin.org/ Try to close any application that use postgre SQL and run your command again.

Upvotes: 2

Patrik Affentranger
Patrik Affentranger

Reputation: 13465

I ran into the same problem today and found this blog post below which helped me:

http://nextmarvel.net/blog/2011/09/brew-install-postgresql-on-os-x-lion/

It moves your OS X default postgres binaries into an archive folder and symlinks the homebrew versions in place of them.

TL;DR curl http://nextmarvel.net/blog/downloads/fixBrewLionPostgres.sh | sh

Upvotes: 0

Eric Norcross
Eric Norcross

Reputation: 4306

I also ran into this problem because I had both the mysql and pg gems active in my Gemfile.

I commented out the mysql gem:

# mysql

Then ran:

bundle install

and then: 

rake db:migrate

and it worked like a charm.

Upvotes: -2

Related Questions