Distributed Point-in-Time Recovery with Postgres | PGConf.Russia 2018 | Eren Basak

024d6a0dd14fb31c804969a57a06dfbe?s=47 Citus Data
February 06, 2018

Distributed Point-in-Time Recovery with Postgres | PGConf.Russia 2018 | Eren Basak

Postgres has a nice feature called Point-in-time Recovery (PITR) that would allow you to go back in time. In this talk, we will discuss what are the use-cases of PITR, how to prepare your database for PITR by setting good base backup and WAL shipping setups, with some examples. We will expand the discussion with how to achieve PITR if you have a distributed and sharded Postgres setup by mentioning challenges such as clock differences and ways to overcome them, such as two-phase commit and pg_create_restore_point.

024d6a0dd14fb31c804969a57a06dfbe?s=128

Citus Data

February 06, 2018
Tweet