Data Export & Disaster Recovery Backup
Securely export financial tables, youth contribution matrices, or create a full JSON database snapshot.
Full Ledger JSON Snapshot
Creates an exact cryptographic JSON archive of members, contributions, parish donations, youth meetings, and expenses. Ideal for offline storage and offsite disaster recovery.
Format: .JSON
Youth Contribution Matrix (CSV / Excel)
Exports the full 12-month member donation matrix in CSV format with formula injection sanitization, suitable for audit reviews and spreadsheet viewing.
Format: .CSV
Recommended PostgreSQL Production Backup Procedure
For live production databases on VPS or cloud servers, configure regular PostgreSQL automated backups:
pg_dump -U postgres -h localhost -d stpauls_finance > backup_stpauls_$(date +%Y%m%d).sql
