Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Support for PostgreSQL 12

    PostgreSQL 12 has been GA for over 4 months now. Any indication on when it will be supported?
    Version 12 contains new features like case-insensitive grouping, better connection security and various improvements that will improve scalability and performance of Large partitioned tables.

    151 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

    planned  ·  25 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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)

    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

    1 comment  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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 →
  4. Allow postgres user to be able to execute ALTER TABLE “my_table” DISABLE TRIGGER ALL

    I am working with multiple users on shared tables. As the users belong to a dedicated role "public" I am in the need to run "ALTER TABLE "public"."NewTable" OWNER TO postgres;" on every new table which we create manually.
    As I want to have any new table owned by the role postgres instead of the user role I want to to create a trigger function and a trigger event to change table owner automatically . Unfortunately I can't create trigger events as I am not a superuser nor do I have the credentials for a SU by default. I am…

    1 vote

    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 →
  5. When will postgres 12 be supported on azure database for postgresql Single Server?

    When will postgres 12 be supported on azure database for postgresql Single Server?

    1 vote

    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. upgrade next major version automatically

    Now, PostgreSQL on Azure can not upgrade to next major version automatically. This process is huge cost and steps for partner/customer.

    I think below document and steps is only supported.

    https://docs.microsoft.com/en-us/azure/postgresql/how-to-upgrade-using-dump-and-restore

    Is there a plan for upgrade to Next major version automatically?

    1 vote

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

    Any idea when "Azure PostgreSQL Flexible Server" will be out of preview, and into GA?

    1 vote

    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 →
  8. In PostgreSQL 11 "REINDEX DATABASE" command used to run concurrently

    In PostgreSQL 11 "REINDEX DATABASE" command used to run concurrently, but in Azure PostgreSQL DB it doesn't. That's why I can't run the command - I can't make my server unresponsive for ~ 1 hour.

    1 vote

    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 →
  9. Provide a way to alter pricing level from basic to general in postgressql in GUI

    Provide a way to use the portal GUI to alter the pricing level of a database from basic to general.

    1 vote

    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 →
  10. Enable pg_autofailover on postgres 12 instance

    Please add postgres 12s auto failover for replicas.

    3 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 →
  11. I need a DR read replica with reduced capacity which would be used for data replication only but it won't have any user connections

    I need a DR read replica with reduced capacity which would be used for data replication only but it won't have any user connections.

    Currently, the read replica has the constraint on max connections. I basically want a read replica without this restriction.

    1 vote

    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 →
  12. Set the AD admin with API

    To be able to script the creation of a PostgreSQL Database, it could be great if it was possible to set the Azure AD admin with an API or Az CLI.

    Thanks,

    1 vote

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

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

    38 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

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

    2 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. 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 →
  17. 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

    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  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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 →
  19. 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 →
  20. Support for Ultra SSD SKU configuration

    For performance critical workloads and large volumes of data, storage access latency is critical. Please support a Ultra SSD SKU configuration.

    4 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 →
← Previous 1
  • Don't see your idea?

Azure Database for PostgreSQL

Categories

Feedback and Knowledge Base