Use WarehousePG Backup and Restore (whpg-backup) to create and restore logical backups of your WarehousePG tables in parallel. By default, backups are written to local disk on the coordinator and segment hosts, though you can consolidate them in a shared directory or write them directly to S3-compatible storage. whpg-backup writes the metadata and DDL for a backup to the coordinator host, while each segment writes its own table data to CSV files, so backup and restore performance scales with your cluster.
Key capabilities
- Parallel backup and restore across the coordinator and all segment hosts
- Full database backups, plus incremental backups that include every heap table but back up append-optimized tables only if they changed
- Filtering backups and restores by schema, table, or leaf partition
- Email notifications when a backup or restore completes
- Backing up directly to Amazon S3 or S3-compatible storage