Back up universe YSQL data
Use Yugabyte Platform 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 the Backups tab.
-
Click Create Backup to open the Create Backup dialog.
-
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 Yugabyte Platform 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 Yugabyte Platform 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.