To manage a database, you can either use an existing instance or add a new instance.
Before You Begin
Configure the permissions to access the Azure resources. Download the CvPostgreSQLRole.json file and use it to apply the permissions.
Procedure
-
From the navigation pane, go to Protect > Databases.
The Instances page appears.
-
Click Add instance, and then select Cloud DB.
The Add Cloud DB instance dialog box appears.
-
From the Select vendor list, select Microsoft Azure.
-
From the Database service list, select PostgreSQL.
-
From the Cloud account list, select an existing cloud account or create a new cloud account.
The cloud account is represented in Commvault as a hypervisor. For instructions to create an Azure hypervisor, see Configuring Backups for Azure Virtual Machines.
-
From the Backup plan list, select a server plan.
-
From the Instance name list, select an instance.
-
In the Database user box, type the user name to access the Azure Database for PostgreSQL application.
-
To use Active Directory authentication for database user, move the Use AD authentication toggle key to the right.
Note
Commvault identifies the authentication type that is selected at the cloud account level to authorize the database user.
-
If you are not using the AD authentication, in the Password box, type the password to access the Azure Database for PostgreSQL application.
-
In the Maintenance DB box, type the name of the system database that is used as the maintenance database.
-
If SSL is enabled on the cloud, move the Use SSL options toggle key to the right, and then in the SSL CA file box, enter the SSL CA file path in the proxy computer.
-
Click Add.
Tip
For Azure Single servers, enter the user name in the syntax username@hostname.
Results
-
The new instance contains a dump-based backup set and a default subclient.
-
When you add an instance, a default database group is automatically created. The default database group includes all the data in the PostgreSQL database. You cannot delete the default database group.