How to migrate MySQL Django website to Postgres Django website?

November 23, 2019 121 views
Django Ubuntu 18.04 PostgreSQL MySQL
9c700632 0bf0 40a1 ac5a 70d7f8ef4fb9
By:
bengaltiger

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

Sign In to Comment
2 Answers
frankmascarell November 23, 2019

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

bengaltiger November 23, 2019

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.

Related