Azure Database for PostgreSQL - Known issues and limitations

APPLIES TO: Azure Database for PostgreSQL - Single Server

Important

Azure Database for PostgreSQL - Single Server is on the retirement path. We strongly recommend that you upgrade to Azure Database for PostgreSQL - Flexible Server. For more information about migrating to Azure Database for PostgreSQL - Flexible Server, see What's happening to Azure Database for PostgreSQL Single Server?.

This page provides a list of known issues in Azure Database for PostgreSQL that could impact your application. It also lists any mitigation and recommendations to work around the issue.

Intelligent Performance - Query Store

Applicable to Azure Database for PostgreSQL - Single Server.

Applicable Cause Remediation
PostgreSQL 9.6, 10, 11 Turning on the server parameter pg_qs.replace_parameter_placeholders might lead to a server shutdown in some rare scenarios. Through Azure Portal, Server Parameters section, turn the parameter pg_qs.replace_parameter_placeholders value to OFF and save.

Next steps