Securing backups

The Backups panel serves as a centralized monitoring hub for your data protection lifecycle. Use these actions to verify the integrity of your snapshots and ensure that your recovery point objectives (RPO) are being met across the WarehousePG cluster.

Auditing backup history and health

Use the Backup List tab to maintain a chronological record of all data protection operations performed via the gpbackup_manager utility.

• Verify recovery point objectives: 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: Observe 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.
• Interpret operational status: Regularly check the status column to identify gaps in protection. If a backup is marked as "Failed," immediately transition to the auditing system logs page to identify which segment or network path caused the interruption.

Inspecting backup metadata and scope

When you select a specific entry from the backup history, use Metadata to validate exactly what data was secured and how it was stored.

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

Navigating advanced backup tools

Use the following tabs to locate specific data within your backup archive and analyze long-term protection trends.

• Find specific tables in archives: Use the Find Table tab to search through historical snapshots for a specific object. This allows you to identify exactly which backup ID contains the version of a table you need to recover.
• Analyze protection statistics: Review the Statistics tab to see aggregate data on backup success rates and storage consumption over time. Use these trends to forecast when your backup storage destination will require more capacity.
• Review backup reports: Access the Backup Report tab for a summarized view of the most recent operations, including detailed exit codes and summary logs generated by the gpbackup_manager utility.