AnsweredAssumed Answered

How do I reset the database on a production start Canvas LMS setup?

Question asked by Kurt Faulknerloser on Mar 2, 2017



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?