Help with GeoDjango / PostGIS Fly.io database setup

Django
2

Ok, I got this to work. What I did:

  1. fly pg connect and run all the CREATE EXTENSION commands I hadn’t run in the PostGIS install instructions
  2. The initial CREATE EXTENSION statement crashed the DB due to OOM, so I ran fly pg restart and tried step 1 again, which worked
  3. manage.py migrate from my app, this still crashed with a bad driver error
  4. fly pg restart again (just in case)
  5. manage.py migrate then worked

I’m not 100% why the restarts were necessary, so I would still welcome any wisdom – but it’s working.

3 Likes