Implementing data synchronization that requires usage of
"pgxactcommittimestamp". Enabling this requires "trackcommit_timestamp" configuration parameter to be set which is currently unavailable for Azure PostgreSQL.

Hello,
It could be great to create user from az cli like
"az postgres users create" The purpose of this feature allow me to create users automatically for a private postgres (without accessing the postgres from an outside machine or create a vm on the same subnet as my AKS)

I would like to create several users, register them on k8s/secrets and run my software (and automatise these actions)

currently in Azure PostgreSQL database,

pgstatssl view shows all connections from client as encrypted, which is false.

I asked Azure support and the answer is because the client is connecting to a gateway instead of real server, and the gateway always connect to backend server encrypted, so pgstatssl is always showing the connection as encrypted.

This defeated the purpose of pgstatssl view. I think it should be considered as a defect of Azure PostgresSQL .

I'm a bit surprised to see that there is no support for multi master replication of postgres databases on Azure.

This should have been considered when other replication features were requested and implemented.

Please add support for multi master replication between any region without the arbitrary notion of partner and universal regions.

It can be a lot of overhead fetching the data and then send to ES

pg_audit bugged?

tried following the instructions to add the extension, I get error:

The value 'pgaudit,timescaledb' for configuration 'sharedpreloadlibraries' is not valid. The allowed values are ', timescaledb'.

To be able to script the creation of a PostgreSQL Database, it could be great if it was possible to set the Azure AD admin with an API or Az CLI.

Thanks,

I wan to use debezium postgresql connector to my Azure database for postgresql . For that I need to set wal_level to logical but I dont find such server parameter.

Would be helpful to monitor and pull statistics for queries executed on replica in Query Performance Insights. Currently its not allowed for replica's as the query data store in Azure_sys Database is also replicated from master.

As described in this issue (I won't rewrite the whole request again): https://github.com/MicrosoftDocs/azure-docs/issues/35906

Azure's postgres PaaS is broken for the enterprise without this feature. I consider lack of this option a defect, not a feature request but am logging it here as directed.

RUM indexes are better suited for full-text search on PostgreSQL: https://akorotkov.github.io/blog/2018/05/21/fulltext-search-made-almost-right/.

Even though Azure DB for PostgreSQL provides secure connection, Applications on ARO needs to access Azure DB for PostgreSQL via internet.

Currently, VNET for ARO doesn't allow any modification, therefore, there is no option avoiding going through internet when applications connect to Azure DB for PostgreSQL.

There is no point in deploying a DB container on ARO. The user needs to consider how to manage DB.

If ARO allows modifying VNET creating Service endpoint for Azure DB for PostgreSQL, it could provide more secure route and low latency connections as well.

Provide a CLI inside the Azure Portal for the management of the database

Please add the following extension to postgres: https://hashids.org/postgresql/ it is a library to enable generating short slugs from integers. and the GitHub for it: https://github.com/iCyberon/pg_hashids

Thank you

We are running a multi-tenant system leveraging Azure PostgreSQL.
During heavy load, one Tenant can impact the system to a point where other databases are effected.

Wondering if you are planning to support some type of resource governance in the future similar to Azure SQL
https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor-resource-pool?view=sql-server-2017

I realize it wont be the same implementation, but maybe a new connectionstring parameter that could be set to limit CPU/Memory could be a start?

On AZ PostgeSQL Performance Insight, the role of Reader can view everything but not “query text”,
so basically like most of things in Azure we believe that Reader role should also be able to
view query text. And that is the issue and needs to be fixed in future releases.

CSS, Requested by Customer

For Azure SQL, service endpoint should allow traffic not only within a virtual network's region but also extend to include the paired region where the virtual network is deployed.

(Idea submitted by Manish Kumar from the engineering group of Azure Database for PostgreSQL/MySQL service on behalf of one of our customers and in order to elicit feedback from other customers and users).