You can restore PostgreSQL databases.
Restore Objectives
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. |
|
Typically, this data is restored to an in-place destination. |
Restore data from a range of time |
The data was accidentally deleted. |
|
Typically, this data is 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 is restored to an in-place destination. |
Restore Destinations
You can restore the data to any of the following destinations:
-
The same instance
-
A different instance
-
An on-premise server
Database Versions
You can restore to a database server that runs the same version or higher than the database version on the source client.