Rails database migration failing because of Postgres inet type

Question

I have a Rails(4.1.0) app that works fine on Heroku. However, on my local machine, rake db:migrate fails due to a table for devise that uses inet datatype and I am using sqlite3 for testing.

I have included the postgres gem as well as postgres_ext but still coming up with the error:

undefined method `inet' for #<ActiveRecord::ConnectionAdapters::Table:0x00000005fae9e8>/home/app/db/migrate/20141107192501_add_devise_to_users.rb:19:in `block in up'

Trackable, when it tries to create the table columns for current_sign_in_ip and last_sign_in_ip. Both of which are type inet. — adanot
– adanot, Commented Nov 12, 2014 at 2:58
It is, and I have postgres 9.3 installed. I added pg gem for dev environment but still getting the same issue. I feel there's something here I'm missing entirely. — adanot
– adanot, Commented Nov 12, 2014 at 3:09

max · Accepted Answer · 2016-02-22 10:57:17Z

2

If testing locally using Postgres is acceptable just setup the correct adapters. A sample database.yml:

common: &common
  adapter: postgresql
  encoding: utf8
  template: template0 # Required for UTF8 encoding
  username: <%= ENV["POSTGRES_USER"] %>
  password: <%= ENV["POSTGRES_PASSWORD"] %>
  host: <%= ENV["POSTGRES_HOST"] %>

development:
  <<: *common
  database: 'my_app_dev'

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  <<: *common
  database: 'my_app_test'

edited Feb 22, 2016 at 10:57

answered Nov 12, 2014 at 3:41

max

103k15 gold badges113 silver badges177 bronze badges

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

Collectives™ on Stack Overflow

Rails database migration failing because of Postgres inet type

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related