Azure Database for PostgreSQL
We would love to hear it! Please take a few minutes to submit your idea or vote up an idea submitted by another Azure Database for PostgreSQL customer. All of the feedback you share in these forums will be monitored and reviewed by the Azure Database for PostgreSQL engineering team. By suggesting or voting for ideas here, you will also be one of the first to know when we begin work on your feature requests and when we release the feature.
Remember that this site is only for feature suggestions and ideas! If you have technical questions please try our documentation, MSDN forum or StackOverflow.
-
Support pg_freespacemap extension
Support pg_freespacemap extension for examining the free space map (FSM)
3 votes -
Ability to restore to same database name
Ability to run a point in time restore to same database name rather than restoring to a new instance.
3 votes -
3 votes
-
POWA - PostgreSQL Workload Analyzer (or alternative)
Support for POWA or another performance analyzer would be nice. https://github.com/dalibo/powa
3 votesneed-feedback ·
AdminAzure Database for PostgreSQL Product Team
(Product Owner, Microsoft Azure)
responded
Thank you for your interest in Azure Database for PostgreSQL.
Monitoring solutions that don’t have to be added as an extension are possible alternatives. Workable solutions query the server’s statistics through a low-privileged user role. Possible examples are pghero, pgwatch2.
Please do let us know if POWA specifically is needed and any additional comments.
Thanks,
Rachel on behalf of the Azure Database for PostgreSQL team -
add cstore extension
for Columnar stores provide notable benefits for analytics use cases where data is loaded in batches
2 votes -
periods extension
The SQL 2016 standard defines a native way of handling system-versioned temporal tables. The periods extension provides this functionality for PostgreSQL versions 9.5 - 12.0, until native support is added.
https://github.com/xocolatl/periods
There is a Debian package available which can be installed:
"sudo apt install postgresql-11-periods"
The extension can then be enabled using regular CREATE EXTENSION syntax.
I would love to see this added to Azure. There is clearly demand for this functionality; the thread below suggests adding support for the temporal_tables extension and has 24 upvotes. However, that extension is now outdated compared to the much shinier periods extension.
…
2 votes -
Ability to shrink storage when restoring
We would like to shrink the allocated (max) storage when we restore a PaaS to create another environment. This would be especially interesting to create Test environments from Production environments with large unused storage (due to the provisioning of a big IOPS bandwith for performance).
2 votes -
Native Python and R support - extensions plpythonu, plpython2u, plpython3u
Please support extensions plpythonu, plpython2u, plpython3u so functions etc. can have Python code.
Similar request for R support with extensions like PL/R
2 votes -
Provide actual memory being used (in GB) in Azure Monitor
Provide actual memory being used (in GB) in Azure Monitor in addition to % memory used. The customer scenario is for the Persona of a QA/Test professional. Actual memory used is much more useful than % used as it related to determining the quality of a product / service. % used is tailored to SRE/Ops persona.
2 votes -
Correct count of Postgres connections in Portal
We use the Azure postgres database and shows the connection count in our monitoring setup. We just realized that the connection count shown in the Azure Portal is not the same as Postgres repots. We had over 170 connections at one time, while the Portal showed approx. 20 connections
2 votes -
Add DNS management to firewall rules configuration
Usually pg_hba.conf accepts DNS names so you can use i.e. my.address.ip for .... In Azure portal you can input only numeric IP addresses but this presumes you have staic public IP address. Allowing DNS management you would be able to use Dynamic DNS solving non static public IP address problem.
2 votes -
Support pg_visibility extension
Add the pg_visibility extension
2 votes -
Debugging support
Please add support for debugging. When using pgAdmin and other development tools they refer to the the extention pldbgapi, and would be great if this was installed by default.
2 votes -
Point in time restore to include HBA and server parameters
When restoring to a point in time, HBA settings and server parameters such as search_path are not included on the new server. It would be nice for the restore to include this configuration.
2 votes -
Better grouping of server parameters
Would be great if server parameters were logically grouped together (rather than just being sorted alphabetically). For example, timeout settings together, logging settings together etc.
2 votesunplanned ·AdminAzure Database for PostgreSQL Product Team
(Product Owner, Microsoft Azure)
responded
Thanks for your feedback. That could be a helpful UI change for the Azure portal. Currently it’s unplanned, but we can revisit it in the future if there’s a high demand.
We also support search over the list of parameters to get to the one you need.
-
Set the AD admin with API
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,
1 vote -
zombodb
ZomboDB extends PostgreSQL capabilities for FTS as it works pretty nicely with Elasticsearch. It works as a native PosgreSQL extension and its support PostgreSQL versions 10.x and 11.x.
Not having it as an extensions is one of the main reasons why we don't migrate from having databases in VMs to Azure Database for PostgreSQL.
1 vote -
PGSQL 12 Availability?
It would be nice if PGSQL 12 (including on-by-default JIT extensions) were available as an option.
1 vote -
Please add timescaledb 1.6.0 extension
Currently Microsoft only allows TimescaleDB 1.3.2. Please add 1.6.0 as an option.
1 vote -
Provide wal_level server parameter
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.
1 vote
- Don't see your idea?