Sqlite table data not loaded into Postgresql database on Heroku [duplicate]

Question

This question already has answers here:

Django: What are the best practices to migrate a project from sqlite to PostgreSQL (7 answers)

Providing initial data for models - Django (1 answer)

Closed 3 years ago.

This post was edited and submitted for review 3 years ago and failed to reopen the post:

Original close reason(s) were not resolved

I've been working on a Django project locally and used SQLITE as the database. I've now deployed the project to Heroku-website and used Postgresql as the database. The database schemas have moved over fine but the data from the tables has not migrated.

What is my problem?

Here is my database code from settings file.

    DATABASES = {
        'default': {
            "ENGINE": "django.db.backends.sqlite3",
            "NAME": os.path.join(BASE_DIR, "db.sqlite3"),
        }
    }

    import dj_database_url
    db_from_env = dj_database_url.config(conn_max_age=600)
    DATABASES['default'].update(db_from_env)

This solution worked for me: stackoverflow.com/questions/54958008/… — bananatoast
– bananatoast, Commented Oct 29, 2022 at 10:51
"but the data from the tables has not migrated"—of course it didn't. That's not what migrations are for. Data can (and often should) vary between environments. — Chris
– Chris, Commented Oct 29, 2022 at 14:41

Manoj Tolagekar · Accepted Answer · 2022-10-29 10:31:48Z

0

You should use engine name only in database while in production.

In settings.py file:

"ENGINE": "django.db.backends.postgresql_psycopg2"

Transfer data from local to production.

Data transfer

Install the Heroku PGBackups add-on:

heroku addons:add pgbackups

Dump your local database:

pg_dump -h localhost  -Fc library  > db.dump

In order for Heroku to access db dump, you need to upload it to the Internet somewhere.

Import the dump to Heroku:

heroku pgbackups:restore DATABASE http://www.example.com/db.dump

answered Oct 29, 2022 at 10:31

Manoj Tolagekar

2,0082 gold badges7 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Sqlite table data not loaded into Postgresql database on Heroku [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related