Help Center/ GaussDB/ User Guide/ Data Backup/ Backup Execution/ Creating a Manual Backup for GaussDB Tables
Updated on 2025-09-05 GMT+08:00

Creating a Manual Backup for GaussDB Tables

Scenarios

GaussDB allows you to create table-level manual backups for available instances. You can use these backups to restore data for ensuring data reliability.

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.
  • Keep your account balance above zero so that table-level backups can be created.
  • 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. For the billing details, see How Is GaussDB Backup Data Charged?

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. For details, see Product Pricing Details.

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.