Re: Help converting from mysql to postgres

Thanks, I finished this, by using dump data on one app at a time. I was trying to do the whole project at once. I did run into sequence errors. I followed this. http://tryolabs.com/Blog/2012/02/10/django-migrating-mysql-postgresql/ On Saturday, May 18, 2013 1:23:04 PM UTC-4, frocco wrote: > > H

Re: Help converting from mysql to postgres

I cannot claim any DBA credentials so be careful reading further. I use dumpdata successfully with lots of --exclude=djkgd.sdsghg options only for testing fixtures. I have tried a few times and failed to get it working transferring between two Postgres databases. I use postgres dump and load

Re: Help converting from mysql to postgres

I am getting IntegrityError: duplicate key value violates unique constraint "catalog_pricing_pkey" DETAIL: Key (id)=(8) already exists. catalog_pricing_id_seq Start Value 8 Last Value 1 Increment 1 There are 8 records in table. id 1 through 8 If I reset sequence, last value is set to 1 if

Help converting from mysql to postgres

Hello Here are my steps. python manage.py dumpdata --database=legacy > data.json python manage.py loaddata data.json --database=default IntegrityError: Problem installing fixture 'data.json': Could not load accounts.UserProfile(pk=17): duplicate key value violates unique constraint "accounts