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. Update any of the following sections:

    Automatic Backups

    Enter or update the following information:

    • Enable automatic backups: Select 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.
    • Enable backup copy: Select 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.

    Point-in-Time Recovery

    Enter or update the following information:

    • Enable point in time recovery: Select to enable the replication of your database system's exact state it had at a specific date and time in the past. After enabling point-in-time recovery, you can configure the following option:
      • Desired restoration days: Enter the number of days the database system's data is retained and can be restored. The maximum number of days you can enter is 35.

      For more information, see Point-in-Time Database System Recovery.

    To disable point-in-time recovery, deselect the option.

    Maintenance

    Enter or update the following information:

    • Maintenance type: Select one of the following options:
      • 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.

      For more information, see OCI Database with PostgreSQL Maintenance.

    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.