You can perform a full backup operation of a Cloud SQL for PostgreSQL database group.
Procedure
-
From the navigation pane, go to Protect > Databases.
The Overview page appears.
-
On the Instances tab, click the instance.
The instance page appears.
-
On the Database groups tab, in the Database groups table, click the database group that you want to back up.
The database group page appears.
-
On the right side of the page, click Backup.
The Backup options dialog box appears.
-
Under Backup level, select Full.
-
Click SUBMIT.
Note
-
If the database part of a database group (other than default) is renamed or removed, the backup content for the database group needs to be updated manually. The old database will not be removed automatically.
-
By default, backup operations using DumpBased backup set do not include information about roles. This is because
pg_dump
utility that is used to perform DumpBased backup operation does not back up roles information. To save this information using thepg_dumpall
utility, enable backups for global objects in PostgreSQL databases.