In this Azure article, we will discuss the key differences between Azure PostgreSQL Single server and Flexible server. At the end of this article, you will be in a conclusion you wish to go with Azure PostgreSQL Single server or Flexible server.
Azure PostgreSQL Single server vs Flexible server
Here is a tabular comparison between these two servers.
|Azure PostgreSQL Single server||Azure PostgreSQL Flexible server|
|The underlying operating system is Windows.||Here, the underlying operating system is Linux.|
|The uptime is 99.99% SLA.||Here, the uptime is up to 99.99% SLA.|
|The supported versions are 10, 11.||The versions supported here are 11, 12, 13, 14.|
|The available tiers are Basic, Memory Optimized, and General Purpose.||The available tiers are Memory Optimized, General Purpose, and Burstable.|
|Depends on the tiers you are using. For example for the Basic tier, the maximum storage supported is 1 TB, for Memory Optimized tier, it is 16 TB, for General Purpose, it is 4 TB.||The maximum storage size supported is 16 TB.|
|Scalable for all the tiers except the Basic tier.||Scaleable with respect to all the tiers.|
|Not supported.||Supports Burstable SKUs.|
|The networks that are supported here are private link, virtual, and public access.||Here, the supported networks are public access and private access.|
|It supports Private links.||No support for Private links.|
|No supports for Private DNS Zone.||It Supports Private DNS Zone.|
|It supports TLS 1.2.||Whereas here TLS 1.2 and TLS 1.3 both are supported.|
|In terms of cost, it is 1x here.||Here it is based on Compute + Storage which is 2x.|
|Native logical replication is not supported.||It supports native logical replication.|
|In terms of Security, It supports integration with Azure Active Directory.||Still in Preview.|
|SCRAM Authentication is not supported.||It supports SCRAM Authentication.|
|Supports Microsoft Defender for Cloud.||Not supported.|
|Not supported.||Allows you to stop and start the server if required.|
You may also like following the below articles
- How to create Azure Database for PostgreSQL servers
- What is Microsoft Azure and How does Microsoft Azure Works?
In this Azure article, we discussed the key differences between Azure PostgreSQL Single server and Flexible server. Now, it’s up to you to decide which one you wish to use that best suits your requirement. Thanks for your valuable time to read this article !!!!