Storing the Django project with the PostgreSQL database on GitHub

Question

I changed the database from SQLite3 to PostgreSQL in my Django project. Is it possible to store my new database in the GitHub repository so that after cloning and running by the command

python manage.py runserver

the project has started with the whole database?

No, that's not possible and also not advisable for SQlite. But Django offers fixtures to initialize the database. — Klaus D.
– Klaus D., Commented Apr 25, 2020 at 13:30
If you want to be able to recreate your postgres db, look at pg_dump and pg_restore. You can check the output of the former into your repo if you should so desire. — user2390182
– user2390182, Commented Apr 25, 2020 at 13:33

Ayush Pallav · Accepted Answer · 2020-04-25 13:34:32Z

1

You cannot save the database as such, you can instead create fixtures to be run. Whenever someone will clone the project, he/she can simple run those fixtures to populate the database.

answered Apr 25, 2020 at 13:34

Ayush Pallav

1,0571 gold badge10 silver badges21 bronze badges

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

3 Comments

Kazimierz Migdał Over a year ago

Any advice / source on how to create such fixtures ? Will I have to change the settings in DATABASES in settings.py then?

user2390182 Over a year ago

@KazimierzMigdał Have you read the docs? Check docs.djangoproject.com/en/3.0/ref/django-admin/#dumpdata and docs.djangoproject.com/en/3.0/ref/django-admin/…

Ayush Pallav Over a year ago

No, database settings etc. need not be changed. You can follow one of these links to do that: docs.djangoproject.com/en/3.0/howto/initial-data

Collectives™ on Stack Overflow

Storing the Django project with the PostgreSQL database on GitHub

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related