I have managed to create Postgres database in Azure using Azure Services for Postgres. I have a function which connects to Postgres using pg package. Configuration of postgreq is disabled but while connecting via Javascript, it is throwing error if SSL value is false and also the weird thing is that if I make the SSL value as "True", when SSL is disabled, my function is running successfully. Have anyone faced the same issue or is it something which is under review by MSFT team

We need to run regular maintenance tasks on our database, which we usually perform with pgagent https://www.pgadmin.org/docs/pgadmin3/1.22/pgagent.html

Pgagent will be installed as a service on the application server, but for pgagent to work we need the pgagent extension deployed in the application database, see also https://www.pgadmin.org/docs/pgadmin3/1.22/pgagent-install.html#database-setup

Please add dblink extension

I would like Azure to be the first cloud service to support the Pl/Pythonu extension. There are security risks involved with supporting this extension, so innovation will be needed, but I believe there is a huge machine learning community that would enjoy it if they could run Python code close to their data.

When will this be available in region germanycentral?

Support temporal tables extension to provide part of the features similar to SQL Server Temporal Tables.

There are great ways to manage the PostgreSQL in Azure via the Azure CLI. https://docs.microsoft.com/en-us/azure/postgresql/sample-scripts-azure-cli.

It would be great to get this possibility as well in Powershell

We would love to use Azure Database for PostgreSQL if it was available in either (both) of the Australia East or Australia Southeast regions.

No way anyone can trust the HA approach unless its somewhat documented? Is it syncronous, semi? Does it occur through PG replication, if so what type? Is it block level with a warm standby? How does failover occur? Do clients need to worry about failover? How long does failover usually take. Promising a PG HA solution without some type of information such as this is not professional.

It would have been great if the user could choose collation on first-time set-up.

As known from the MS SQL Database service, there should be an option to enable other Azure Services (e.g. Web Apps) to connect the database without white-listing every single IP.

Add PGAudit extension

https://www.pgaudit.org/

Support TimescaleDB extension to postgresql
https://github.com/timescale/timescaledb

When I tried to insert XML data, following error occurs and cannot insert XML data to Azure Database for PostgreSQL.

Errors:
BaseMessage:unsupported XML feature
Detail:This functionality requires the server to be built with libxml support.
Hint:You need to rebuild PostgreSQL using --with-libxml.

From the error message, we need to rebuild the PostgreSQL with libxml option, but I don’t think Azure Database for PostgreSQL have such a feature right now.
Please add the feature so that we could migrate our application to "Azure Database for PostgreSQL."

https://github.com/pramsey/pgsql-ogr-fdw

OGR is the vector half of the GDAL spatial data access library. It allows access to a large number of GIS data formats using a simple C API for data reading and writing.

Make azure postgresql databases available to the vast community of Cloudfoundry and it's java applications.

Request for support for the pgpointcloud extension in Azure PostgreSQL databases.

https://github.com/pgpointcloud/pointcloud

Would also be useful to have the optional compression features included. These require libght (https://github.com/pramsey/libght/) and lazperf (https://github.com/hobu/laz-perf).

Join the PostgreSQL server to a Vnet so we can avoid the requirement to expose a public IP address to the wider internet. Or, create a setting to allow just access from a given App Service.