Database Backups & Recovery Policy

This document outlines the backup methodology, retention schedules, and restoration guidelines for Salitech databases.

Backup Strategy Matrix

Target	Frequency	Method	Destination	Encryption
Umami PostgreSQL	Daily (`planned`)	`pg_dump` compressed	Offsite / Local archive	AES-256
Platform PostgreSQL	Daily + WAL (`planned`)	`pg_dump` & WAL archiving	Offsite Storage	AES-256

Standard Dump Procedure (Example)

For containerized PostgreSQL instances:

# Generate compressed SQL dump
docker exec -t <postgres_container_name> pg_dump -U <db_user> <db_name> | gzip > /opt/backups/db_backup_$(date +%Y%m%d_%H%M%S).sql.gz