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 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 -…

    10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  2. PG_HBA: Sync rules from master to read replica to allow proper service failover

    As described in this issue (I won't rewrite the whole request again): https://github.com/MicrosoftDocs/azure-docs/issues/35906

    Azure's postgres PaaS is broken for the enterprise without this feature. I consider lack of this option a defect, not a feature request but am logging it here as directed.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    13 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  5. "Allow access to Azure Services" does not work for Flask Web App

    I have a Flask web app which using Azure PostgresSql server/db, the application running fine on my local machine, (I already added my local IP to azure postgresql server's firewall rules)
    But after I deployed the app to to Azure App Service, the web app failed to start, got this error:

    no pghba.conf entry for host "104.208.xx.***", user "pi", database "iotdb", SSL on
    2019-09-26T07:11:58.743294692Z FATAL: no pg
    hba.conf entry for host "104.208.xx.***", user "pi", database "iotdb", SSL on

    the option "Allow access to Azure Services" already enabled for the Azure PostgreSQL, but it does not work!

    I have to…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow admin user to be able to execute ALTER TABLE “my_table” DISABLE TRIGGER ALL

    Can the 'azurepgadmin' role be enhanced so that

    ERROR: permission denied: "my-trigger-name" is a system trigger

    is not encountered when executing

    ALTER TABLE “my_table” DISABLE TRIGGER ALL

    . The system trigger in question is one associated with a foreign key and the assocated triggers are system triggers.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  7. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. Support creating VNET Service endpoint in Azure Red Hat OpenShift

    Even though Azure DB for PostgreSQL provides secure connection, Applications on ARO needs to access Azure DB for PostgreSQL via internet.

    Currently, VNET for ARO doesn't allow any modification, therefore, there is no option avoiding going through internet when applications connect to Azure DB for PostgreSQL.

    There is no point in deploying a DB container on ARO. The user needs to consider how to manage DB.

    If ARO allows modifying VNET creating Service endpoint for Azure DB for PostgreSQL, it could provide more secure route and low latency connections as well.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Enable shutdown (deallocate equivalent) for Postgres when not in use.

    For non-production environments it would be a helpful cost saving feature to be able to 'turn off' / deallocate Azure Databases (of all types not just postgres) when they are not in use.

    While the prevailing logic would suggest that non-production environments should be destroyed when not in use, this is sometimes not convenient or practical when environments are required on (relatively) short notice and DB content sizes are relatively large

    20 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  15. Upgrade from PostgreSQL 9.6 to 10.3

    Please provide a tool or procedure to upgrade from PostgreSQL 9.6 to 10.3.

    26 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  16. Native Python and R support - extensions plpythonu, plpython2u, plpython3u

    Please support extensions plpythonu, plpython2u, plpython3u so functions etc. can have Python code.

    Similar request for R support with extensions like PL/R

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  17. Server-side connection pooling

    Would be great if it was possible to enable server-side connection pooling (e.g. Pgpool-II or PgBouncer) right from the portal.

    24 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add support for auto_explain to collect access plans of the slow queries

    auto_expalin would help us collect access plans of the queries which exceed a threshold of the query execution time.

    https://www.postgresql.org/docs/9.6/static/auto-explain.html

    27 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  20. pg_cron extension

    Include pg_cron in order to schedule periodic maintenance tasks.

    46 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

Azure Database for PostgreSQL

Categories

Feedback and Knowledge Base