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.
Today I was also facing the same problem, after digging into few MSDN documentation I fixed it.
You need to run 1 script as per suggested by MSDN. As per documentation they have attached one document file. Which is having proper steps to solve this issue.
Please make sure that you have installed azure-cli in your machine.
If you face any error like: .ps1 is not digitally signed. The script will not execute on the system
Please refer this link