How do I reset the database on a production start Canvas LMS setup?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-02-2017
04:43 PM
Hello,
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?
Thanks.