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.

Do you have an idea or suggestion based on your experience with Azure Database for PostgreSQL?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. (Cross-region) Read replicas

    Would be great to have an ability to have a master in one region (e.g. Central US) and read-only replicas in other regions (e.g. West/East US)

    (renamed; merged with "active geo-replication")

    60 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

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

      42 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        under review  ·  3 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
      • Upgrade from PostgreSQL 9.6 to 10.3

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

        9 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
        • 7 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

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

            7 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
            • Firewall option: Allow access from a specific Azure resource

              While the option to allow access to all Azure services is nice, I'd much rather be able to control what resources can reach my server on a more granular level.

              The vnet integration is excellent, but many Azure resources (I'm thinking specifically of Data Factory at the moment) aren't integrated with vnets, for various reasons.

              3 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

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

                3 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
                • 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
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

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

                    2 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

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

                      2 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
                      • Better support for automation of installation in ARM Template / PowerShell

                        We massively deploy PostgreSQL instances. We (for exemple) need to automatically deploy configuration (for instances log_* parameters). It's possible to modify configuration with AZ commands. The other automation tools don't have the required functionality:

                        * ARM Template cannot deploy instances with a set configuration.

                        * Python2 should provide the necessary tools via azure.mgmt.* but is not very well documented (it's still in preview)

                        * PowerShell as no options for that. (and very few means to interact with Postgres in general).

                        In general, the support for postgres is bad in automation tools (and the feature coverage not uniform). We have to…

                        2 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
                        • Add DNS management to firewall rules configuration

                          Usually pg_hba.conf accepts DNS names so you can use i.e. my.address.ip for ***.***.***.***. In Azure portal you can input only numeric IP addresses but this presumes you have staic public IP address. Allowing DNS management you would be able to use Dynamic DNS solving non static public IP address problem.

                          2 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
                            • Post PostgreSQL Version Updates

                              Could Azure announce beforehand when version updates will be applied to Azure Database for PostgreSQL? For instance, updates are posted when PHP gets updated (https://azure.microsoft.com/en-us/updates/june-2018-version-updates-to-php/).

                              1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                                Password icon
                                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

                              Feedback and Knowledge Base