Big surprise: Dumping from sqlite3 doesnt seem to generate SQL that can be read correctly by postgres.
Thankfully, in django we have a high-level export / import function.
Export everything to json from db.sqlite3:
./manage.py dumpdata > db.json
Then switch your local djangoCMS installation to postgres (don’t forget to reload your env vars in case they contain your db settings).
createdb db-name ./manage migrate # the following works on a mac (possibly because of the Postgres.app) psql # the following tables need to be flushed because they are populated with default data that collides with the imported data delete from auth_group_permissions; delete from auth_permission; delete from django_admin_log; delete from django_content_type; # now you can import ./manage.py loaddata db.json # doesnt hurt ./manage.py cms fix-tree