Skip to main content

Recover to point in time

Point-in-time recovery reconstructs your data as it stood at a moment you choose, down to the second. It is what you want after an incident with a known time, such as a bad migration or an accidental DELETE, where recovering to the last scheduled backup would lose everything since.

It works by replaying archived transaction logs on top of a full backup, which is why both have to be in place before the moment you want to recover to.

note

Supported on PostgreSQL, MySQL, and MariaDB only. On every other engine, Restore from backup is the recovery path.

warning

Recovery creates a new database. It does not overwrite the existing one, so plan for the additional quota and update your application's connection details afterward.

Prerequisites​

  • PITR is enabled on the database. See Enable & Disable PITR.
  • At least one full backup exists, taken after PITR was enabled.
  • The archived logs covering your target time are available.
  • Enough remaining quota for a second database alongside the original.

Recover the database​

  1. Click the database ID, open the Backup tab, then the Restore sub-tab.

  2. Click Recover to point in time.

    Restore Database to a Point in Time dialog with a recovery timestamp field

  3. Fill in the fields:

    • Recovery cluster name: the name for the new database.
    • Flavor: the compute configuration for the new database.
    • Recover to: the exact date and time to recover to.

  4. Click Recover.

The system creates a new database holding your data as it stood at that moment.

warning

You can only recover to a time after the first full backup that followed PITR activation. Until that backup runs, PITR is unavailable, and changes made before it cannot be recovered. Enabling PITR is not the moment protection begins.

Choosing the recovery time​

Pick the last moment you know the data was good, not the moment the problem was noticed. Those are rarely the same, and recovering to the second one brings the problem with it.

If you are unsure, recover to a candidate time, connect to the new database, and check. Recovery does not touch the original, so you can repeat it with a different timestamp as often as you need.

Next steps​