Skip to content

Instantly share code, notes, and snippets.

View imcitius's full-sized avatar

Ilya Rubinchik imcitius

View GitHub Profile
@imcitius
imcitius / walg-pitr.md
Created September 3, 2019 20:28 — forked from pohzipohzi/walg-pitr.md
PostgreSQL Point-In-Time-Recovery (PITR) with WAL-G

WAL-G PITR

This gist summarises a way to simulate point-in-time recovery (PITR) using WAL-G. Most of the material is adapted from Creston's tutorial.

Setup

First we initialize a database cluster

pg_ctl init -D cluster