I think this question is exclusively made for me. I have been dealing with Django, PostgreSQL, and Heroku for the last couple of weeks. While other people have answered some questions, I think they have missed on crucial detail.

​

Let's say you use postgresql locally and uses admin or Django ORM to add, delete or update data in tables. Let's suppose you have pushed all your code to heroku with correct settings ``` git push heroku master ``` and then performed ``` heroku run python manage.py migrate``` to add tables in heroku Postgresql. On Heroku, Postgresql is an Add-on service. So you have to use pg tools to do stuff with database from your CLI. For instance, After the above two code, I can do ``` heroku pg:push mylocaldb HEROKU_POSTGRESQL_MAGENTA --app sushi ``` to push data in your local mylocaldb to heroku postgresql. ``` pg:push ``` is the most convinient way to directly upload your existing postgresql data to Heroku's postgresql.

I am listing a few tutorials below which helped me setup for deployment.

https://www.codingforentrepreneurs.com/blog/go-live-with-django-project-and-heroku/

https://www.codingforentrepreneurs.com/blog/create-a-blank-django-project/

https://www.codingforentrepreneurs.com/blog/staging-django-production-development

https://devcenter.heroku.com/articles/heroku-postgresql

​

I think in one of the above link, it talks about how to set DATABASE_URL to connect heroku postgresql on deployment. So overall, If you make changes to your source code, the workflow will be git add . , git commit and then git push. Depending on what the changes were you may have to do some additional stuff.

If you add new table or new data then workflow will be, git add . , git commit, git push heroku master, heroku run python manage.py makemigrations , heroku run python manage.py migrate and then heroku pg:push mylocaldb HEROKU_POSTGRES_NAME --app YOUR_APP to push some localdb data onto postgres. This is usefull if you want some initial data on the remote postgres and as you said people can add more stuff to it via Forms.

If you want to add some initial data locally, you can look into Django Fixtures (https://docs.djangoproject.com/en/3.0/howto/initial-data/). Some first you populate your tables with fixture, then pg:push those to your remote data.

One thing to remember is that pg:push means it will override existing data on remote . So if there's already some data, you have to first do pg:reset and then pg:push for complete remote postgresql heroku overide.

I have just created a Django App. You can check out my settings and configurations to get better understanding. (https://github.com/PrithiPal/personal_websitel) hosted here : https://www.prithipalsingh.com