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.
-
pg_squeeze is an extension that removes unused space from a table and optionally sorts tuples according to particular index
https://github.com/cybertec-postgresql/pg_squeeze
pg_squeeze is an extension that removes unused space from a table and
optionally sorts tuples according to particular index (as if CLUSTER [2]
command was executed concurrently with regular reads / writes). In fact we try
to replace pg_repack [1] extension.20 votes -
19 votesstarted ·
AdminAzure Database for PostgreSQL Product Team
(Product Owner, Microsoft Azure)
responded
We expect to have Postgres 11 available in June.
Best,
Rachel, on behalf of the Azure Database for PostgreSQL team -
Please be able to control Schedule the maintenance from the user's perspective.
Users can decide when scheduled maintenance starts from in AWS.
e.g. Maintenance refers to the application of OS and database security patches.Please be able to control schedule the maintenance in Azure Database for PostgreSQL from the users . It is problem that unexpected connection failures by maintenance in Azure Database.
For pre-planned maintenance, the convenience of users will be improved , if schedule the maintenance can be controlled.AWS's Resource
How do I minimize downtime during required Amazon RDS maintenance?
URL: https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/?nc1=h_lsMaintaining a DB Instance
URL: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Maintenance.html4 votes -
PostGIS 2.5
Please upgrade PostGIS 2.4 to PostGIS 2.5 on PostgreSQL 10. Several new features were introduced in PostGIS 2.5 which speeds up spatial calculations.
11 votes -
Support pg_prometheus extension
It's a perfect fit together with timescaledb-extension if you have prometheus running in AKS
8 votes -
Support for PGroonga
PGroonga is a PostgreSQL extension to use Groonga as the index, and make PostgreSQL fast full text search platform for all languages (such as Japanese and Chinese).
PGroonga: https://pgroonga.github.io/
Groonga: http://groonga.org/
3 votes -
Allow Event Triggers to be created
I am working with multiple users on shared tables. As the users belong to a dedicated role "pgpublish" I am in the need to run "ALTER TABLE "MYcoolSchema"."CoolNewTable" OWNER TO pgpublish;" on every new table which we create manually.
As I want to have any new table owned by the role pgpublish instead of the user role I want to to create a trigger function and a trigger event to change table owner automatically (as described here: https://blog.hagander.net/setting-owner-at-create-table-237/). Unfortunately I can't create trigger events as I am not a superuser nor do I have the credentials for a SU…10 votes -
Pg_basebackup / Replication on-premise
It would be great if we could either use pg_basebackup as well as pg_dump to take backup or the ability to replica from the Azure Master to our own db instance (either a VM on Azure or on-premise).
This would mean creating replication role slots under the Connection security tab.
1 vote -
Upgrade the available TimescaleDB extension from v1.1.1 to v1.3 or higher.
Just wanted to upgrade the TimescaleDB extension from the current v1.1.1 to v1.3 or higher to be able to utilize the Continuous Aggregates feature.
2 votes -
Support for Custom Full Text Search Dictionaries
PostgreSQL supports so many great full text search capabilities that can be really handy in small to mid sized applications without adding the extra overhead of separate search services.
https://www.postgresql.org/docs/9.6/textsearch-dictionaries.html
When self-hosting PG you can add custom dictionaries, with custom synonym, thesaurus, stop word, and other stemming definitions. Currently Azure hosted PostgreSQL doesn't support this, as you'd need access to upload language and dictionary files to use in those definitions. For example, if you want a solid spellchecker via ispell or hunspell you can download those extensions and place them in the $SHAREDIR/tsearch_data directory on the PG server.
Also -…
2 votes -
Add ability to authenticate against Azure Active Directory
It'd be really useful to not have to rely on DB users for authentication but allow integration with AAD. That way we can enforce password complexity, expiry etc which can't be done with native users.
62 votes -
Execute SQL scripts during ARM Template Deployments
After deploying a postgreSQL service using an ARM template, in order to configure my databases, roles, etc., I have to execute a script after I have deployed the service.
I'd like a way to include a SQL script at time of deploying my ARM template.
3 votes -
ip4r extension
It would be great to have the ip4r extension available in the Azure Database for PostgreSQL service. We already use this extension in our self-managed psql service to use IP addresses as native objects. It is very useful for some IPAM engines like nipapd, etc.
For more information about this extension: https://github.com/RhodiumToad/ip4r
1 vote -
1 vote
-
Citus columnar datastore
Azure team edit: I' creating this new idea on behalf of a customer to separate it from the votes for Citus on Azure Database for PostgreSQL. If you're interested in Citus columnar datastore (link below), please vote for this idea.
++++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.
4 votes -
Target for Data Factory (ADF)
Data Factory supports PostgreSQL and Azure PostgreSQL as sources. Please add them as targets.
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 -
Implement PL/.NET Core for Stored Procedures, Triggers, and Functions in PostgreSQL
Implement PL/.NET Core support which will allow for Stored Procedures, Triggers, and Functions in PostgreSQL to be written in .NET Core
6 votes -
Stop/start server
Gaging interest for being able to stop a server when it is not being used and restart it when needed.
2 votes -
postgresql
Provide a CLI inside the Azure Portal for the management of the database
1 vote
- Don't see your idea?