Back up universe YSQL data
You can use YugabyteDB Anywhere to back up your YugabyteDB universe YSQL data.
To schedule backups for a later time or as a recurring task, see Schedule universe YSQL data backups.
To immediately back up your YugabyteDB universe YSQL data, perform the following:
-
Open your universe and select Backups.
-
Click Create Backup to open the Create Backup dialog shown in the following illustration:
-
Complete the fields presented in the YSQL tab.
Notice that the contents of the Storage field list depends on your existing backup storage configurations.
-
Click OK.
If the universe has encryption at rest enabled, data files are backed up as-is (encrypted) to reduce the computation cost of a backup and to keep the files encrypted. A universe key metadata file, containing key references, is also backed up. To allow YugabyteDB Anywhere to back up your data with the user authentication enabled, follow the instructions provided in Edit configuration flags to add the ysql_enable_auth=true
and ysql_hba_conf_csv="local all all trust"
YB-TServer flags.
Note
Versions of YugabyteDB Anywhere prior to 2.11.2.0 do not support backups of YSQL databases that useenum
types. To mitigate the issue, it is recommended that you use the ysql_dump
utility in combination with the /COPY
action as a workaround.