Oracle Cloud Infrastructure Documentation

Managing Backups of an OCI Database with PostgreSQL

Create, schedule, and restore from OCI Database with PostgreSQL backups.

Backups are a copy of the database data that's taken and stored remotely so that it can be used to restore the original if needed, such as after a data loss event. Backups can be created manually or automated through a management policy.

Automatic backups can be scheduled to be created daily, weekly, and monthly. Automatic backups have a retention period of up to 35 days before they're deleted by the system. When you create a backup manually, you can decide whether the backup is deleted on a specific date, or deleted after a specified number of days.

Note

Billing for the backup starts after it's created.

Required IAM Policy

The following policy statements allow a group of administrators to manage OCI Database with PostgreSQL database backups:

Allow group <postgresql-admin-group> to read compartments in tenancy
Allow group <postgresql-admin-group> to manage postgres-backups in [ tenancy | compartment <compartment_name> | compartment id <compartment_OCID> ]
Allow group <postgresql-admin-group> to read postgres-db-systems in [ tenancy | compartment <compartment_name> | compartment id <compartment_OCID> ]
Allow group <postgresql-admin-group> to use tag-namespaces in tenancy

For more information, see OCI Database with PostgreSQL Policies.