Server parameter 'connection_throttling' should be enabled for PostgreSQL Database Server

azure.dbforpostgresql
This page is not yet available in Spanish. We are working on its translation.
If you have any questions or feedback about our current translation project, feel free to reach out to us!

Description

Enabling connection_throttling helps the PostgreSQL Database to set the verbosity of logged messages. This in turn generates query and error logs with respect to concurrent connections that could lead to a successful Denial of Service (DoS) attack by exhausting connection resources. A system can also fail or be degraded by an overload of legitimate users. Query and error logs can be used to identify, troubleshoot, and repair configuration errors and sub-optimal performance.

Remediation

From the console

  1. Log in to Azure Portal.
  2. Go to Azure Database for PostgreSQL server.
  3. For each database, click Server parameters.
  4. Search for connection_throttling.
  5. Click ON and save.