Re: How to migrate MySQL -> PostgreSQL?

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 <montiprk0@gmail.com> 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 <porton@narod.ru> 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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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.
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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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.
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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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.