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.
- On the Database systems list page, select the database system that you want to work with. If you need help finding the list page or the database system, see Listing Database Systems.
- 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.