Rake db:reset 'user does not have CONNECT privilege' Rake db:reset 'user does not have CONNECT privilege' ruby ruby

Rake db:reset 'user does not have CONNECT privilege'


Use heroku pg:reset DATABASE instead as noted in https://devcenter.heroku.com/articles/rake

You cannot drop databases in Heroku with rake db:reset because user has no privileges.


I recently had this problem and resolved it through the following steps.

  1. heroku pg --help gets the name of commands for using postgres

  2. heroku pg:reset DATABASE # resets the db

  3. Answer the prompt to confirm