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. URL encode PostgreSQL connection strings

    The string I got initially was as follows:

    postgres://user@postgre-resource-name:password@host:5432/database

    Because @ sign appears twice, some tools like pg_dump were confused. The issue was solved by URL encoding the first @:

    postgres://user%40postgre-resource-name:password@host:5432/database

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

      We’ll send you updates on this idea

      2 comments  ·  Flag idea as inappropriate…  ·  Admin →

      Thanks for using Azure Database for PostgreSQL.

      Where are you requesting that we display this url encoded version? You mention that you got the first string – was this from one of our documents? Do let me know so we can update it. Also, you can directly use the GitHub issues commenting system to request changes to Azure documentation on a document page.

      Thanks,
      Rachel on behalf of the Azure Database for PostgreSQL team

    • 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).

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

        We’ll send you updates on this idea

        under review  ·  0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
      • POWA - PostgreSQL Workload Analyzer (or alternative)

        Support for POWA or another performance analyzer would be nice. https://github.com/dalibo/powa

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

          We’ll send you updates on this idea

          1 comment  ·  Flag idea as inappropriate…  ·  Admin →

          Thank you for your interest in Azure Database for PostgreSQL.

          Monitoring solutions that don’t have to be added as an extension are possible alternatives. Workable solutions query the server’s statistics through a low-privileged user role. Possible examples are pghero, pgwatch2.

          Please do let us know if POWA specifically is needed and any additional comments.

          Thanks,
          Rachel on behalf of the Azure Database for PostgreSQL team

        • agensgraph extension

          Support graph extension to postgresql

          https://github.com/bitnine-oss/agensgraph

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

            We’ll send you updates on this idea

            under review  ·  0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
          • Correct count of Postgres connections in Portal

            We use the Azure postgres database and shows the connection count in our monitoring setup. We just realized that the connection count shown in the Azure Portal is not the same as Postgres repots. We had over 170 connections at one time, while the Portal showed approx. 20 connections

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

              We’ll send you updates on this idea

              0 comments  ·  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
              • facebook
              • google
                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
                • facebook
                • google
                  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.

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

                    We’ll send you updates on this idea

                    0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
                  • Support pg_freespacemap extension

                    Support pg_freespacemap extension for examining the free space map (FSM)

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

                      We’ll send you updates on this idea

                      0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
                    • Ability to restore to same database name

                      Ability to run a point in time restore to same database name rather than restoring to a new instance.

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

                        We’ll send you updates on this idea

                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Point in time restore to include HBA and server parameters

                        When restoring to a point in time, HBA settings and server parameters such as search_path are not included on the new server. It would be nice for the restore to include this configuration.

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

                          We’ll send you updates on this idea

                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • PostgreSQL as a service in Azure China

                          We have made good experience with PostgreSQL as a service in Azure already (even in Preview).
                          We would like to use it also in Azure China.

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

                            We’ll send you updates on this idea

                            1 comment  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
                          • Ability to output data changes via logical decoding (ex. wal2json)

                            PostgreSQL, since 9.4, has the ability to provide the list of changes made to a database in a manner that is transaction-safe and lossless.

                            To enable this feature, the wal_level needs to be set to logical and there needs to be an available output plugin. Unfortunately, PostgreSQL only comes with the test_decoding plugin, which was only really meant as an example.

                            AWS for example, has included wol2json support:

                            https://aws.amazon.com/about-aws/whats-new/2017/07/amazon-rds-for-postgresql-supports-new-minor-versions-9-6-3-and-9-5-7-and-9-4-12-and-9-3-17/

                            The simple wol2json output plugin would be a good way to provide access to this powerful feature for a wide audience.

                            I'd also be fine with other output plugins. It may…

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

                              We’ll send you updates on this idea

                              under review  ·  2 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
                            • Great GUI Tool for Writing/Developing Postgres Queries

                              A tool focused on postgres developers writing sql. No query builders, no admin/management tools cluttering everything up. Each window only needs to connect to one database, show the tables and their columns. A nice big button and intelligent keybinding(e.g. shift+enter) for executing queries. Production databases should have red outline/window borders or some danger indication. Config the connection with a file, no need for ui. Postgres only and support it's unique datatypes json/array/etc really well, and no jdbc/jvm requirements. And very importantly show stacked results, because I can't tell you how important it is when working to see the results from…

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

                                We’ll send you updates on this idea

                                under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Better grouping of server parameters

                                Would be great if server parameters were logically grouped together (rather than just being sorted alphabetically). For example, timeout settings together, logging settings together etc.

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

                                  We’ll send you updates on this idea

                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • MADlib

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

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

                                    We’ll send you updates on this idea

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

                                    1 vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

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

                                        1 vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                        • effective_cache_size

                                          You should allow tuning of memory-related parameters. I have a 15GB server and the effective_cache_size is 1536MB; it should be eight times as high. Without tuning these parameters my application is simply too slow to run on your environment.

                                          1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

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

                                          Azure Database for PostgreSQL

                                          Feedback and Knowledge Base