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.

  1. Please be able to control Schedule the maintenance from the user's perspective.

    Users can decide when scheduled maintenance starts from in AWS.
    e.g. Maintenance refers to the application of OS and database security patches.

    Please be able to control schedule the maintenance in Azure Database for PostgreSQL from the users . It is problem that unexpected connection failures by maintenance in Azure Database.
    For pre-planned maintenance, the convenience of users will be improved , if schedule the maintenance can be controlled.

    AWS's Resource
    How do I minimize downtime during required Amazon RDS maintenance?
    URL: https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/?nc1=h_ls

    Maintaining a DB Instance
    URL: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Maintenance.html

    11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  3. ip4r extension

    It would be great to have the ip4r extension available in the Azure Database for PostgreSQL service. We already use this extension in our self-managed psql service to use IP addresses as native objects. It is very useful for some IPAM engines like nipapd, etc.

    For more information about this extension: https://github.com/RhodiumToad/ip4r

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  4. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Region  ·  Flag idea as inappropriate…  ·  Admin →
  5. Support for PGroonga

    PGroonga is a PostgreSQL extension to use Groonga as the index, and make PostgreSQL fast full text search platform for all languages (such as Japanese and Chinese).

    PGroonga: https://pgroonga.github.io/

    Groonga: http://groonga.org/

    6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  6. Support for Custom Full Text Search Dictionaries

    PostgreSQL supports so many great full text search capabilities that can be really handy in small to mid sized applications without adding the extra overhead of separate search services.

    https://www.postgresql.org/docs/9.6/textsearch-dictionaries.html

    When self-hosting PG you can add custom dictionaries, with custom synonym, thesaurus, stop word, and other stemming definitions. Currently Azure hosted PostgreSQL doesn't support this, as you'd need access to upload language and dictionary files to use in those definitions. For example, if you want a solid spellchecker via ispell or hunspell you can download those extensions and place them in the $SHAREDIR/tsearch_data directory on the PG server.

    Also -…

    6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  7. postgresql

    Provide a CLI inside the Azure Portal for the management of the database

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Support pg_prometheus extension

    It's a perfect fit together with timescaledb-extension if you have prometheus running in AKS

    14 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    22 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  20. effective_cache_size

    You should allow tuning of memory-related parameters. I have a 15GB server and the effectivecachesize 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
    (thinking…)
    Sign in with: Microsoft
    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

Categories

Feedback and Knowledge Base