Oracle Cloud Infrastructure Documentation

Backing Up a Database System Manually

Backup an OCI Database with PostgreSQL.

You can also schedule automatic backups of the database by using its management policy. If an automatic backup policy is enabled for the database, the Console displays the most recent backup and the next scheduled backup.
    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 back up.
    4. On the DBSystem details page, click Create backup.
    5. In the Create PostgreSQL database backup window, provide values for the following:
      • Backup name: Enter a name for the backup.
      • Description: Enter a description for the backup.
    6. Compartment: Select a compartment to contain the backup.
    7. Backup retention period (days):
      • Select number of days: Enter the number of days that the backup is retained until it's deleted.
      • Select end date: Choose the date that the backup will be deleted.
    8. (Optional) Show advanced options for the backup: If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. For more information about tagging, see Resource Tags. If you're not sure whether to apply tags, skip this option or ask an administrator. You can apply tags later.
    9. Click Create backup.

  • Use the oci psql backup create command and required parameters to create a backup:

    oci psql backup create --compartment-id <compartment_OCID> --db-system-id <db_system_OCID> --display-name <backup_display_name> [OPTIONS]

    Use the oci psql backup update command and required parameters to update a backup:

    oci psql backup update --backup-id <backup_OCID>

    For a complete list of parameters and values for CLI commands, see the CLI Command Reference.

  • Run the CreateBackup operation to create a backup. Use UpdateBackup to update 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.