Setting up PostgresQL on Heroku Rails 4

Question

its been a while since i have used postgresql and deployed an app to Heroku, think I have made an error somewhere with my setup.

I have created my app on Heroku, there is a Hobby Dev database setup (I ran Heroku run rake db:setup) which set up my database, but I'm wondering in my database.yml file do i have an error

default: &default
adapter: postgresql
encoding: unicode
# For details on connection pooling, see rails configuration guide
# http://guides.rubyonrails.org/configuring.html#database-pooling
pool: 5

production:
<<: *default
database: my_app_production
username: my_app
password: <%= ENV['MY_APP_DATABASE_PASSWORD'] %>

When I run heroku run rake db:create i get

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

Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "pool"=>5, "database"=>"databaseName", "username"=>"userName", "password"=>"password", "port"=>5432, "host"=>"hostNamehere"}

I have set the database password using heroku config:set

What have i missed here?

Thanks

Have you set password for postgres heroku config:set MY_APP_DATABASE_PASSWORd='password' — Pardeep Dhingra
– Pardeep Dhingra, Commented Dec 3, 2015 at 10:54
yes i have done that, but i will update that in the question to avoid confusion, thanks — Richlewis
– Richlewis, Commented Dec 3, 2015 at 10:57
can you put the logs you are getting.. or try this .stackoverflow.com/questions/20293895/… — Pardeep Dhingra
– Pardeep Dhingra, Commented Dec 3, 2015 at 11:00

eugen · Accepted Answer · 2015-12-03 11:12:22Z

4

Heroku ignores your database.yml configuration, they generate one when you deploy your application and they also take care of database creation. All you need to do is heroku run rake db:migrate and maybe a heroku run rake db:seed in case you need to seed your database.

edited Dec 3, 2015 at 11:12

answered Dec 3, 2015 at 11:06

eugen

9,25611 gold badges61 silver badges67 bronze badges

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

2 Comments

Richlewis Over a year ago

well that makes everything nice and easy then :-) Thank You

Richlewis Over a year ago

because i need to wait 7 mins before I can accept :)

Collectives™ on Stack Overflow

Setting up PostgresQL on Heroku Rails 4

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related