Adding a PostgreSQL Instance on Azure Database Using Azure Account

You can either use an existing PostgreSQL instance or add a new PostgreSQL instance on Azure Database, using an existing Azure account.

Before You Begin

Configure the permissions to access the Azure resources. Download the AzureDBBackupRole.json file and use it to apply the permissions.

Procedure

1. From the navigation pane, go to Protect > Databases.

   The database overview page appears.

2. From the Add instance list, select Cloud database service.

   The Add Cloud DB instance page appears.

3. Select Microsoft Azure, and then click NEXT.

   The Configure Azure Database page appears.

4. Select PostgreSQL.

   The Configure Azure Database - PostgreSQL page appears

5. In the Plan section, select a backup plan to use for the instance, and then click NEXT.

   The Cloud Account page appears.

6. From the Cloud account list, select an existing cloud account or add a new cloud account, and then click NEXT.

   The cloud account is represented in Commvault as a hypervisor. For instructions to create an Azure hypervisor, see Configuring Backups for Azure Virtual Machines.

   Steps to add new cloud account:

   1. Beside the Cloud account list, click +.

      The Add cloud account dialog box appears.

   2. In the Name box, type the name for the account.

   3. Enter information about the subscription:

      • For the traditional authentication method of deployment, enter the following information:

        • Subscription ID: Enter the subscription ID for the Azure account.

        • Credential: If you have already configured the credentials entity, select the credentials from the list. To define a new credential, click + beside the list. For more information, see Adding credential.

      • For the managed identity authentication method of deployment, configure the following settings:

        • Connect using managed identities for Azure resources: Move the toggle key to the right.

        • Subscription ID: Enter the subscription ID for the Azure account.

   4. From the Access node list, select access nodes that have both the Virtual Server and Cloud Apps packages installed.

      Note

      If you configure this cloud account to use managed identity authentication, select only Azure access nodes that use managed identity authentication so that backups and restores will be successful. The access node must be an Azure virtual machine in the same subscription that contains the Cosmos DB account that you want to back up.

   5. Click SAVE.

7. Click NEXT.

   The Backup Content page appears.

8. To configure the rule criteria for automatic discovery of instances to back up, do the following:

   1. Move the Rule based discovery toggle key to right.

   2. From the Access node list, select an access node which runs the discovery job.

      Note

      All the access nodes must have VSA package installed for PostgreSQL and cloud applications.

   3. Under Content section, from the Add drop-down list, you can use the following two ways to add the instances:

      • Rule group

      • Cloud DB instances

   4. If you select Rule group, do the following:

      1. Click Rule group.

         The Add rule group dialog box appears.

      2. From Match rule section, you can select either all or any as per requirement.

         • All: Each rule defined by the user must be satisfied for a database instance to be discovered.

         • Any: If any database instance satisfies at least one of the defined rules, it is discovered.

      3. Click Add.

      4. Click Save.

   5. If you select Cloud DB instances, do the following:

      1. Click Cloud DB instances.

         The Add Cloud DB instances dialog box appears.

      2. From the instance list, select the instances for which you want to create the rules.

      3. Click Save.

   6. From the Credential list, select an existing credential or add a new credential. The selected credential is used for all the added instances.

   7. Click Next.

9. To manually select an instance to back up, move the Rule based discovery toggle key to the left, and do the following:

   1. From the Instance name list, select an instance.

   2. Under the Connection details section, enter the following details:

      1. From the Credential list, select a saved credential or add a new credential.

         Steps to add a new credential

         1. Click the + icon beside the Credentials list.

            The Add Credential dialog box appears.

         2. From Account type list, select a database account.

         3. From the Database type, select a database.

         4. From the Credential Vault list, select a credential vault to store credentials for different types of accounts.

         5. In the Credential name box, enter a name for the credential.

         6. Under the Azure AD/AWS IAM Authentication section, enter the following details:

            • In the Username box, enter the user name to access the Azure Database for PostgreSQL application.

            • In the Password box, enter the password to access the Azure Database for PostgreSQL application.

            Note

            If you move the Azure AD/AWS IAM Authentication toggle to right, you only need to enter the user name detail.

         7. The SSL certificate toggle key is unselected by default. By moving the toggle key to right, you can perform the following actions:

            • In the SSL CA file field, provide the SSL CA file path on the proxy computer.

            • In the SSL Cert file field, provide the SSL certificate file path on the proxy computer.

            • In the SSL Key file field, provide the SSL key file path on the proxy computer.

         8. In the Description box, enter the details of the credential.

         9. Click Save.

      2. In the Maintenance DB box, type the name of the system database that is used as the maintenance database.

      3. In the Endpoint box, type the name of the endpoint to connect to the database instance.

10. Click Next.

    Tip

    For Azure Single servers, enter the user name in the syntax username@hostname.

11. To filter the content that is backed up, click Edit, select or clear the tables, and then click Save.

    The Summary page appears.

12. Review the summary, and then click Finish.

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.