Oracle Cloud Infrastructure Documentation

Editing the Management Policy of an OCI Database with PostgreSQL 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 OCI Database with PostgreSQL Database System Backups and OCI Database with PostgreSQL Maintenance.
    1. On the Database systems list page, select the database system that you want to work with. If you need help finding the list page or the database system, see Listing OCI Database with PostgreSQL Database Systems.
      The database system's details page opens.
    2. From the Actions menu, select Edit management policy.
      The Edit management policy panel opens.
    3. Enter the following information:
      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 OCI Database with PostgreSQL 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.
    4. 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 <db-system_OCID> --management-policy <file://management-policy-details.json>[OPTIONS]

    To get your database system's OCID, see Listing Database Systems.

    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.