How to migrate to Postgresql?

Question

My Django project on Heroku I want to migrate from SQLite to PostgreSQL. I changed my settings.py to PostgreSQL. On Windows I installed PostgreSQL and psycopg2. I created the database manually.

As I run makemigrations it creates an SQLite database. Why?

Does this answer your question? Django: What are the best practices to migrate a project from sqlite to PostgreSQL — mattm
– mattm, Commented Jan 22, 2020 at 19:07

augu1352 · Accepted Answer · 2019-01-04 20:37:11Z

0

After you have run python manage.py makemigrations you need to run python manage.py migrate to apply the data to the new database.

answered Jan 4, 2019 at 20:37

augu1352

1

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

1 Comment

Dacey Over a year ago

done that ofcourse, but it is creating a sqlite db instead of postgres

Nick_Jo · Accepted Answer · 2022-11-10 04:38:22Z

@Dacey you'll need to edit the settings.py file and change the database name (and potentially connection).

Database https://docs.djangoproject.com/en/4.1/ref/settings/#databases

''' here you use triple quotes to block out your original statement
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'old_sqlite.db',
    } } 
close your triple quotes    '''

Change the above to something like this

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'PostGres_New',
'USER': 'postgres',
'PASSWORD': 'postgres',
'PORT':'5432',
'HOST':'localhost',
    } }

Collectives™ on Stack Overflow

How to migrate to Postgresql?

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related