How to enable autobackup for Databases
Backups are logical data dumps of an individual database. They are useful when you need to restore a specific logical database.
For Database Instances that use Block Storage volumes, Managed Database for PostgreSQL and MySQL uses the Snaphots feature to create autobackups. When the autobackup feature is enabled, Managed Database for PostgreSQL and MySQL create and manage backups according to your backup schedule configuration.
You may need certain IAM permissions to carry out some actions described on this page. This means:
- you are the Owner of the Scaleway Organization in which the actions will be carried out, or
- you are an IAM user of the Organization, with a policy granting you the necessary permission sets
- You have an account and are logged into the Scaleway console
- You have a PostgreSQL or MySQL Database Instance
The autobackup feature is enabled by default upon the creation of an Instance. Simultaneously, a backup schedule policy is created. The default backup frequency is of 1 per day and the retention period of 7 days. You can change this default configuration after you create the Instance from the database information page.
- Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.
- Click the database name or «See more Icon» > More info to access the database information page.
- Click «Edit Icon» in the Backup tab to configure the backup frequency and retention.
Although autobackup is enabled by default, you can disable the feature before you create the Instance, by unchecking the box in the creation wizard. You can also disable it after the Instance is ready.
You can restore your backup by following the procedure of how to restore snapshots.