RDS-Style Point-in-Time Recovery for Self-Hosted PostgreSQL
One of the features I always found most impressive in RDS was point-in-time recovery. Throughout my career I'd never had an opportunity to work deeply with database administration, so the ability to roll back the state of a database to an exact moment seemed at least magical. Recently I finally had a chance to set up such a feature for our own databases, and today I'm going to share my experience with it and how it's done.