Securing backups

Maintain data integrity and monitor the protection lifecycle of your WarehousePG (WHPG) cluster. Use the Backups panel on the left sidebar to audit snapshot health and ensure your recovery point objectives (RPO) are met across the cluster.

Verifying data protection and recovery objectives

Maintain a chronological record of all data protection operations and identify gaps in your recovery strategy by consulting the Backup List tab.

• Review the Timestamp and Database columns to ensure that backups are occurring at the required intervals. Frequent successful snapshots ensure that you can restore data to a recent point in time in the event of a failure.
• Monitor backup performance by observing the Duration and Size metrics. A sudden increase in backup duration or a significant drop in backup size could indicate network congestion, storage bottlenecks, or that specific large tables were excluded from the run.
• Regularly check the Status column to identify gaps in protection. If a backup is marked as Failed, transition to the Logs panel on the left sidebar to identify which segment or network path caused the interruption.

Validating backup coverage and storage settings

Validate exactly what data was secured and how it was stored for a specific backup entry using the Backup Report tab.

• Review the object scope to see which schemas and tables were included or excluded. This operation is critical for ensuring that new production tables haven't been accidentally omitted from the backup routine.
• Verify the storage targets and compression levels. Higher compression reduces storage costs but could extend the recovery time during a restoration process.

Analyzing archives and protection trends

Locate specific data within your backup archive and analyze long-term protection trends.

• Find specific tables in archives with the Find Table tab. Search through historical snapshots for a specific object to identify exactly which backup ID contains the version of a table you need to recover.
• Review the aggregate data on backup success rates and storage consumption over time by looking at the Statistics tab. Use these trends to forecast when your backup storage destination will require more capacity.