Re: rails with postgresql

Philip Hallstrom
2010-12-07T21:59:16Z

On Dec 7, 2010, at 1:49 PM, Rajinder Yadav wrote:

> Hi this is my first time for a few things. I am trying to get rails
> working with postgres-9.0.1, I have never used postgres before. I do
> know the server is listening on localhost:5432 as I am able to connect
> to it using pgadmin3 and see the 2 databases on it.
>
> I have ''pg'' gem installed
> my database.yml looks like this
>
> development:
>  adapter: postgresql
>  encoding: unicode
>  database: test
>  pool: 5
>  username:
>  password:
>
> however i am getting the following migrate error
>
> yadav@expression:$ rake db:migrate --trace
> (in /home/yadav/dev/rails/tmp/testapp)
> ** Invoke db:migrate (first_time)
> ** Invoke environment (first_time)
> ** Execute environment
> ** Execute db:migrate
> rake aborted!
> could not connect to server: No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.
> 5432"?

Is the server running locally and accepting connections on that unix domain
socket?  You don''t say that it is...

Or if you don''t want to tweak that, change your database.yml and add a
"host: localhost" entry.

-philip