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

kurt_faulknerlo
Community Novice

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.

0 Likes