Re: rails with postgresql

David Kahn
2010-12-07T22:31:25Z

On Tue, Dec 7, 2010 at 4:25 PM, Rajinder Yadav
<devguy.ca-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:

> 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.
>

Cool... hey if you have a chance let me know if you can connect to the db
using: "rails dbconsole".... I have never been successful doing this
and I
just go to the postgresql command line but would be curious if it works for
you.... I can connect no problem to the rails console, but for whatever
reason I get "Couldn''t find database client: psql. Check your
$PATH and try
again." when I try rails dbconsole.


>
> 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-/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.