AnalyticDB for PostgreSQL in Serverless mode V1.0.0.0 and later provide the backup and restoration feature. This feature is enabled by default. After instance data is deleted, the data is automatically archived and retained for a period of time based on a backup policy before it is eventually deleted.
Billing
The backup and restoration feature is not separately billed. Backup data uses disk storage and may incur storage fees. For more information about the billing methods and pricing of disk storage, see Pricing.
Backup policy
AnalyticDB for PostgreSQL in Serverless mode performs incremental backup for data that is added or deleted within a backup cycle without compressing the data. The default backup cycle is seven days, and the ratio of backup to data storage is about 68%. For example, assume that an instance contains 1 TB of basic data and 100 GB of data is updated every day. Seven days later, the instance has 1 TB of basic data and 700 GB of backup data.
You can execute the following statement to query the retention period of the backup data:
SHOW rds_cn_vacuum_archive_storage_life;
To change the retention period of the backup data, Submit a ticket.
View backup records
Connect to the AnalyticDB for PostgreSQL in Serverless mode instance and execute the following statement in the postgres database:
SELECT * FROM adbpg_tabbak.adbpg_basebackup_task;
The following table describes the columns in the adbpg_basebackup_task table.
Column | Data type | Description |
---|---|---|
task_id | text | The ID of the task. |
sched_id | text | The sched_id of the task. |
start_time | timestamptz | The start time of the backup.
Note The start time of the backup is the point in time to which the data can be restored.
|
end_time | timestamptz | The end time of the backup. |
backupgroup | int | The backup group. The base backup and the subsequent log backups belong to the same backup group. |
parent_task_id | text | The ID of the parent task. |
task_type | char | The backup type. Valid values:
|
failed | boolean | Specifies whether the backup has failed. Valid values:
|
Restore data
AnalyticDB for PostgreSQL in Serverless mode does not allow you to restore data on your own. If you want to restore data, you must Submit a ticket to contact the technical support personnel.