Heroku rake db:drop error PG::Error: FATAL: permission denied for database "postgres"

How to empty DB in
herokuhttp://stackoverflow.com/questions/4820549/how-to-empty-db-in-heroku

I have a Postgres database on Heroku. It is one of the free beta ones.
Locally, when testing, I often run rake db:drop && rake db:create &&
rake
db:migrate as a way to reset the database.
However, when I try to run this on Heroku, I get the
error:[code]Couldn’t
drop mydatabaseid :
#<PG::Error: FATAL: permission denied for database “postgres” DETAIL:
User
does not have CONNECT privilege.
[/code]Uh, ok, so how am I supposed to completely reset my database,
migrations and everything?

On 5 October 2012 21:41, mukul saharia [email protected] wrote:

How to empty DB in heroku
I have a Postgres database on Heroku. It is one of the free beta ones.
Locally, when testing, I often run rake db:drop && rake db:create && rake
db:migrate as a way to reset the database.
However, when I try to run this on Heroku, I get the error:[code]Couldn’t
drop mydatabaseid :
#<PG::Error: FATAL: permission denied for database “postgres” DETAIL: User
does not have CONNECT privilege.
[/code]Uh, ok, so how am I supposed to completely reset my database,
migrations and everything?

Googe found this as the second hit
http://stackoverflow.com/questions/8162420/running-rake-dbdrop-dbcreate-dbmigrate-on-heroku-cedar-stack

I don’t know what pg:reset does on heroku so this may not be relevant
but generally it is better to use rake:schema:load rather than create
followed by running all the migrations.

Colin

Please follow:

http://stackoverflow.com/questions/4820549/how-to-empty-db-in-heroku

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs