Oracle Cloud Infrastructure Documentation

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.
    1. Open the navigation menu and click Databases. Under PostgreSQL, click DB Systems.
    2. (Optional) In the List scope section, under Compartment, select a compartment.
    3. Click the name of the database system that you want to edit.
    4. On the DBSystem details page, click Restore.
    5. In the Restore window, choose the backup that you want to restore from.
    6. Click 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]

    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.