Configuring a PostgreSQL Server Instance for an Azure Database

After you add the PostgreSQL agent to the Azure virtualization client, you can configure the instance endpoint. The VM instance must have access to the Azure service endpoints.

Procedure

1. From the CommCell Browser, expand Client Computers > client > PostgreSQL.

2. Right-click the agent, point to All Tasks > New PosgreSQL Instance.

   The PostgreSQL Create Instance dialog box appears.

3. On the General tab, make the following selections:

   1. From the Instance Name list, select the Azure database instance.

   2. In the Endpoint box, type the endpoint that you use to connect to the Azure PostgreSQL database.

      The endpoint includes the DNS names and the port number, for example, postgresqldb.example.eu-central-1.abc.Azure.com:5432.

   3. In the PostGres User Name box, type the credentials for a user that has permissions to perform backup and restore operations on the Azure database.

      For PostgreSQL Single Server, enter the user name in the following format: username@hostname.

   4. To use Active Directory authentication for database user, select the Use AD authentication check box.

      Note

      Commvault identifies the authentication type that is selected at the cloud account level to authorize the database user.

   5. If you are not using the AD authentication, in the PostGres User Password and PostGres Confirm Password boxes, enter the password for the PostgreSQL database user.

   6. In the Maintenance DB box, type the database that the PostgreSQL pgAdmin command connects to.

   7. If SSL is enabled on the cloud, select the Use SSL options check box, and then in the SSL CA file box, enter the SSL CA file path in the client computer.

   8. Select a storage policy.

4. Click OK.