Rails ActiveRecord Connecting to Wrong Postgres Database

Question

My database.yml is as follows:

development:
  adapter: postgresql
  database: phunt_development
  username: <%= ENV['PG_USER'] %>
  password: <%= ENV['PG_PASS'] %>
  host: localhost
  pool: 5
  timeout: 5000

And I can confirm that the database phunt_development does exist. However when I run ActiveRecord::Base.connection.current_database I get development not phunt_development. I can't figure out why Rails is insisting on connecting to the general development database, which is polluted with data I have from other local apps. I want to connect to phunt_development.

Have you restart your server/console after making changes in database.yml? — Salil
– Salil, Commented Jul 2, 2013 at 5:37

Sam Stern · Accepted Answer · 2013-07-03 04:18:23Z

3

Issue was a $DATABASE_URL variable was set in my environment. When this is set, it overrides the configuration in database.yml. Solution: run unset DATABASE_URL.

edited Jul 3, 2013 at 4:18

answered Jul 2, 2013 at 8:15

Sam Stern

25.2k13 gold badges98 silver badges130 bronze badges

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

Collectives™ on Stack Overflow

Rails ActiveRecord Connecting to Wrong Postgres Database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related