sequel trying to use postgresql instead of postgres as adapters

Question

Had a simple heroku app with sequel and postgres. However, I got:

% heroku rake db:migrate
rake aborted!
LoadError: no such file to load -- sequel/adapters/postgresql
/app/.bundle/gems/ruby/1.9.1/gems/sequel-3.23.0/lib/sequel/core.rb:249:in `require'

There is no postgresql.rb in the sequel-3.23.0/lib/sequel/adapters/ There is a postgres.rb on my local drive. I'm using the free plan.

% heroku info
...
Dynos:          1
Workers:        0
Repo size:      9M
Slug size:      8M
Stack:          bamboo-mri-1.9.2
Data size:      (empty)
Addons:         Basic Logging, Shared Database 5MB


% heroku pg:info
=== kampanchi database SHARED_DATABASE_URL

Is there a question in here? If you use the "wrong" name for postgresql, does it work? — Seth Robertson
– Seth Robertson, Commented May 24, 2011 at 22:03

Jeremy Evans · Accepted Answer · 2011-05-24 23:34:25Z

4

Sequel has always used "postgres" for the postgres adapter. If you have specified "postgresql" as the adapter scheme, then it shouldn't work. If you are using Rails, Heroku creates a database.yml file in ActiveRecord format (using "postgresql"), and I'm guessing that's what your rake task is picking up. If you are using a Rails/Sequel integration tool, I'm guessing it isn't handling that conversion for you, and it should be fixed. Personally, I'd manually set up the database connection using the DATABASE_URL environment variable that Heroku provides.

See http://devcenter.heroku.com/articles/database#database_urls for details.

answered May 24, 2011 at 23:34

Jeremy Evans

12.2k31 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

the Tin Man · Accepted Answer · 2012-11-26 20:10:52Z

0

Just to supplement Jeremy's response, Heroku has always used "postgres" in the DATABASE_URL. If you connect to ENV["DATABASE_URL"], it should work regardless of what your database is.

edited Nov 26, 2012 at 20:10

the Tin Man

161k44 gold badges222 silver badges308 bronze badges

answered May 25, 2011 at 2:26

Peter van Hardenberg

1354 bronze badges

Collectives™ on Stack Overflow

sequel trying to use postgresql instead of postgres as adapters

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related