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.
-
(Same-region) Read replicas
(merged with "replication support or is that built in")
79 votesI’m happy to announce that same-region Read Replicas are now in public preview.
You can start using them today in every region Azure Database for PostgreSQL is available.
Thank you so much for being a supporter of this feature, and giving your feedback.
Documentation:
Overview -https://docs.microsoft.com/azure/postgresql/concepts-read-replicas
How-to – https://docs.microsoft.com/azure/postgresql/howto-read-replicas-portalBest,
Rachel, on behalf of the Azure Database for PostgreSQL team -
support of orafce extension
This extension enables Oracle’s compatibility functions and packages. We can also explore more the idea of ‘Bring your own extension’.
19 votesThank you for supporting this extension. We’ve begun work on it and expect it to be available in the next few weeks.
Best,
Rachel on behalf of the Azure Database for PostgreSQL team -
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.13 votes -
16 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.
4 votes -
7 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 -
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 -
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.
44 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 -
Replication delay configuration
First, thank you for providing read replicas. One thing that is still nessesary is the ability to tweak the replication configuration. If we want to take dumps from a medium (or larger) sized database directly from the replica, then this dump will be aborted because it simply takes too long.
This could be solved by enabling the max_standby_streaming_delay property for the read replicas. Setting it to -1 would enable to take dumps for larger databases of 100GB+.
3 votesThank you for your feedback. This parameter is scheduled to become available in March.
Rachel, on behalf of the Azure Database for PostgreSQL team
-
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 -
PostgreSQL in West Central US region
It doesn't appear on the roadmap. Is this planned anytime soon?
3 votes -
support the pg_hashids extension
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
1 vote -
Resource Governace for CPU and Memory
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-2017I 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?
1 vote -
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…1 vote -
Reader Role can view Query Text
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
1 vote -
Azure VNet in paired region
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).
1 vote -
Stop/start server
Gaging interest for being able to stop a server when it is not being used and restart it when needed.
1 vote -
Rename server
Gaging interest for being able to rename a server/instance.
For instance some customers shared that the naming convention they use for servers changes as a server moves from one stage of its lifecycle to another (test -> staging -> prod for instance)
1 vote
- Don't see your idea?