inchirags@gmail.com Chirag PostgreSQL DBA Tutorial https://www.chirags.in
Installation and Configuration of PostgreSQL 16 pg_probackup on Ubuntu 24.04 LTS
❓What is PostgreSQL pg_probackup?
pg_probackup is an open-source backup and recovery tool for PostgreSQL. It is designed to provide efficient, reliable, and flexible backup solutions for PostgreSQL databases. Think of it as a specialized utility for managing PostgreSQL backups and point-in-time recovery (PITR) more robustly than just relying on pg_dump or basic WAL archiving.
pg_probackup (PostgreSQL Professional Backup Tool) – Summary:
🤷♂️ Purpose: Efficient, reliable physical backup and recovery tool for PostgreSQL.
🤷♂️ Backup Types: Full and incremental (page-level or differential).
🤷♂️ PITR Support: Allows point-in-time recovery using base backups + WAL files.
🤷♂️ Storage Efficiency: Supports compression and deduplication.
🤷♂️ Validation: Can check backups for corruption.
🤷♂️ Retention Policies: Automates deletion of old backups.
Use Case: Ideal for large databases, incremental backup needs, and disaster recovery scenarios.
Key Advantage: Faster and more storage-efficient than pg_dump, with full support for PITR.
Prerequisites
Before starting, ensure you have:
- Ubuntu 24.04 LTS installed on your server (IP: 192.168.136.129).
- Root or sudo access.
- Basic familiarity with terminal commands (we'll explain each step).
- Enough disk space for backups (e.g., at least twice the size of your PostgreSQL data directory for testing).
We'll assume a local setup on this single server. If you have multiple servers ("and above" IPs), you can adapt for remote backups later using --remote-* options in pg_probackup commands.
Run all commands as the postgres user where specified, or use sudo for system-level tasks.
YouTube Video:
For any doubts and query, please write on YouTube video 📽️ comments section.
Note : Flow the Process shown in video 📽️.
😉Please Subscribe for more videos:
https://www.youtube.com/@chiragtutorial
💛Don't forget to, 💘Follow, 💝Like, Share 💙&, Comment
Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
Note: All scripts used in this demo will be available in our website.
Link will be available in description.
Top comments (0)