Restoring from an OCI Database with PostgreSQL Backup

Restore an OCI Database with PostgreSQL database system from an existing backup.

Warning

You might lose data if you restore a database system. We recommend that you create a manual backup of the database system before restoring. For more information, see Creating an OCI Database with PostgreSQL Database System Backup

1. On the Database systems list page, find the database system that you want to work with. If you need help finding the list page or the database system, see Listing OCI Database with PostgreSQL Database Systems.
  The database system's details page opens.
2. From the Actions menu, select Restore.
  The Restore panel opens.
3. Select the backup that you want to restore from.
4. Select Restore.
Use the oci psql db-system restore command and required parameters to restore a database from a backup:
oci psql --db-system-id <db_system_OCID> --backup-id <backup_ocid> [OPTIONS]
To get your backup's OCID, see Listing Backups.

For a complete list of parameters and values for CLI commands, see the CLI Command Reference.
Run the RestoreDbSystem operation to restore a database from a backup.