> Expert > Backup and Restore Agents > Databases > Azure Database > Azure Database for PostgreSQL

Azure Database for PostgreSQL Restore Operations

Updated

Your objective for restoring data determine the process you must follow.

Your objective for restoring data determines the process that you must follow and the restore destination.

Objective for the restore operation

Reason

Process

Destination

Restore data that was backed up in the past number of days

The data is in long-term storage based on compliance requirements

  1. Determine the time range.

  2. Browse and restore data based on the number of days that you specify.

This data would be restored to an in-place destination.

Restore data from a specified range of time

The data was accidentally deleted.

  1. Determine the time range.

  2. Browse and restore data based on a time range that you specify.

Typically, this data would be restored to an out-of-place destination.

Restore to a point in time

The database is corrupted or otherwise invalid.

Determine the date and time.

Typically, this data would be restored to an in-place destination.

Restore Destinations

You can restore the data to any of the following destinations:

  • The same Azure database instance

  • An Azure database instance that is different from the source instance

  • An on-premise server

Was this page helpful?