Protect Your Data with Point-in-Time Recovery
11 March 2025
We're excited to announce the release of Point-in-Time Recovery (PITR), a powerful new feature that adds an extra layer of protection to your Postgres database. With PITR, you can now restore your database to any specific moment in the past, giving you more control and peace of mind when it comes to data protection and disaster recovery.
Why Point-in-Time Recovery Matters
Even the most well-designed applications can face unexpected data issues:
- Accidental data deletion or corruption
- Failed migrations or schema changes
- Data inconsistencies from buggy code deployments
- Malicious actions requiring immediate remediation
While regular daily backups are great to have, they leave you vulnerable to losing hours of potential valuable data. With PITR, you can recover to the exact moment before an incident occurred, minimizing data loss and downtime.
How PITR Works
Point-in-Time Recovery works by continuously archiving database transaction logs, allowing you to restore your database to any specific timestamp within the retention period. The process is simple and can be managed directly from the Nhost Dashboard.
Point-in-Time Recovery
Restore Your Current Project
When you need to roll back your current project, simply:
- Navigate to your project's backups in the Nhost Dashboard
- Select the "Point-in-Time Recovery" tab
- Choose a specific date and time to restore to
- Confirm the restoration
The system will restore your database to the exact state it was in at the selected timestamp, including all tables, relationships, and data.
Point-in-Time Recovery
Import from Another Project
PITR also enables you to import databases across projects within the same organization and region:
- Navigate to your target project's database backups
- Select "Import backup"
- Choose the source project, date, and time
- Confirm the import
Point-in-Time Recovery
This feature is particularly valuable for:
- Creating staging environments with production data
- Testing migrations and updates with real data
- Setting up development environments that closely mirror production
Getting Started with PITR
Point-in-Time Recovery is available on the Pro, Team, and Enterprise plans as an add-on. To enable this feature:
- Upgrade to the Pro plan if you haven't already
- Navigate to your project's database settings
- Enable PITR
The retention period is set to 7 days, giving you a full week of protection and flexibility to restore your database to any point during that timeframe. If you need a longer retention period don't hesitate to reach out to us.
What's Next?
We plan to continue improving our Postgres offering. In the coming months, we'll be looking to:
- Extend the PITR retention period options
- Add scheduled and on-demand backup options
Conclusion
Point-in-Time Recovery represents a significant step forward in our commitment to data security and reliability. With PITR, you can develop and operate your applications with greater confidence, knowing that you can quickly recover from data issues with minimal impact.
We're excited to see how PITR helps you build more resilient applications. As always, we welcome your feedback and suggestions so don't hesitate to reach out to us on Discord.