Logical Backup

Availability

This feature is available since openGauss 1.0.0.

Introduction

Data in user tables in the database is backed up to a specified storage medium in a general format.

Benefits

Through logical backup, you can achieve the following purposes:

Back up user data to a reliable storage medium to secure data.
Support cross-version recovery and heterogeneous recovery using a general data format.
Archive cold data.

Description

openGauss provides the logical backup capability to back up data in user tables to local disk files in text or CSV format and restore the data in homogeneous or heterogeneous databases.