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.

  1. 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/

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  2. Ability to increase max_connections

    Default values are too low for our needs.

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. 8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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).

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  5. Support Proximity Placement Group in PostgreSQL - Flexible Server

    The unique reason we had to build manually or own PostgreSQL with VMs instead of using Azure PostgreSQL as a service was the lack of support of proximity placement groups.

    Now that you are developing flexible server options based in "normal" VM It will be great it PPG are supported so we can address the "high" latency problems we had with the service.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Correct handling of cancel query request (from client)

    I have been using "normal" postgres for many years now and I have become quite used to being able to cancel (ctrl-c) long-running queries I started from a client (psql).
    When I try this when I am connected to an Azure postgres database, psql states that the signal was sent, but the query is not cancelled. To cancel it, I have to open another session and run a pgcancelbackend(pid) on it.

    Please implement support for handling Ctrl-c signals to cancel queries.

    Update:
    I raised this as a support ticket and was informed by the support-engineer that this was…

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. pgTAP support for application testing

    We are working on migrating our app to Azure, and our app has unit/regression tests with using pgTAP [1].

    I would like Azure PostgreSQL to support pgTAP to allow us for application compatibility test.

    [1] https://pgtap.org/

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  10. Oracle "oracle_fdw"

    Please include oracle "oracle_fdw" in order to support oracle connectivity

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  11. Include support for PLJAVA extension

    Include support for PLJAVA extension to be able to write stored procedures, triggers, functions in Java

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  12. Make PostgreSQL on Azure support usable speeds and not be slow

    PostgreSQL on Azure is very outdated and extremely slow. It's very much unusable like this and we ended up moving to our own PostgreSQL container that don't have these issue. Please clarify that

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. MADlib

    Machine learning, statistics and analytics for data scientists
    http://madlib.incubator.apache.org/

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  14. neo4j_fdw extension

    Include neo4j_fdw foreign data wrapper for Neo4j Graph Database

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  15. Support for PostgreSQL 13

    Once version 13 is out, it would be good to get it supported as documentation claims azure will support every major ver (and 12 is still not supported)

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  16. Automatic failover between regions

    Whenever the databases on one region are down, allow to failover automatically to another region without changing the connections string

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Region  ·  Flag idea as inappropriate…  ·  Admin →
  17. Include pg_repack feature for azure database of postgresql

    It will be helpful if we have pgrepack feature in azure database for postgresql to handle bloat.vacuum full will place an exclusive lock on the table and until the vacuum full is completed the transactions related to that table will be held if the vacuum full is performed at table level.So pgrepack is the alternate option where the reorg of table can be performed with out impacting any ongoing transactions.Performing repack during the time when there are less number of transactions to that table will decrease the overhead and can be able to handle bloat in efficient way.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  18. Support upgrading major versions via Replication

    Upgrading Data via Replication is documented as a method in the PostgreSQL docs.

    When creating a read replica in the Azure Portal it is not possible to change the version (I assume it uses the same version as the master).

    Please allow selecting a version when creating a replica so that this upgrade method would be possible.

    18.6.3. Upgrading Data via Replication
    https://www.postgresql.org/docs/current/upgrading.html

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. oracle_fdw extension

    Provides a Foreign Data Wrapper for easy and efficient access to Oracle databases, including pushdown of WHERE conditions as well as comprehensive EXPLAIN and ANALYZE support.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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).

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Azure Database for PostgreSQL

Categories

Feedback and Knowledge Base