Oracle Cloud Infrastructure Documentation

Scheduling OCI Database with PostgreSQL Backups

Schedule automatic backups of an OCI Database with PostgreSQL database system.

Use the database's management policy to enable automatic, scheduled backups of a database. The management policy lets you specify the backup frequency, run time, and the retention period of the backups.

When you schedule automated backups, you can also specify that copies of the backup are distributed to another region. You can use a backup that's been replicated to a second region to provision a database system if the primary database system is unavailable.

    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 for which you want to enable automatic backups.
    4. On the database system details page, select More actions and then select Edit management policy.
    5. In the Edit management policy panel, select Enable automatic backups.
      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 create copies of the backup in another region.
        • 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.
    6. Select Save changes.

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

    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.

    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.