Re: How to migrate MySQL -> PostgreSQL?

Hi,

At my company we recently made a switch from MySQL to PG. We used https://pgloader.io/ to load the data from MySQL to PG. It reliable and quite fast (we had about 2GO of data to migrate in multiple table). The tool will handle table creation and data migration. As @Kiran said, try first in a test env. It may take a while depending on the amount of code that relies on MySQL specific features. I hope this helps!

Regard,

Julien Enselme

Développeur chez BureauxLocaux

Le mar. 4 juin 2019 à 00:56, Kiran Capoor <kirancapoor94@gmail.com> a écrit :

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.

--
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/CAL%3D_h26ttWeRZ5cv4dADrmLg4upJC65zdg4%3Dw1GFc8qZLUU5nw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.