This Azure article will discuss the key differences between Azure PostgreSQL Single server and Flexible server. At the end of this article, you will conclude that 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.|
|The networks supported here are private link, virtual, and public access.||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.|
|No support for Private DNS Zone.||Here, the supported networks are public access and private access.|
|It supports Private links.||No support for Private links.|
|It Supports a Private DNS Zone.||Whereas here, TLS 1.2 and TLS 1.3 both are supported.|
|It supports TLS 1.2.||Here, it is based on Compute + Storage which is 2x.|
|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 articles below
- How to create Azure Database for PostgreSQL servers
- What is Microsoft Azure, and How does Microsoft Azure Work?
This Azure article discussed the key differences between Azure PostgreSQL Single server and Flexible server. Now, deciding which one you wish to use best suits your requirements is up to you. Thanks for your valuable time to read this article !!!!