I have a Canvas LMS test server that was setup using the production start instructions. I've tried to reset the database using:
sudo RAILS_ENV=production bundle exec rake db:reset
This command deletes the database, but gives me the error:
PG::InsufficientPrivilege: ERROR: permission denied to create database
Of course, I can recreate the database and re-initialize it using:
sudo RAILS_ENV=production bundle exec rake db:initial_setup
But then I have to manually re-enter the account & account admin info. It seems like I must be missing something really obvious here - any suggestions?