您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

Azure Database for PostgreSQL - 单一服务器中的限制Limitations in Azure Database for PostgreSQL - Single Server

下列各部分介绍数据库服务中的容量和功能限制。The following sections describe capacity and functional limits in the database service. 如果你想要了解有关资源 (计算、 内存、 存储) 层的信息,请参阅定价层一文。If you'd like to learn about resource (compute, memory, storage) tiers, see the pricing tiers article.

最大连接数Maximum connections

每个定价层的最大连接数和 vCore 数如下所示:The maximum number of connections per pricing tier and vCores are as follows:

定价层Pricing Tier vCore(s)vCore(s) 最大连接数 Max Connections
基本Basic 1 5050
基本Basic 22 100100
常规用途General Purpose 22 150150
常规用途General Purpose 44 250250
常规用途General Purpose 88 480480
常规用途General Purpose 1616 950950
常规用途General Purpose 3232 15001500
常规用途General Purpose 6464 19001900
内存优化Memory Optimized 22 300300
内存优化Memory Optimized 44 500500
内存优化Memory Optimized 88 960960
内存优化Memory Optimized 1616 19001900
内存优化Memory Optimized 3232 19001900

当连接数超出限制时,可能会收到以下错误:When connections exceed the limit, you may receive the following error:

严重:很抱歉,客户端数过多FATAL: sorry, too many clients already

Azure 系统需要使用五个连接来监视 Azure Database for PostgreSQL 服务器。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 服务终结点VNet service endpoints

  • 只有常规用途和内存优化服务器才支持 VNet 服务终结点。Support for VNet service endpoints is only for General Purpose and Memory Optimized servers.

还原服务器Restoring a server

  • 使用 PITR 功能时,将使用与新服务器所基于的服务器相同的定价层配置创建新服务器。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.

Windows 上的 UTF-8 字符UTF-8 characters on Windows

  • 在某些情况下,Windows 上的开源 PostgreSQL 不完全支持 UTF-8 字符,这会影响 Azure Database for PostgreSQL。In some scenarios, UTF-8 characters are not supported fully in open source PostgreSQL on Windows, which affects Azure Database for PostgreSQL. 有关详细信息,请参阅 postgresql-archive 中的 Bug #15476 上的话题。Please see the thread on Bug #15476 in the postgresql-archive for more information.

后续步骤Next steps