'No Data encryption option for Azure Database for PostgreSQL
Based on this documentation of Azure, there should be a Data encryption option under Security. But I don't see any option of Security.
Is there a way to enable that option?
Solution 1:[1]
I found the answer on the Microsoft forum:
This feature is available in all Azure regions where Azure Database for PostgreSQL Single server supports General Purpose and Memory Optimized pricing tiers.
I was selecting Basic pricing tier, that's why there was no option appearing.
Solution 2:[2]
While deploying the Azure PostgreSQL single server, in Additional settings you can see below statement:
The storage used for database and backup is encrypted by default with service managed keys. Infrastructure Double Encryption is an additional infrastructure encryption layer using a secondary service managed key. Turning it ON can impact database performance.
Therefore, you don't need additional encryption for your data.
If you want double encryption for really sensitive data, you can enable Infrastructure double encryption option.
You can also refer my answer on this SO thread if you need to implement SSL certificate in Azure PostgreSQL account.
Solution 3:[3]
in my case the problem was the storage. Data Encryption is possibile only for storage until 16TB and not for 4TB
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | ARKhan |
| Solution 2 | UtkarshPal-MT |
| Solution 3 | Fiore |