DEV Community

Cover image for Installation and Configuration of PostgreSQL 16 pg_probackup on Ubuntu 24.04 LTS #postgres #postgresql #backup #pitr
Chitt Ranjan Mahto (Chirag)
Chitt Ranjan Mahto (Chirag)

Posted on

Installation and Configuration of PostgreSQL 16 pg_probackup on Ubuntu 24.04 LTS #postgres #postgresql #backup #pitr

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)