You can perform full backup operation of a database group for PostgreSQL on Azure Database.
Procedure
-
From the navigation pane, go to Protect > Databases.
The database Overview page appears.
-
Go to Instances tab.
-
Click the instance.
The instance Overview page appears.
-
Go to Database groups tab.
-
In the Database groups table, click the database group that you want to back up.
The database group Overview page appears.
-
Click Backup from the upper-right corner of the page.
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.