I had to migrate what had started as a toy website and has now become a real website from running on sqlite to postgres today. I use a push-to-deploy setup, so the process was a bit tricky. I only needed like 10 minutes of downtime to do it, but had to make sure I had all the steps in order. For future record:
- Update
requirements.txtto includepsycopg2and push the latest version ofproductionbranch so that any migrations get applied on the sqlite DB andpsycopg2is installed in the virtual env.