Skip to content

Latest commit

 

History

History
59 lines (50 loc) · 2.47 KB

concepts-limits.md

File metadata and controls

59 lines (50 loc) · 2.47 KB
title description services author ms.author manager editor ms.service ms.topic ms.date
Limitations in Azure Database for PostgreSQL
This article describes limitations in Azure Database for PostgreSQL, such as number of connection and storage engine options.
postgresql
rachel-msft
raagyema
kfile
jasonwhowell
postgresql
article
12/03/2018

Limitations in Azure Database for PostgreSQL

The following sections describe capacity and functional limits in the database service.

Maximum connections

The maximum number of connections per pricing tier and vCores are as follows:

Pricing Tier vCore(s) Max Connections
Basic 1 50
Basic 2 100
General Purpose 2 150
General Purpose 4 250
General Purpose 8 480
General Purpose 16 950
General Purpose 32 1500
General Purpose 64 1900
Memory Optimized 2 300
Memory Optimized 4 500
Memory Optimized 8 960
Memory Optimized 16 1900
Memory Optimized 32 3000

When connections exceed the limit, you may receive the following error:

FATAL: sorry, too many clients already

The Azure system requires five connections to monitor the Azure Database for PostgreSQL server.

Functional limitations

Scale operations

  • Dynamic scaling to and from the Basic pricing tiers is currently not supported.
  • Decreasing server storage size is currently not supported.

Server version upgrades

  • Automated migration between major database engine versions is currently not supported. If you would like to upgrade to the next major version, take a dump and restore it to a server that was created with the new engine version.

VNet service endpoints

  • Support for VNet service endpoints is only for General Purpose and Memory Optimized servers.

Restoring a server

  • When using the PITR feature, the new server is created with the same pricing tier configurations as the server it is based on.
  • The new server created during a restore does not have the firewall rules that existed on the original server. Firewall rules need to be set up separately for this new server.
  • Restoring a deleted server is not supported.

Next steps