Restore Snapshot
Choose which saved snapshot to copy, where to restore it, and whether to create a database or write into an existing one.
1. Database snapshot source
Only databases with a completed snapshot can be used as a restore source. Registered PostgreSQL databases without a completed snapshot are shown as unavailable.
Choose a registered database to narrow the snapshot list. This is the source; the destination is selected separately below.
2. Snapshot to restore
This is a saved copy of the source database. The source is unchanged unless you explicitly choose it as the existing restore target.
ⓘ
Before restoring, check the PostgreSQL major version on the snapshot source and target. Use the same major version for the most reliable restore; restoring a newer-version snapshot to an older server may fail because it does not support settings or features in the archive.
Snapshot file location
Local or mounted repository
Only “Local or mounted repository” appears until this snapshot has a verified copy on a registered remote server. To add a remote option, register a server in Servers and copy this snapshot there. Remote copies can only restore into a new database.
3. Destination PostgreSQL server
Choose a registered PostgreSQL target. To restore into another existing database, choose “Write into an existing database” below; this list will show registered PostgreSQL databases you can select.
4. What should happen on the destination?
Create a separate new database (recommended)
Write into an existing database
5. Name for the new database
Created on the destination server. Must be a new name that does not already exist there.
⚠
A separate database will be created on the selected destination server. Existing databases, including the snapshot source, are left unchanged.
6. Type RESTORE to confirm