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. 2 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Ability to output data changes via logical decoding (ex. wol2json)

      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
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        under review  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Add Central US Region

        We would love to move to Azure Database for PostgreSQL but need it to be available in Central US.

        14 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Flag idea as inappropriate…  ·  Admin →

          First, thank you for your feedback. Your votes count and are very much appreciated.

          We have been working on enabling Azure Database for PostgreSQL service in as many Azure regions as possible as soon as possible. As you see we have already enabled our service in North Central US and South Central US regions (https://azure.microsoft.com/en-us/regions/services/).

          We don’t have specific time frame for enabling Central US region. Our best estimate at this point is that it will become available some time in 2018.

          Azure Database for PostgreSQL/MySQL team

        • Need test_parser extension

          We are using tsvector for full text search.
          And we want to use test_parser extension.

          Although test_parser's doc says "It doesn't do anything especially useful".
          It is actually very useful when using custom tokenizer.

          test_parser is available on Amazon RDS
          http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html

          20 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            under review  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Close SSL connections gracefully

            When the client closes a Postgres connection (by sending the "X" command) that uses SSL, a normal Postgres server sends SSL "close_notify" alert, thus closing the connection gracefully (client sees graceful "end of stream").

            With Azure PostgreSQL, I see just a TCP RST packet, and the client sees an abrutly terminated connection.

            This causes unnecessary errors with at least some Postgresql client libraries. For example, the current version of Node.js pg / node-postgres library.

            3 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Be able to create instances within the local virtual network.

              Because our application does not use ssl connection、So
              the db instances must can be created within the local virtual network.

              5 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • pgagent extension

                We need to run regular maintenance tasks on our database, which we usually perform with pgagent https://www.pgadmin.org/docs/pgadmin3/1.22/pgagent.html

                Pgagent will be installed as a service on the application server, but for pgagent to work we need the pgagent extension deployed in the application database, see also https://www.pgadmin.org/docs/pgadmin3/1.22/pgagent-install.html#database-setup

                2 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • dblink extension

                  Please add dblink extension

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Support stored procedures in Python

                    I would like Azure to be the first cloud service to support the Pl/Pythonu extension. There are security risks involved with supporting this extension, so innovation will be needed, but I believe there is a huge machine learning community that would enjoy it if they could run Python code close to their data.

                    3 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Germany

                      When will this be available in region germanycentral?

                      3 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        planned  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Temporal Tables PostgreSQL Extension

                        Support temporal tables extension to provide part of the features similar to SQL Server Temporal Tables.

                        7 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Azure Powershell SDK support for PostgreSQL

                          There are great ways to manage the PostgreSQL in Azure via the Azure CLI. https://docs.microsoft.com/en-us/azure/postgresql/sample-scripts-azure-cli.

                          It would be great to get this possibility as well in Powershell

                          2 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            planned  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Add Australian regions

                            We would love to use Azure Database for PostgreSQL if it was available in either (both) of the Australia East or Australia Southeast regions.

                            10 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Documentation of what Postgres HA really means

                              No way anyone can trust the HA approach unless its somewhat documented? Is it syncronous, semi? Does it occur through PG replication, if so what type? Is it block level with a warm standby? How does failover occur? Do clients need to worry about failover? How long does failover usually take. Promising a PG HA solution without some type of information such as this is not professional.

                              11 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                planned  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                              • The ability to set collation on db-create

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

                                5 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • Firewall Option: Auto-enable other Azure Services

                                  As known from the MS SQL Database service, there should be an option to enable other Azure Services (e.g. Web Apps) to connect the database without white-listing every single IP.

                                  31 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    started  ·  6 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Configurable autovacuum

                                    Our database is in use, in reading and writing, 24 hours per day through batch elaborations and online transactional operations. In our scenario, the auto vacuum is dangerous because it can slow down operations in the wrong moment of the day causing low answer times or even unavailability of our web application.

                                    For this reason, we decided to turn off the auto vacuum and manage manually the maintenance routine of our tables: we use pgagent to schedule daily vacuum analyze of our tables and manually run vacuum full on large tables when needed (eg. their size on disk is too…

                                    3 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 3 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • TimescaleDB extension

                                        Support TimescaleDB extension to postgresql
                                        https://github.com/timescale/timescaledb

                                        16 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          planned  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Rebuild PostgreSQL with libxml option

                                          When I tried to insert XML data, following error occurs and cannot insert XML data to Azure Database for PostgreSQL.

                                          Errors:
                                          BaseMessage:unsupported XML feature
                                          Detail:This functionality requires the server to be built with libxml support.
                                          Hint:You need to rebuild PostgreSQL using --with-libxml.

                                          From the error message, we need to rebuild the PostgreSQL with libxml option, but I don’t think Azure Database for PostgreSQL have such a feature right now.
                                          Please add the feature so that we could migrate our application to "Azure Database for PostgreSQL."

                                          10 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            planned  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Azure Database for PostgreSQL

                                          Feedback and Knowledge Base