Editing the Management Policy of a Database System

• 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 system that you want to edit.
  4. On the database system details page, select More actions and then select Edit management policy.
  5. In the Edit management policy panel, make selections for the following:
     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 copy backups to another region. After enabling backup copies, you can set the following options:
        • 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.
     3. Maintenance: Select a Maintenance type option. For more information, see Maintenance.
        • Set by Oracle: Oracle chooses the best day and time to start any essential maintenance.
        • Schedule your own maintenance: Specify the day of the week and the maintenance start time (in UTC timezone) that you want to schedule any essential maintenance activity, such as OS or instance upgrades. If you don't specify a day and time, Oracle chooses it for you.
  6. Select Save changes to update the database system management policy.

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

  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 TBD attribute to update the management policy of the database system.

  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.