How to migrate MySQL Django website to Postgres Django website?

November 23, 2019 121 views
Django Ubuntu 18.04 PostgreSQL MySQL

Hi,

We have our Django based website running in our local windows box with MySQL database. We plan to deploy our site on Ubuntu, Postgress, Gunicorn and Nginx stack server that can be run on DigitalOcean droplet. I’m looking for a way to achieve this even with the manual intervention? I appreciate if someone can point me the right direction with appropriate documentation.

Thanks

2 Answers

Changing the type of Database in a Django project is easy, you need to change the BD engine and its parameters in settings.py and then do the migrations from the beginning. In Digital Ocean there is extensive documentation on this subject, you can also consult my video tutorials (subtitles in English) of initiation:

https://www.youtube.com/channel/UCwH_HDL-Ii5NDnYp1EZVvYw?view_as=subscriber

hello Frank, yes I’m aware of BD Engine parameters but I need to know the steps for actual migration for Django project and not for any other applications.

Have another answer? Share your knowledge.