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.
-
The ability to set collation on db-create
It would have been great if the user could choose collation on first-time set-up.
1 vote -
Firewall Option: Auto-enable other Azure Services
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.
6 votes -
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…
1 vote -
PGAudit extension
Add PGAudit extension
1 vote -
TimescaleDB extension
Support TimescaleDB extension to postgresql
https://github.com/timescale/timescaledb7 votes -
Rebuild PostgreSQL with libxml option
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."4 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.
1 vote -
Add postgresql support to Pivotal Cloudfoundry Azure Broker
Make azure postgresql databases available to the vast community of Cloudfoundry and it's java applications.
1 vote -
Add "pgpointcloud" extension support.
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).
2 votes -
earthdistance extension
add earthdistance extension support
2 votes -
Great GUI Tool for Writing/Developing Postgres Queries
A tool focused on postgres developers writing sql. No query builders, no admin/management tools cluttering everything up. Each window only needs to connect to one database, show the tables and their columns. A nice big button and intelligent keybinding(e.g. shift+enter) for executing queries. Production databases should have red outline/window borders or some danger indication. Config the connection with a file, no need for ui. Postgres only and support it's unique datatypes json/array/etc really well, and no jdbc/jvm requirements. And very importantly show stacked results, because I can't tell you how important it is when working to see the results from…
1 vote -
Vnet integration
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.
16 votes -
ltree extension
Support ltree extension to postgresql
https://www.postgresql.org/docs/9.6/static/ltree.html
we use it in our new product.
3 votes -
dblink extension
add dblink extension support
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.
1 vote -
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.
4 votes -
replication support or is that built in?
Ability to setup replications is critical, I don't see medium to large enterprise use this product at all without ability to ensure replication in place.
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.
6 votes -
pg_bigm for full text search
I need to support Asian languages for full text search.
4 votes -
Citus columnar datastore
I need this to do big-ish data things:
https://www.citusdata.com/blog/2014/04/03/columnar-store-for-analytics/
I am a huge fan of postgresql for data warehousing, and this is a key thing for having the ability to summary large tables quickly.
3 votes
- Don't see your idea?
