Backup and Restore

pg_dump -h localhost -U lumina lumina > backup.sql

# Cron job for daily backups
0 2 * * * pg_dump -h localhost -U lumina lumina | gzip > /backups/lumina-$(date +\%Y\%m\%d).sql.gz

velero backup create lumina-backup   --include-namespaces lumina

velero restore create --from-backup lumina-backup

docker run --rm   -v postgres-data:/data   -v $(pwd):/backup   alpine tar czf /backup/postgres-backup.tar.gz -C /data .

docker run --rm   -v postgres-data:/data   -v $(pwd):/backup   alpine sh -c "cd /data && tar xzf /backup/postgres-backup.tar.gz"

# 1. Create test database
createdb lumina_test

# 2. Restore backup
psql lumina_test < backup.sql

# 3. Verify data
psql lumina_test -c "SELECT COUNT(*) FROM traces"

# 4. Clean up
dropdb lumina_test