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 click Databases. Under PostgreSQL, click Databases.
    2. (Optional) In the List scope section, under Compartment, select a compartment.
    3. Click the name of the database system that you want to edit.
    4. On the DBSystem details page, click More actions and choose 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 this option, you can set the backup frequency.
      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. Click 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 managementPolicy 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.