Oracle Cloud Infrastructure Documentation

Editing the Management Policy of a Database System

Change the management policy of an OCI Database with PostgreSQL database system. The database system management policy specifies its backup and maintenance policies.

For more information, see Managing Backups of an OCI Database with PostgreSQL and Maintenance.
    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: How often a backup is created.
        • Day of the week: The day of the week that the backup is created.
        • Backup start time: 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. 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:

    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.