I created a web application on Azure consisting of a Virtual Machine and a PostgreSQL 10 database. I want to configure the Azure "Backup vault" service to periodically perform a database backup. So, I created the "Backup vault" service and the backup policy as explained in this video guide. However, at the end of the process, the validation of the selected databases fails with the following error:
- Error code: UserErrorBackupUserAuthFailed
- Message: Backup user authentication failed.
- Recommendations: Configure appropriate permissions for the backup user as mentioned at https://aka.ms/osstroubleshooting.
- DetailedNonLocalisedMessage: 28P01: password authentication failed for user "azure_backup"
After reading the "UserErrorBackupUserAuthFailed" chapter of the above guide, I set myself up as the Active Directory admin of the PostgreSQL database. However, the problem persists.