Company
Date Published
Author
Angelico de los Reyes
Word count
529
Language
English
Hacker News points
None

Summary

When we announced Point-in-Time a few months ago, it was only available for Enterprise customers. Today, we're making PITR available for more projects, with a new Dashboard UI that makes it simple to use. Pro Plan projects created from August 2022 onwards can now enable Point In Time Recovery (PITR) from the dashboard, and older projects will be made available in the future. PITR provides the ability to restore a database to any specified point in time, useful for averting disasters or recovering from data loss. The feature uses a combination of physical backups and archives from the Write Ahead Log (WAL) to achieve this. When deciding whether to enable PITR, consider your Recovery Point Objective (RPO), which is the threshold for how much data a business can lose in case of disaster. Enabling PITR allows for shorter RPOs by backing up WAL files at two-minute intervals, and retention periods can be increased via self-serve. The new Dashboard UI makes it simple to use PITR, and older projects will be made available in the future.