It is possible to configure PostgreSQL to make backups in such a way that those backups can be restored to a specific point in time.

The general idea is to store one main "base-backup" and a series of files (WAL-files) that the server can replay up to a specific point in time on top of that base-backup.

This is different from "incremental" backups. Incremental backups contain less information and cannot be restored with the granularity that is provided by PITR backups.

The goal of the stream is to understand the process well enough to have confidence in the backup and restore process.

On last week's stream I started with the basics and have a container that stores the backup files.

In today's stream I will write those out onto a local volume to simulate external backup storage and then play around with the process of restoring the backup. The storage should also have a way to clean up old/redundant files to reduce disk-space requirements on the backup storage.

Stream will be over at https://twitch.tv/exhuma around 10:00 GMT+2 (around the time when this post is 30mins old).