Issue with postgres

Hi folks,

Maybe someone out there has seen this before…

I installed the postgres gem (with the extra lines to point it to my
postgres libraries); that seems fine.

But when I try to, for example, ‘rake migrate’, I see:
rake aborted!
No such file to load – postgres
/usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:in require__' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:inrequire’
/Users/asa/Sites/manager/config/…/vendor/rails/activerecord/lib/…/…/activesupport/lib/active_support/dependencies.rb:147:in
require' /Users/asa/Sites/manager/config/../vendor/rails/activerecord/lib/../../activesupport/lib/active_support/core_ext/kernel/requires.rb:7:inrequire_library_or_gem’
/Users/asa/Sites/manager/config/…/vendor/rails/activerecord/lib/…/…/activesupport/lib/active_support/core_ext/kernel/requires.rb:5:in
silence_warnings' /Users/asa/Sites/manager/config/../vendor/rails/activerecord/lib/../../activesupport/lib/active_support/core_ext/kernel/requires.rb:5:inrequire_library_or_gem’
/Users/asa/Sites/manager/config/…/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:7:in
`postgresql_connection’

(where I have included the first few lines of the trace)

I then tried (and succeeded) in manually installing the postgres
bindings. Same error.

What weird is that in irb I can
irb(main):002:0> require ‘postgres’
=> true

but I still can’t connect through rails.

I’m running a PowerBook with Mac OS X 10.4.7; ruby 1.8.4, rails 1.1.6.

Ideas?

Thanks,
Asa

What’s the value for “adapter” in database.yml?

If it’s “postgres”, try changing it to “postgresql”.

It’s postgresql. Looking at the trace, it’s clear that it’s following
the right path (through ‘postgresql_adapter.rb’).

Alder G. wrote:

What’s the value for “adapter” in database.yml?

If it’s “postgres”, try changing it to “postgresql”.

I’m having exactly the same issue. I’d prefer to be using the c
version, but I just can’t get it installed properly. I found a blog
entry that does into a bit more detail about the problem ->
http://happygiraffe.net/blog/archives/2006/07/19/ruby-postgres-gem-issues

I hope there is a solution to this issue.

Thanks,

Robert