Scheduling OCI Database with PostgreSQL Backups

• 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 the name of the database for which you want to enable automatic backups.
  4. On the database system details page, select More actions and then select Edit management policy.
  5. In the Edit management policy panel, select Enable automatic backups.
     1. Automatic backups: Select Enable automatic backups to enable automatic backups. If you don't select automatic backups, you must manage backups manually. We recommend that you enable automatic backups. After enabling automatic backups, you can set the following options:
        • Backup frequency: Select how often a backup is created.
        • Day of the (time period): Select the day that the backup is created.
        • Backup start time (UTC): Select the time that the backup is created.
        • Backup retention period (days): Enter a value, in days, that the backup will be retained before it's deleted by the system.
     2. Select Enable backup copy to automatically create copies of the backup in another region.
        • Compartment: Select a compartment for the backup copy.
        • Regions: Select a region or regions for the backup copy.
        • Backup retention period (days): Enter a value, in days, that the backup copy will be retained before it's deleted by the system.
  6. Select Save changes.

• Use the oci psql db-system update command and the --management-policy parameter to update the management policy of a database:

  Command

  CopyTry It

  oci psql db-system update --db-system-id <database_OCID> --management-policy <file://management-policy-details.json>[OPTIONS]

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

• Run the UpdateDbSystem operation with the managementPolicy attribute to update the management policy of the database.

  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.