Re: rails with postgresql

David Kahn
2010-12-07T21:59:53Z

On Tue, Dec 7, 2010 at 3:49 PM, Rajinder Yadav
<devguy.ca-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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"?
>

It might help if you can post your database.yml.... also, have you created
your databases (rake db:create:all)?


>
> --
> Kind Regards,
> Rajinder Yadav | DevMentor.org | Do Good! ~ Share Freely
>
> GNU/Linux: 2.6.35-22-generic
> Kubuntu x86_64 10.10 | KDE 4.5.1
> Ruby 1.9.2p0 | Rails 3.0.1
>
> --
> You received this message because you are subscribed to the Google Groups
> "Ruby on Rails: Talk" group.
> To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> To unsubscribe from this group, send email to
>
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org>
> .
> For more options, visit this group at
> http://groups.google.com/group/rubyonrails-talk?hl=en.