Efficient Point-in-Time Recovery in PostgreSQL

Businesses rely on the availability of their applications and underlying data. In fact, 93% of companies responding to a recent survey state rate data as critical to their business success. If your application is unavailable due to unplanned downtime, the cost implications to your company can be extreme.

Point-In-Time-Recovery (PITR) is always an option for PostgreSQL when somebody has accidentally performed some change and would like to revert it back. Without PITR, you will lose all data added to your database since the last full backup.

This white paper discusses the importance of PITR, and how PostgreSQL can be configured to effectively manage PITR strategies.

Our White Papers are free. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.