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.txt
to includepsycopg2
and push the latest version ofproduction
branch so that any migrations get applied on the sqlite DB andpsycopg2
is installed in the virtual env.