Re: rails with postgresql

Rajinder Yadav
2010-12-07T22:25:17Z

On Tue, Dec 7, 2010 at 4:59 PM, David Kahn
<dk-rfEMNHKVqOwNic7Bib+Ti1W1rNmOCjRP@public.gmane.org>
wrote:
>
>
> 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)?
>

Hi David,

thanks for the tip, I got it working, just had to add "host:
localhost" as Philip pointed out.

Kind Regards,
Rajinder Yadav

--
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@googlegroups.com.