Create local postGres

[tds455]

No description provided.

[tds455]

sudo docker run --name postgresdev -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=enterpassword -e POSTGRES_DB=prod -p 60000:5432 -d postgres:latest

sudo cat backup.sql | sudo docker exec -i postgresdev psql -U postgres

sudo docker exec -it postgresdev bash

[tds455]

61522e1

added backup.sql

[tds455]

I have added a file - restoredb.sh.

This will configure a psql container and restore the latest backup of the prod database.

Next step will be to automatically create daily backups of prod db.

To use this file a DB_PW environment variable must be set with the current DB password

[Evomatic]

Well done with the script, This will make the local dev setup more smooth. I did run into some issues on my end though, so I refactored the script a bit to handle errors and provide messages for each step.

[tds455]

Updated to do: add food_category table to allow queries on specific categories

[Evomatic]

Want to look into adding the django rest api framework: https://www.django-rest-framework.org/