pgbackrest/pgbackrest
Pgbackrest
pgBackRest es una herramienta de copia de seguridad y restauración distribuida para PostgreSQL. Funciona como un motor de copia de seguridad incremental y gestor de recuperación en un punto en el tiempo (PITR), permitiendo la creación de copias de seguridad completas, diferenciales e incrementales a través de repositorios locales y remotos.
El sistema se distingue por sus copias de seguridad incrementales a nivel de bloque, que reducen el tiempo de almacenamiento y transferencia al guardar solo los datos modificados. Se integra con almacenamiento de objetos compatible con S3 a través de HTTP y utiliza procesamiento paralelo para maximizar el rendimiento durante las operaciones de copia de seguridad y restauración.
La herramienta cubre capacidades integrales de recuperación ante desastres, incluyendo el archivado de registros de escritura anticipada (WAL) para la restauración en un punto en el tiempo y la verificación de integridad basada en sumas de comprobación para detectar la corrupción de datos. También proporciona automatización del ciclo de vida de la copia de seguridad a través de rotación basada en políticas y asegura los datos mediante cifrado de repositorio y protocolos de transporte seguros.
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.
