open-plan-tool / gui

Energy Planning Application
Other
8 stars 4 forks source link

Switch database from MYSQL to postgreSQL #142

Closed Bachibouzouk closed 2 years ago

Bachibouzouk commented 2 years ago

Switch from mysql to postgres database

From the container of the previous mysql based django app exectuted python manage.py dumpdata projects users dashboard > db_backup_fixture.json

Then copied the file to the container of the new postgres based django app and executed python manag.py loaddata 'db_backup_fixture.json'

There was a serialization error at first, it was due to asyncio logger, so I set the logging detail to warning to disable it and it worked then.