PostgreSQL Backup & Point-In-Time Recovery

Описание

To get the commands used in this tutorial, visit: https://www.scalingpostgres.com/tutorials/postgresql-backup-point-in-time-recovery.

Learn how to take a physical backup of an entire PostgreSQL database cluster and then restore it to a specific point in time. Also known as Point-In-Time Recovery or PITR. We not only show you the backup process but the restore process as well. We also highlight some differences between PostgreSQL 10 and PostgreSQL 9.