pgBackRest (woblerr)
Get reliable, scalable backups for the largest databases. Features parallel processing, delta restore, encryption, and support for S3, Azure, and GCS storage.
pgBackRest is a robust backup and restore solution built for PostgreSQL, capable of handling the largest databases and most demanding workloads. It uses parallel processing and efficient compression algorithms to significantly speed up operations. You can store backups locally, on remote servers via a secure protocol, or in cloud object stores.
It provides a comprehensive set of features to ensure data safety and fast recovery:
- Flexible Backup Types: Perform full, differential, and incremental backups, with block-level support to save space.
- High Performance: Leverage parallel backup and restore processes, along with asynchronous WAL archiving, to minimize downtime.
- Rapid Recovery: Use delta restore to only restore changed files, dramatically reducing restore times for large databases.
- Versatile Storage: Configure multiple repositories on local, remote, S3, Azure, or GCS storage for redundancy and long-term retention.
- Data Integrity: Every file is verified with checksums, and interrupted backups can be resumed without starting over.
- Security: Protect your data at rest with built-in repository encryption.
Directory Structure
pgbackrest-woblerr
pgbackrest-deployment
backups
config
pgdata
.env
docker-compose.yml
docker-compose.yml
services:
postgres:
image: postgres:15
container_name: postgres
environment:
POSTGRES_USER: ${POSTGRES_USER}
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
POSTGRES_DB: ${POSTGRES_DB}
volumes:
- ./pgdata:/var/lib/postgresql/data
ports:
- "5432:5432"
restart: unless-stopped
pgbackrest:
image: woblerr/pgbackrest:latest
container_name: pgbackrest
# Keeps the container alive so you can execute pgbackrest commands via 'docker exec'
command: tail -f /dev/null
volumes:
- ./pgdata:/var/lib/postgresql/data
- ./config:/etc/pgbackrest
- ./backups:/var/lib/pgbackrest
depends_on:
- postgres
restart: unless-stopped
.env
POSTGRES_USER=admin
POSTGRES_PASSWORD=your_super_secret_password
POSTGRES_DB=app_database
Categories:
Tags:
Ad
Similar to pgBackRest (woblerr)