In our effort to keep making it easier to maintain a rigorous disaster recovery posture on Aptible, we've added Point-in-time Recovery (PITR) capabilities for Aptible Managed PostgreSQL databases, at no additional charge.

PITR is enabled by default for all PostgreSQL databases (with a few exceptions noted in our docs, like EOL versions or databases with backups disabled). Some databases must be restarted in order to (automatically) enable PITR; for other databases, PITR is already enabled. To check whether PITR is enabled for any of your PostgreSQL databases, refer to the Backups column on the Databases list view, or the Point-in-Time Recovery attribute on any database's detail page.

To restore any PITR-enabled database to a specific point in time in a new database, visit the Recovery tab on that database's detail page, and provide: a name for the new database, and the timestamp to which you'd like to restore. Currently, we limit PITR restores to timestamps in the last 24 hours. If your use case requires restoring to a point in time older than 24 hours, please let us know in Slack or via a support ticket.

If you have any questions about how PITR works or how to use it, check out our docs on PITR!