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. (Same-region) Read replicas

    (merged with "replication support or is that built in")

    79 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

      14 comments  ·  Flag idea as inappropriate…  ·  Admin →

      I’m happy to announce that same-region Read Replicas are now in public preview.

      You can start using them today in every region Azure Database for PostgreSQL is available.

      Thank you so much for being a supporter of this feature, and giving your feedback.

      Documentation:
      Overview -https://docs.microsoft.com/azure/postgresql/concepts-read-replicas
      How-to – https://docs.microsoft.com/azure/postgresql/howto-read-replicas-portal

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

    • support of orafce extension

      This extension enables Oracle’s compatibility functions and packages. We can also explore more the idea of ‘Bring your own extension’.

      19 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  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
      • pg_squeeze is an extension that removes unused space from a table and optionally sorts tuples according to particular index

        https://github.com/cybertec-postgresql/pg_squeeze
        pg_squeeze is an extension that removes unused space from a table and
        optionally sorts tuples according to particular index (as if CLUSTER [2]
        command was executed concurrently with regular reads / writes). In fact we try
        to replace pg_repack [1] extension.

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

            need-feedback  ·  1 comment  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
          • PostGIS 2.5

            Please upgrade PostGIS 2.4 to PostGIS 2.5 on PostgreSQL 10. Several new features were introduced in PostGIS 2.5 which speeds up spatial calculations.

            4 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

              1 comment  ·  Extension  ·  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 →
              • Execute SQL scripts during ARM Template Deployments

                After deploying a postgreSQL service using an ARM template, in order to configure my databases, roles, etc., I have to execute a script after I have deployed the service.

                I'd like a way to include a SQL script at time of deploying my ARM template.

                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  ·  Flag idea as inappropriate…  ·  Admin →
                • Citus columnar datastore

                  Azure team edit: I' creating this new idea on behalf of a customer to separate it from the votes for Citus on Azure Database for PostgreSQL. If you're interested in Citus columnar datastore (link below), please vote for this idea.
                  ++++

                  I need this to do big-ish data things:

                  https://www.citusdata.com/blog/2014/04/03/columnar-store-for-analytics/

                  I am a huge fan of postgresql for data warehousing, and this is a key thing for having the ability to summary large tables quickly.

                  4 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  ·  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.

                    44 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 →
                    • 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 →
                      • Replication delay configuration

                        First, thank you for providing read replicas. One thing that is still nessesary is the ability to tweak the replication configuration. If we want to take dumps from a medium (or larger) sized database directly from the replica, then this dump will be aborted because it simply takes too long.

                        This could be solved by enabling the max_standby_streaming_delay property for the read replicas. Setting it to -1 would enable to take dumps for larger databases of 100GB+.

                        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  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
                        • Implement PL/.NET Core for Stored Procedures, Triggers, and Functions in PostgreSQL

                          Implement PL/.NET Core support which will allow for Stored Procedures, Triggers, and Functions in PostgreSQL to be written in .NET Core

                          6 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  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
                          • PostgreSQL in West Central US region

                            It doesn't appear on the roadmap. Is this planned anytime soon?

                            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  ·  Region  ·  Flag idea as inappropriate…  ·  Admin →
                            • support the pg_hashids extension

                              Please add the following extension to postgres: https://hashids.org/postgresql/ it is a library to enable generating short slugs from integers. and the GitHub for it: https://github.com/iCyberon/pg_hashids

                              Thank you

                              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  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
                              • Resource Governace for CPU and Memory

                                We are running a multi-tenant system leveraging Azure PostgreSQL.
                                During heavy load, one Tenant can impact the system to a point where other databases are effected.

                                Wondering if you are planning to support some type of resource governance in the future similar to Azure SQL
                                https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor-resource-pool?view=sql-server-2017

                                I realize it wont be the same implementation, but maybe a new connectionstring parameter that could be set to limit CPU/Memory could be a start?

                                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  ·  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
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    1 comment  ·  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 →
                                    • Azure VNet in paired region

                                      For Azure SQL, service endpoint should allow traffic not only within a virtual network's region but also extend to include the paired region where the virtual network is deployed.

                                      (Idea submitted by Manish Kumar from the engineering group of Azure Database for PostgreSQL/MySQL service on behalf of one of our customers and in order to elicit feedback from other customers and users).

                                      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  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Stop/start server

                                        Gaging interest for being able to stop a server when it is not being used and restart it when needed.

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

                                          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  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5
                                          • Don't see your idea?

                                          Azure Database for PostgreSQL

                                          Feedback and Knowledge Base