5.4.3 Backup & restore
Every entry filed under Backup & restore and its subtopics.
Kind
- Tutorial 1
- Concept 1
- How-to 2
- Reference 0
- Fix 0
Platform
- Linux 5
- macOS 0
- Windows 0
- Browser 0
5 entries
- 0202 Back up and restore PostgreSQL with pg_dump, pg_restore and pg_dumpall Make logical backups of one database with pg_dump, of roles and the whole cluster with pg_dumpall, and restore them with pg_restore or… Beginner · How-to · Linux Article Backup & restore 15 Oct 2026
- 0203 Physical backups and point-in-time recovery with pg_basebackup and WAL archiving A base backup plus a continuous archive of WAL files lets you restore a PostgreSQL cluster to any moment after the backup,… Advanced · Concept · Linux Article Backup & restore · Replication & high availability 15 Oct 2026
- 0206 Nightly PostgreSQL backup script with pg_dump and rotation A bash script for cron that dumps cluster roles plus every database in custom format into a dated folder, checks each archive,… Intermediate · How-to · Linux Script Backup & restore 15 Oct 2026
- 0213 pgBackRest: backup and restore for PostgreSQL pgBackRest is a widely used PostgreSQL backup tool with parallel full, differential and incremental backups, WAL archiving, encryption and S3, Azure or… Linux Repo Backup & restore 15 Oct 2026
- 0257 Run PostgreSQL properly on a Linux server: install, lock down, back up, monitor and patch Set up PostgreSQL 18 from the official repository for one application: a dedicated role and database, SCRAM logins from one app server… Intermediate · Tutorial · Linux Article Backup & restore · Install & connect · Roles & administration 15 Oct 2026