Backing Up a Database System Manually

• Console
• CLI
• API

• 1. Open the navigation menu and select Databases. Under PostgreSQL, select DB Systems.
  2. (Optional) In the List scope section, under Compartment, select a compartment.
  3. Select database system that you want to back up manually.
  4. On the database system details page, select Create backup.
  5. In the Create backup panel, 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 date and time: 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. Select Create backup.

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

  Command

  CopyTry It

  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:

  Command

  CopyTry It

  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.