Submit Checklist

• I have selected the next branch as the destination for my PR, not main.
• I have listed all changes in the Changes section.
• I have filled out the Issues section with the issue/discussion link(s) (if applicable).
• I have tested my changes.
• I have considered backwards compatibility.
• I have removed this checklist and any unused sections.

Changes

• Core Features

  • Implement pgBackRest as default backup method for PostgreSQL databases
  • Support for full, differential, and incremental backups with configurable retention policies
  • Native S3 repository support with direct writes (eliminates local intermediate storage)
  • Parallel processing configuration (1-16 processes) for faster operations
  • Block-level incremental backups for up to 50x storage reduction

• Restore Functionality

  • Add DatabaseRestoreJob for PostgreSQL restoration from pgBackRest and pg_dump backups
  • New API endpoint: POST /api/v1/databases/{uuid}/backups/{backup_uuid}/restore/{execution_uuid}
  • Delta restore mode for pgBackRest (only restores changed files)
  • Automatic container management with error recovery
  • Restore notifications (RestoreSuccess, RestoreFailed)

• Resource Management

  • Automatic pgBackRest stanza cleanup on backup configuration deletion
  • S3 connectivity validation before creating backup configurations
  • Backup size extraction from pgBackRest metadata for accurate reporting

• API

  • pgBackRest configuration parameters in backup create/update endpoints
  • Restore endpoint with optional target database parameter
  • Validation ensures pgBackRest only used with PostgreSQL databases

• Documentation

  • Comprehensive guide at gist
  • API usage examples and configuration reference
  • Backup strategy recommendations by database size
  • Migration guide from pg_dump to pgBackRest

• Database Schema

  • Migration adds pgBackRest configuration columns to scheduled_database_backups table
  • Backward compatible with existing pg_dump backups

• Security

  • S3 credentials stored in configuration file (not environment variables)
  • Command injection protection with proper shell escaping
  • S3 endpoint connectivity validation

Issues

• fix #7172 /claim #7172