Skip to content

Instantly share code, notes, and snippets.

View Creamen's full-sized avatar
💐
¡ SEEK FOR TRUTH !

David BARON Creamen

💐
¡ SEEK FOR TRUTH !
View GitHub Profile
@pohzipohzi
pohzipohzi / walg-pitr.md
Last active April 25, 2023 15:47
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
For VLC configure to detect QUIC and HTTP3 libraries
Openssl
./config enable-tls1_3 --prefix=/home/devbox/devel/quic_research/build_openssl
make -j$(nproc)
make install_sw
nghttp3