[mezzanine-users] Problem migrating from sqlite3 to postgresql

2015-05-26 Thread Jonathan Sandoval
Hi everyone. I started my mezzanine site with sqlite3 and, as I'm almost finished, I'm trying to migrate from sqlite3 to postgresql. I'm following this guide: http://matthewwittering.com/blog/how-to-migrating-the-database-engine-for-django.html. It basically works by dumping data to a json fil

Re: [mezzanine-users] Problem migrating from sqlite3 to postgresql

2015-05-26 Thread Eduardo Rivas
I've used JSON dumps in the past with mixed results. Generally, a single, monolithic dump of all the data almost never works on the first try. Some general tips: - Make sure you run createdb again when you have changed your settings to use Postgres. The JSON dump only populates the DB, but it

Re: [mezzanine-users] Problem migrating from sqlite3 to postgresql

2015-05-26 Thread Jonathan Sandoval
Many thanks for the suggestions. They were very useful. I made chunks for every app and found out problems in two, generic (because of comments) and blog. I have not solved the first one yet, but it's almost irrelevant because I have not many comments in the site I'm migrating from wordpress, s

Re: [mezzanine-users] Problem migrating from sqlite3 to postgresql

2015-05-26 Thread Ken Bolton
Hi Jonathan, I suggest you try importing your wordpress site to the new database, if possible, rather than the intermediate sqlite step. - ken On Tue, May 26, 2015 at 6:52 PM, Jonathan Sandoval wrote: > Many thanks for the suggestions. They were very useful. I made chunks for > every app and f

Re: [mezzanine-users] Problem migrating from sqlite3 to postgresql

2015-05-26 Thread Ark
Hi Ken. That's not an option anymore. I was going to change my theme so I switched to mezzanine because my main language is Python, so it's easier for me to modify and adapt the site. I started with sqlite to try mezzanine; I liked it a lot as well as it's community and I started to do the migrati