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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
