n37r06u3

#!/usr/bin/python
# -*- coding: utf-8 -*-
# utf-8 中文编码
import glob
import os,sys
import json
reload(sys)
sys.setdefaultencoding('utf-8')
import time, sys,iptc  # iptc 包通过 sudo pip install python-iptables 安装
from datetime import datetime

n37r06u3

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