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.
You might lose data if you restore a database system. We recommend that you create a manual backup of the database system before restoring.
- Open the navigation menu and select Databases. Under PostgreSQL, select DB Systems.
- (Optional) In the List scope section, under Compartment, select a compartment.
- Select the database system that you want to restore.
- On the database system details page, select More actions, then select Restore.
- In the Restore window, choose the backup that you want to restore from.
- Select Restore.
Use the
oci psql db-system restorecommand and required parameters to restore a database from a backup:oci psql --db-system-id <db_system_OCID> --backup-id <backup_OCID> [OPTIONS]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.
For information about using the API and signing requests, see REST API documentation and Security Credentials. For information about SDKs, see SDKs and the CLI.