Backup and restore postgres database

[devxpy]

backup

pg_dump --dbname $PGDATABASE --format c -f db.dump

or, from a running docker container in prod:

# select a running container
cid=$(docker ps | grep gooey-admin-prod | cut -d " " -f 1 | head -1)
# give it a nice name 
fname=gooey_db_$(date +"%Y-%m-%d_%I-%M-%S_%p").dump
# exec the script to create the fixture
docker exec -it $cid pg_dump --dbname $PGDATABASE --format c -f "$fname"
# copy the fixture outside container
docker cp $cid:/app/$fname .
# print the generated path
echo $PWD/$fname

backups are also run in prod periodically via https://github.com/GooeyAI/caprover-postgres-backup

restore

# reset the database
./manage.py reset_db
# create the database with an empty template
createdb -T template0 $PGDATABASE
# restore the database
pg_restore --no-privileges --no-owner -d $PGDATABASE db.dump