Hi, As said by ankhi, change to pgsql in settings before that use the django fixtures feature to take a backup of the data etc. try in test env only as this has breaking potential.
Regards, Kiran Capoor On Tue, 4 Jun 2019 at 01:33, Ankhi Roy <[email protected]> wrote: > Hey Victor, > > Do you mean to use postgresql instead of mysql, if so please change > database settings in settings.py. However, I am not sure how will you > migrate your existing mysql tables and contents to postgresql. Just a > workaround you can recreate tables in postgresql and re add the data. There > must be an efficient way though. > > Thanks > Ankhi > > On Mon, Jun 3, 2019, 8:21 PM Victor Porton <[email protected]> wrote: > >> How to migrate a production database MySQL -> PostgreSQL? >> >> (MySQL has several bugs, I want to try something other on my production >> server.) >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/django-users. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/97a3c018-86ee-462a-a21a-6d2a7971adc1%40googlegroups.com >> <https://groups.google.com/d/msgid/django-users/97a3c018-86ee-462a-a21a-6d2a7971adc1%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CABUQWg_hm7U__cwKJvFvvvR3osuz-MtswCL1YLA74pGdEvp_PA%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CABUQWg_hm7U__cwKJvFvvvR3osuz-MtswCL1YLA74pGdEvp_PA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Sent from iPhone -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAANvM2%3DHjGDSL3_rX6adnkp-8o%2Bj9trx9as0AMC5VGpMw25nZA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
