pulse-

I had this really small problem today. I wanted to migrate one of my small django apps to use postgres, just to make everything easy to manage. Sqlite3 is perfectly fine for the amount of load, however I am really much faster at administering postgres than I am on sqlite3. So I decided to migrate the stuff over.

I tried a few approaches, but what ultimately worked the best and the fastest fo rmy particular problem was to do the following.

Use original SQLITE3 connection in settings.py
1. python manage.py dumpdata > dump.json

(I read some things here about some options you can pass, at the end what just worked was the following)

2. Change DB connection string in settings.py to POSTGRES