CODEWITHSUNDEEP
databaseruby-on-rails-3unixhomebrewpostgres.app
cpursley
cpursley

Reputation: 182

Postgres - could not connect to server after trying rake db:create:all

I'm trying to get Postgres up and running on OS X Lion - homebrew - rvm.

http://railscasts.com/episodes/342-migrating-to-postgresql

After following the above instructions, I ran into the same problem described here:

Repairing Postgresql after upgrading to OSX 10.7 Lion

Running which psql yieled usr/bin/psql when it should be usr/local/bin/psql

Ok, so I modified the path like this (this is all that is in the file):

export PATH="/usr/local/bin:$PATH"
[[ -s "/Users/chase/.rvm/scripts/rvm" ]] && source "/Users/chase/.rvm/scripts/rvm"

Good - running source ~/.bash_profile then which psql now yields usr/local/bin/psql

However, when I go generate a new rails app with -d postgresql as the database, it works up until I try rake db:create:all which results in 

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

Any clue?

UPDATE

I ended up installing the Postgres.app: http://postgresapp.com/ - this works.

Upvotes: 1

Views: 925

Answers (2)

HectorPerez
HectorPerez

Reputation: 774

http://postgresapp.com defines itself as "The easiest way to get started with PostgreSQL on the Mac. Just download, drag to the applications folder, and double-click". It worked perfectly for me.

Upvotes: 1

David Winiecki
David Winiecki

Reputation: 4203

For anyone reading this and using Postgres.app, you may need host: localhost in your database.yml. http://postgresapp.com/documentation#toc_3

Upvotes: 1

Related Questions