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 pg_prometheus extension

    It's a perfect fit together with timescaledb-extension if you have prometheus running in AKS

    18 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. Need a way to terminate sessions to drop and recreate a database

    I have used the following script to kill connections prior to dropping, creating and loading a database on our in house postgresql instance:

    SELECT pgterminatebackend(pgstatactivity.pid)
    FROM pgstatactivity
    WHERE pgstatactivity.datname = 'TARGET_DB';

    But it requires superuser rights to kill the connections which is something we don't get on Azure.

    I would like some programmatic way to do this in Azure.

    17 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. PostGIS 3.0

    PostGIS 3.0 is currently in alpha. It adds support for parallels processing of spatial queries which drastically increases the performance of spatial queries and makes PostGIS more inline with other advanced spatial databases. Please upgrade to this version of PostGIS when it is fully released.

    16 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

    3 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  4. Ability to restore data from a snapshot

    We have a transient workload that only needs to run once every week at most. However, the DB state needs to be saved at the end of each run. Since the workload only runs occasionally, it costs quite a lot to keep the server running in the meanwhile, even at the minimum size for the tier.

    While it is possible to pg_dump/restore the data, this is very slow compared to restoring from a snapshot, which would be nearly instantaneous. Currently, deleting a server also removes the ability to access backups for the server.

    If one could optionally save a snapshot…

    16 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  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  5. Need earlier Planned maintenance notification

    So far, the notification about the upcoming maintenance is sent 72 hours before the event.
    It is too late for us to take an action or ask our end user to be ready about that.
    Please send the notification before two weeks if possible.
    It will be very helpful if you do that.

    In addition, it would be great if there are notifications also when maintenance started and when it was completed.

    15 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 →
  6. Please add timescaledb 1.6.0 extension

    Currently Microsoft only allows TimescaleDB 1.3.2. Please add 1.6.0 as an option.

    14 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

    7 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  7. BYOK Encryption Key

    For governance reasons for managing PHI, we need to BYOK for the Disk Level Encryption. Is there any plan to expose the ability to have the storage account that the underlining managed system is using to a key that's stored in key vault?

    We can't host our postgresSql Database in Azure's managed solutions, until we can.

    14 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

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

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

    13 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  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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 -…

    12 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 →
  11. The ability to set collation on db-create

    It would have been great if the user could choose collation on first-time set-up.

    12 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 →
  12. 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.

    12 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 →
  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)

    11 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  ·  Flag idea as inappropriate…  ·  Admin →
  14. allow to login with the real username instead of username@{server_name}

    our product running not only in Azure, but also in AWS and on-premises, the PostgreSQL on both of them don’t need to add ‘@{server_name}’ after the real username.

    11 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  ·  Flag idea as inappropriate…  ·  Admin →
  15. pg_bigm for full text search

    I need to support Asian languages for full text search.

    11 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 →
  16. 10 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 →
  17. Enable the ability to assign BYPASSRLS to PostgreSQL Roles

    It would be great to have the ability to assign BYPASSRLS to spefic users in the system so we could have a backup user who had access to all data data and could run pg_dump without errors and then all other users had row level security enabled to enforce the data people could see.

    This would provide an extra level of secuirty to the application as then even table owners would not be able to access all data where at present row level security is only enabled for standard users.

    9 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 →
  18. BDR

    we want multi-master-replication for PostgreSQL

    9 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

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. zhparser extension for Chinese Full Text Search

    We would like to be able to use https://github.com/amutu/zhparser in order to implement Chinese Full Text Search.

    9 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. Pg_basebackup / Replication on-premise

    It would be great if we could either use pgbasebackup as well as pgdump 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.

    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  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Azure Database for PostgreSQL

Categories

Feedback and Knowledge Base