You need the following components when you want to perform PostgreSQL database backup operations on your Azure database:
-
An Azure PostgreSQL instance.
-
A Commvault proxy server that is configured on the CommCell Console and that resides in the Azure cloud.
-
A Commvault Windows or UNIX client that has the Virtualization Agent and the PostgreSQL Agent.
-
An optional on-premises MediaAgent.
Configure one of the following Azure resource deployment models:
When setting up the resource deployment model, assign contributor role to the virtual machine or access node.
If you want to restrict access, you can assign a customized role (CvPostgreSQLRole.json).
User Account Requirements
For DumpBasedBackupSet, verify that the PostgreSQL agent has a user account with sufficient privileges to perform the following:
-
Perform backup and restore operations
-
Access the PostgreSQL database objects as part of the subclient content
The following table illustrates the necessary privileges the user account should have to perform backup and restore operations:
Operations
Privileges PostgreSQL User Should Have
Backup
CREATEDB, CREATEROLE
Restore
CREATEDB, CREATEROLE, INHERIT, LOGIN
CONNECTION LIMIT, if set, should at least have a value of 2.
Initially, the user account credentials are provided during the instance configuration after the installation of the agent. You can change the user account at the instance level.
Data Flow
You can use the Commvault software to back up and restore PostgreSQL data on the Azure Database for PostgreSQL Single Servers and Azure Database for PostgreSQL Flexible Servers.
When you perform a backup operation, the Commvault software invokes the PostgreSQL pg_dump utility to perform the backup operation.
When you perform a restore operation, the Commvault software invokes the PostgreSQL pg_restore utility to restore the data. The destination can be the same Azure database instance, or another Azure database instance.