How to import postgresql data into sqlite3 (django specific)

Question

I would like to know how I can copy data from my production server (django+postresql) to my local dev servers (win7+sqlite3 + ubuntu+sqlite3).

My data is dumped in json format.

Ignacio Vazquez-Abrams · Accepted Answer · 2011-08-07 02:05:07Z

1

Use manage.py's loaddata predicate to load the dumped data.

answered Aug 7, 2011 at 2:05

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ignacio Vazquez-Abrams Over a year ago

That would be a problem with your data.

zaan · Accepted Answer · 2011-08-07 22:22:03Z

1

After first syncdb Django inserts some initial data to some tables (for eg. content_types, superuser). Remove your sqlite3 database, and run ./manage.py syncdb --noinput. If there's any data in tables, truncate them before running loaddata.

answered Aug 7, 2011 at 22:22

zaan

8974 silver badges12 bronze badges

2 Comments

howtodothis Over a year ago

Thanks for the tip but I am still getting the same error. 1. deleted the db 2. manage.py syncdb --noinput 3. django-admin.py loaddata datadump.json --settings=settings

zaan Over a year ago

Have you truncated django_* tables?

Collectives™ on Stack Overflow

How to import postgresql data into sqlite3 (django specific)

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related