Setup Heroku Database for the first time

Question

I am using postgresql and have been operating under my local dev environment. I deployed my app to Heroku, and now I need to setup heroku to use a database just like I have locally.

Locally, I would run this:

rake db:create
rake db:migrate

On heroku, I tried the same thing:

heroku run rake db:create

However, that returns this error:

FATAL:  permission denied for database "postgres"
DETAIL:  User does not have CONNECT privilege.

Couldn't create database for {"adapter"=>"postgresql", "username"=>"stegjyxfak", "password"=>"wB-Yfh450945jI5UrnFjxdwZ_o4N5", "port"=>5432, "database"=>"d64phj348vgdg5hm", "host"=>"ec2-107-20-191-205.compute-1.amazonaws.com"}

What should I be running to get my heroku DB setup? I am using Rails 4.0 if that is relative.

Have you read "Getting Started with Rails 4.x on Heroku", especially the "Migrate your database" part? — Milen A. Radev
– Milen A. Radev, Commented Jan 15, 2014 at 14:55

gabrielhilal · Accepted Answer · 2014-01-15 14:52:59Z

14

You should use migrate instead of create:

heroku run rake db:migrate

https://devcenter.heroku.com/articles/getting-started-with-rails4#deploy-your-application-to-heroku

answered Jan 15, 2014 at 14:52

gabrielhilal

10.8k8 gold badges56 silver badges83 bronze badges

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

Comments

schmijos · Accepted Answer · 2015-06-05 08:53:27Z

1

Directly destructive commands (drop and create) are not permitted on heroku. But if you're ok with loosing all the data, you can reset the database with pg:reset.

Every other change should be done with db:migrate. If your migrations don't run through the full stack anymore you can also use db:schema:load but be aware that this can be destructive if create_table has set force: true or force: :cascade.

answered Jun 5, 2015 at 8:53

schmijos

8,8434 gold badges54 silver badges60 bronze badges

Collectives™ on Stack Overflow

Setup Heroku Database for the first time

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related