Maintenance

Backup database (online)

podman exec postgres pg_dump -Fc -U postgres cq | gzip > game_db_backup_$(date +%Y%m%d).dump.gz

Restore database

gunzip < game_db_backup_<yyyymmdd>.dump.gz | podman exec -i postgres pg_restore -U postgres -d cq