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.
-
Ability to increase max_connections
Default values are too low for our needs.
6 votes -
Enable the ability to assign BYPASSRLS to PostgreSQL Roles
It would be great to have the ability to assign BYPASSRLS to spefic users in the system so we could have a backup user who had access to all data data and could run pg_dump without errors and then all other users had row level security enabled to enforce the data people could see.
This would provide an extra level of secuirty to the application as then even table owners would not be able to access all data where at present row level security is only enabled for standard users.
5 votes -
Temporal Tables PostgreSQL Extension
Support temporal tables extension to provide part of the features similar to SQL Server Temporal Tables.
24 votes -
Logical Replication
I have a pretty large database, over 70GB, and cannot afford to have downtime with a full backup and restore. Please add support for logical replication with pg logical, slony, or another means.
70 votes -
Allow customization of space and IOPS for logs
To allow for workloads that require verbose logging levels like DEBUG, it would be nice to be able to set (purchase) additional space or IOPS dedicated to storage of logs.
4 votes -
Azure Powershell SDK support for PostgreSQL
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
22 votes -
Support pg_freespacemap extension
Support pg_freespacemap extension for examining the free space map (FSM)
3 votes -
pgagent extension
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
19 votes -
zhparser extension for Chinese Full Text Search
We would like to be able to use https://github.com/amutu/zhparser in order to implement Chinese Full Text Search.
9 votes -
Support stored procedures in Python
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.
17 votes -
Support pg_visibility extension
Add the pg_visibility extension
2 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 -
PGAudit extension
Add PGAudit extension
28 votesstarted ·
AdminAzure Database for PostgreSQL Product Team
(Product Owner, Microsoft Azure)
responded
pgAudit is now in public preview on Azure Database for PostgreSQL. Thank you for your support of this feature.
For more information: https://docs.microsoft.com/azure/postgresql/concepts-audit
Best,
Rachel, on behalf of the Azure Database for PostgreSQL team -
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 -
Ability to scale between different tiers
Right now, it doesn't seem to be possible to scale from Basic to Standard. Would be good if that was possible.
24 votesneed-feedback ·AdminAzure Database for PostgreSQL Product Team
(Product Owner, Microsoft Azure)
responded
Today we support migration between General Purpose and Memory Optimised tiers. We don’t have an automated migration between either of those tiers and the Basic tier.
Please share in the comments whether you need a migration between Basic and GP/MO, and do add details on why.
Best,
Rachel on behalf of the Azure Database for PostgreSQL team -
Configurable autovacuum
Our database is in use, in reading and writing, 24 hours per day through batch elaborations and online transactional operations. In our scenario, the auto vacuum is dangerous because it can slow down operations in the wrong moment of the day causing low answer times or even unavailability of our web application.
For this reason, we decided to turn off the auto vacuum and manage manually the maintenance routine of our tables: we use pgagent to schedule daily vacuum analyze of our tables and manually run vacuum full on large tables when needed (eg. their size on disk is too…
16 votes -
The ability to set collation on db-create
It would have been great if the user could choose collation on first-time set-up.
11 votes -
Support for tds_fdw
https://github.com/tds-fdw/tds_fdw
This is a PostgreSQL foreign data wrapper that can connect to databases that use the Tabular Data Stream (TDS) protocol, such as Sybase databases and Microsoft SQL server.
11 votes -
Add "ogr-fwd" support extension.
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.
6 votes -
URL encode PostgreSQL connection strings
The string I got initially was as follows:
postgres://user@postgre-resource-name:password@host:5432/database
Because @ sign appears twice, some tools like pg_dump were confused. The issue was solved by URL encoding the first @:
postgres://user%40postgre-resource-name:password@host:5432/database
4 votesneed-feedback ·AdminAzure Database for PostgreSQL Product Team
(Product Owner, Microsoft Azure)
responded
Thanks for using Azure Database for PostgreSQL.
Where are you requesting that we display this url encoded version? You mention that you got the first string – was this from one of our documents? Do let me know so we can update it. Also, you can directly use the GitHub issues commenting system to request changes to Azure documentation on a document page.
Thanks,
Rachel on behalf of the Azure Database for PostgreSQL team
- Don't see your idea?