You can use the Commvault software to back up and restore PostgreSQL applications.
For PostgreSQL databases running on virtual machines (VMs), you can perform application-aware backups from a VSA subclient, and restore the database using the PostgreSQL database agent.
VM Group Configuration
-
Place the virtual machines that run PostgreSQL in a dedicated VM group.
-
After you configure the VM group, backups run automatically based on associated plan.
Application Credentials
To perform backup and restore operations for PostgreSQL databases, you must provide valid PostgreSQL database user credentials.
Backup Proxy
For IntelliSnap backups of PostgreSQL databases on VMs, the Access Node selected during the hypervisor configuration is used to perform snapshot operations.
Application-Consistent Backups
-
During an application-aware backup, the software creates a snapshot of the database data.
-
This process ensures the backup is application-consistent (not just crash-consistent) backups, enabling reliable restoration of database transactions.