How to create new database on heroku server with postgres

Question

I want to create a PostgreSQL database on a Heroku server.

My database.yml is

production:
  adapter: postgresql

  encoding: utf8

  database: ddb
  username: postgres

  port: 5432
  password: admin

  host: localhost

When I run heroku rake db:create it gives me the error:

mydatabase already exists
    (in /disk1/home/slugs/181380_8d7032f_f439-4fe4f5a6-f181-4150-a968-fadcf45f0af5/mnt)

I have tried it for various different database names, but get the same message.

How can I resolve this error?

A wild guess: the config file you cited is not the config file Heroku sees. Look for a similar file with a "database: mydatabase" in it. — Milen A. Radev
– Milen A. Radev, Commented Nov 8, 2010 at 15:22

Nathan Lilienthal · Accepted Answer · 2013-02-07 21:42:41Z

15

heroku autogenerates database.yml on the deploy. Reads like: it doesn't matter what you put in your database.yml, which to me is nice, as I can include it in git without worrying about production db passwords.

You may choose another database by setting the ENV['DATABASE_URL'] (use heroku config:add DATABASE_URL=....)

Check heroku documentation https://devcenter.heroku.com/articles/ruby-support#build-behavior

edited Feb 7, 2013 at 21:42

Nathan Lilienthal

8741 gold badge10 silver badges16 bronze badges

answered Nov 12, 2010 at 8:51

oma

41.6k12 gold badges73 silver badges101 bronze badges

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

1 Comment

freemanoid Over a year ago

Heroku does not autogenerate database.yml after Rails 4.1 devcenter.heroku.com/articles/…

Collectives™ on Stack Overflow

How to create new database on heroku server with postgres

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related