usererrormissingdbpermissions

Deepak Gupta 15 Reputation points
2024-02-12T06:06:51.0233333+00:00

I have created a backup vault for postgres and created a key vault as well its running for 2 weeks but after 2 weeks scheduled job will fail reason for fails is UserErrorMissingDBPermissions but i can see that i have given permission to db and my keyvault secret is password is same ADO.NET of azure postgres server please give me a reason dont give me that documentation

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,132 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. SadiqhAhmed-MSFT 37,921 Reputation points Microsoft Employee
    2024-02-13T05:20:50.0533333+00:00

    Hello @Deepak Gupta Sorry for the painful experience!

    There is an ongoing issue. Please find the details below:

    Summary: Backups are failing for Azure Database for Postgre SQL Single server with UserErrorMissingDBPermissions error due to a recent deployment by the Postgre SQL team. 

      Impact: All regions impacted.

      Root cause: The Postgre SQL team is analyzing the issue. Root cause is yet to be determined.

      Workaround: Customers can run the below script on the server and retrigger the backup. 

    https://learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql-overview#database-users-backup-privileges-on-the-database

    Update: We advise you to monitor your scheduled and ad hoc backups on Azure Database for PostgreSQL backup and grant the required pre-requisites to resolve the issue with any failing backups, if it is not done already.

    About Azure Database for PostgreSQL backup - Azure Backup | Microsoft Learn Back up Azure Database for PostgreSQL - Azure Backup | Microsoft Learn

    Hope this helps. Please let us know if there are any issue.

    If the response helped, do "Accept Answer" and up-vote it

    0 comments