Migrate Django development database (.sql3) to Heroku

Question

How does one migrate their Django .sql3 development database to heroku?

django project with important database highlighted that must be migrated

Per here, and here I tried: heroku pg:psql --app sblic < database.sql3 but my Django admin shows no new uploads (even after syncdb/migrate/ or collectstatic

The easiest way to move your database and code up to Heroku is just via a git push. — Brandon Taylor
– Brandon Taylor, Commented Feb 21, 2015 at 20:09
Your question shows a SQLite3 database. How is that related to an example that shows how to push a Postgres database? I think you need to re-state your question. — Brandon Taylor
– Brandon Taylor, Commented Feb 21, 2015 at 20:11
@Brandon In Heroku the default database is Postgres, using django on local environment the default is SQLite3. — Shoo Limberger
– Shoo Limberger, Commented Mar 5, 2017 at 17:00

Community · Accepted Answer · 2017-05-23 11:53:53Z

3

Perhaps there may be a way to directly upload an sql3 file to Heroku, but I went with the path of clearest certainty (convert local sql3 db to postgre db and upload a dump of postgre db to Heroku via pgbackups tool):

Create a dump of your sql3 database as a json file
With PostgreSql installed and with its bin directory in the Path environment variable, create a postgre user and database (or just plan on using your initial super user account created upon installing postgresql)
Update your settings.py with a reference to your newly created postgre database (note, 'HOST' may need to be set as 'localhost', 'user' is your postgre user login)
run python manage.py syncdb to initiate your new postgre db
Optional: if necessary, truncate your postgre db of contenttypes
load your dump from step 1 (if you have fixture issues, see here)
Now you have a working postgre local db. To migrate, first create a postgre dump
Post your postgre dump somewhere accessible by URL (such as drop box or amazon s3 as suggested in previous link).
Perform pgbackups restore command, referencing your dump url
Your heroku app should now reference the contents of your local db.

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Feb 22, 2015 at 19:16

ecoe

5,4028 gold badges62 silver badges84 bronze badges

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

1 Comment

Ahtisham Over a year ago

This always gives fixture error. even after adding arguments like --natural-foreign --natural-primary while dumping. @DanielRoseman sir do you know the fix ? please help.

Selcuk · Accepted Answer · 2015-02-21 22:00:00Z

1

Heroku command line tool uses the psql binary. You have to install PostgreSQL on your local development machine to have psql available. From the (documentation)[https://devcenter.heroku.com/articles/heroku-postgresql#pg-psql]:

You must have PostgreSQL installed on your system to use heroku pg:psql.

You can in fact keep using your SQLite database with Heroku, but this is not recommended as it will be rewritten with your local copy if you re-deploy it to another dyno. Migrating the data to psql is recommended as described at https://devcenter.heroku.com/articles/sqlite3

answered Feb 21, 2015 at 22:00

Selcuk

60.1k12 gold badges114 silver badges119 bronze badges

1 Comment

ecoe Over a year ago

excellent, but I have a .sql3 database so I'll need to convert to postgres first...

Collectives™ on Stack Overflow

Migrate Django development database (.sql3) to Heroku

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related