Oracle Cloud Infrastructure Documentation

Creating an OCI Database with PostgreSQL Database System Backup

Create an on-demand backup manually of an OCI Database with PostgreSQL database system.

You can also schedule automatic backups of the database system and create backup copies by using its management policy.

Tip

If an automatic backup policy is already enabled for the database, the Console displays the most recent backup and the next scheduled backup.
    1. 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 OCI Database with PostgreSQL Database Systems.
      The database system's details page opens.
    2. Select Create backup.
      The Create backup panel opens.
    3. Enter the following information:
      • Backup name: Enter a name for the backup.
      • Description: (Optional) Enter a description for the backup.
      • Compartment: Select a compartment to contain the backup.
      • Backup retention period (days): Enter the following information:
        • Select number of days: Enter the number of days that the backup is retained until it's deleted.
        • Select date and time: Select the date that the backup will be deleted.
      • Show advanced options: (Optional) Under Tags, select Add tag to apply tagging to your database system.

        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.

    4. Select 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]

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

  • Run the CreateBackup operation to create a backup.