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 using the Backup List tab.

• The Backup History table shows each backup's Timestamp, Date, Status, Database, Type, Duration, Compressed, and Plugin. Select a row to expand the Backup Details panel below the table.
• Review the Timestamp and Database columns to ensure backups are occurring at the required intervals.
• Monitor backup performance by observing the Duration column. A sudden increase could indicate network congestion or storage bottlenecks.
• Filter by Status (Success, Failed, or All) to quickly identify failed runs. 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

Inspect the full details of a specific backup entry using the Backup Report tab. Select a backup from the dropdown to load its report, which is organized into three sections:

• General Information: database name and basic metadata.
• Backup Configuration: compression levels, backup type, and related settings.
• Backup Location: storage path and plugin details.

Analyzing archives and protection trends

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

• Find which backups contain a specific table using the Find Table tab. Enter a table name in table_name or schema.table_name format and select Search to list the backups that include it.
• Review aggregate backup health trends using the Statistics tab. Charts show Success Rate, Backup Types, Backups per Month, and average backup duration over time.