This ariticle will guide us how to do long-term backup (more than 35 days) on Azure PostgreSQL Flexible.
- A Postgres flexible server and an Azure VM (Linux (ubuntu 20.04)) that has access to it.
- A MI (Managed Identity) in your subscription.
- Please kindly make sure backup Postgres flexible server version align with pg_dump version.
Here is the sample code of Azure PostgreSQL Flexible long term backup with Managed Identity.
echo 'start program'
We would make sure the Authentication setting that was PostgreSQL and Azure Active Directory authentication.
Selected which managed identity you want to add to the PostgreSQL flexible server.
When we had added managed identity in Azure portal that will add the managed identity in the PostgreSQL server.
In below script, we need to replace
<<MI client ID>> by your MI Client Id and replace by your login MI as red frames that would tell Azure PostgreSQL server verify MI user by access token instead of user password.
After we replace all content by your really connect information that I pointed out, we can try to run the script and the backup file would be back up by pg_dump without password.
If you’re using User assigned managed identity, please add the identity in
User assigned configuration of your Linux VM as shown below (choose which MI you want to use to verify.)
Please following the step “Managed Identities -> Azure role assignments -> Add role assignment (Preview)” to choose which Blob storage you want to mounted and verified by the MI.
Edit the storage account information which mark as red frame from the script which I provided to you.
- AccountName: blob Account Name
- AuthType: auth type must be MSI
- IdentityObjectId: Filled with your managed identity object it as below red arrow.
- ContainerName: blob Container Name
After the execution, you could see the dump file has successfully uploaded to storage account.
版權聲明：本博客所有文章除特別聲明外，均採用 CC BY-NC-SA 3.0 TW 許可協議。轉載請註明出處！