pgbackrest/pgbackrest
Pgbackrest
pgBackRest este un instrument distribuit de backup și restaurare pentru PostgreSQL. Funcționează ca un motor de backup incremental și manager de recuperare point-in-time, permițând crearea de backup-uri complete, diferențiale și incrementale în repository-uri locale și la distanță.
Sistemul se distinge prin backup-urile incrementale la nivel de bloc, care reduc timpul de stocare și transfer prin salvarea doar a datelor modificate. Se integrează cu stocarea de obiecte compatibilă cu S3 prin HTTP și utilizează procesarea paralelă pentru a maximiza throughput-ul în timpul operațiunilor de backup și restaurare.
Instrumentul acoperă capabilități cuprinzătoare de recuperare în caz de dezastru, inclusiv arhivarea write-ahead log pentru restaurarea point-in-time și verificarea integrității bazată pe checksum pentru a detecta coruperea datelor. De asemenea, oferă automatizarea ciclului de viață al backup-ului prin rotație bazată pe politici și securizează datele prin criptarea repository-ului și protocoale de transport securizate.
Features
- PostgreSQL Backup Strategies - Implements automated procedures for creating full, differential, and incremental backups specifically for PostgreSQL databases.
- Disaster Recovery Systems - Provides comprehensive disaster recovery by restoring large PostgreSQL clusters using parallel processing and delta restores.
- S3-Compatible Cloud Storage - Integrates with S3-compatible object storage using HTTP for remote data redundancy.
- Database Backup and Restore - Provides a distributed system for creating and restoring database backups across local and remote repositories.
- Cloud Storage Connectors - Provides connectors to upload database backups and logs to cloud object storage via HTTP.
- Write-Ahead Logging - Streams transaction logs (WAL) to secure repositories to enable point-in-time recovery.
- Database Incremental Backups - Provides block-level incremental backups to reduce storage and transfer time for PostgreSQL databases.
- Multi-Level Backups - Creates full, differential, and incremental backups at the file or block level to minimize storage requirements.
- Point-in-Time Recovery - Provides mechanisms to restore database states to specific historical moments by replaying archived write-ahead logs.
- WAL Streaming - Streams write-ahead logs to a repository to enable database restoration to a specific timestamp.
- WAL and Snapshot Archiving - Ships PostgreSQL backups and transaction logs to remote object storage for offsite redundancy.
- Backup Retention Policies - Automates the expiration and rotation of old backup sets based on user-defined retention rules.
- Delta Database Restorations - Recovers data using delta restores to skip unchanged files and remap tablespaces for faster recovery.
- Parallel Restore Utilities - Leverages concurrency to perform parallel database restorations, minimizing downtime for large workloads.
- Parallel Processing - Uses parallel processing with multiple concurrent worker processes to maximize throughput during backup and restore operations.
- High-Performance Data Transfer - Optimizes large-volume data movement by adjusting compression levels, buffer sizes, and parallel process counts.
- Remote Backup Repository Management - Transfers backups and archives to local or remote locations via secure protocols to ensure data redundancy.
- Backup Integrity Verifications - Implements checksum-based verification for every file to detect data corruption during backup and restoration.
- Encrypted Backups - Encrypts stored backups at rest to protect sensitive database information from unauthorized access.
- Transport Security - Enforces modern encryption standards and custom cipher suites for secure communication with remote storage providers.
- Backup Performance Optimizations - Reduces the time and CPU cost of backup and restore operations using parallel processing and streaming compression.
- Object Storage Backups - Supports shipping PostgreSQL backups and transaction logs to S3-compatible object storage via HTTP.
- Backup Lifecycle Automation - Automates the transition and expiration of old backup archives to reclaim storage based on policy.
- Delta Restorations - Accelerates recovery speed by comparing checksums and only restoring files that differ from the local version.
- Archive Integrity Verifications - Calculates and validates cryptographic checksums for all backed-up files to detect data corruption.
- Backup and Recovery - Reliable backup and restore solution for PostgreSQL.
