Creating a Manual Backup for GaussDB Tables

Scenarios

GaussDB allows you to create table-level manual backups for available instances.

Precautions

• You can back up data of instances that are in the Available state.
• A user can perform only one table-level backup operation for a DB instance at a time.
• Tables in the postgres, template0, template1, templatea, and templatepdb system databases cannot be backed up using the table-level backup method.
• Tables in M-compatible databases cannot be backed up using the table-level backup method.
• Tables in system schemas (for example, public) cannot be backed up using the table-level backup method.

  By default, public is a system schema. However, you can run commands to change the owner of public. When the owner is changed to a non-system user, you can back up tables in the public schema.

• When a DB instance is deleted, the automated backups for tables are also deleted, but manual table backups are retained.

Billing

Backups are saved as packages in OBS buckets.

After a DB instance is deleted, the free backup space of the DB instance is automatically canceled. Manual backups are billed based on the space required.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > GaussDB.
4. On the Instances page, click the name of the target instance to go to the Basic Information page.
5. In the navigation pane on the left, choose Backups. On the displayed page, click Table Backup under Full Backups and click Create Backup.
6. Enter the backup name and description, select the required data and click Create Backup.
   • The backup name is case-sensitive and can contain 4 to 64 characters. It must start with a letter. Only letters, digits, hyphens (-), and underscores (_) are allowed.
   • The description can contain up to 256 characters, but cannot contain carriage returns and the following special characters: >!<"&'=
   • During the creation process, the status is Creating. The time required for creating a manual backup depends on the data volume.

7. View and manage the created backup on the current page.

   Alternatively, go back to the instance list page, and click Backups to view and manage the backup.