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. Ability to set max_locks_per_transaction

    As a SaaS provider using postgresql schemas to separate clients we have a lot of tables, one set per customer schema. Some operations such as pg_dump, or schema migrations, takes locks on a lot of tables at once in the database, prior to dumping, or updating the database. For us this means that the default setting of 64 is too low and we'd like to be able to set the value ourself using parameters.

    2 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 →
  2. 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.

    21 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 →
  3. Make PostgreSQL on Azure support usable speeds and not be slow af.

    PostgreSQL on Azure is very outdated and extremely slow. It's very much unusable like this and we ended up moving to our own PostgreSQL container that don't have these issue. Please clarify that

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

    5 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 →
  5. prefix

    Add prefix extension

    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 →
  6. Support pg_prometheus extension

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

    9 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. 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.

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

    We’ll send you updates on this idea

    1 comment  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  8. oracle_fdw extension

    Provides a Foreign Data Wrapper for easy and efficient access to Oracle databases, including pushdown of WHERE conditions as well as comprehensive EXPLAIN and ANALYZE support.

    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 →
  9. PostGIS 3.0

    PostGIS 3.0 is currently in alpha. It adds support for parallels processing of spatial queries which drastically increases the performance of spatial queries and makes PostGIS more inline with other advanced spatial databases. Please upgrade to this version of PostGIS when it is fully released.

    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 →
  10. 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/

    4 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 →
  11. "Allow access to Azure Services" does not work for Flask Web App

    I have a Flask web app which using Azure PostgresSql server/db, the application running fine on my local machine, (I already added my local IP to azure postgresql server's firewall rules)
    But after I deployed the app to to Azure App Service, the web app failed to start, got this error:

    no pghba.conf entry for host "104.208.xx.***", user "pi", database "iotdb", SSL on
    2019-09-26T07:11:58.743294692Z FATAL: no pg
    hba.conf entry for host "104.208.xx.***", user "pi", database "iotdb", SSL on

    the option "Allow access to Azure Services" already enabled for the Azure PostgreSQL, but it does not work!

    I have to…

    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 →
  12. Allow admin user to be able to execute ALTER TABLE “my_table” DISABLE TRIGGER ALL

    Can the 'azurepgadmin' role be enhanced so that

    ERROR: permission denied: "my-trigger-name" is a system trigger

    is not encountered when executing

    ALTER TABLE “my_table” DISABLE TRIGGER ALL

    . The system trigger in question is one associated with a foreign key and the assocated triggers are system triggers.

    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 →
  13. 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 →
  14. 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 →
  15. Upgrade the available TimescaleDB extension from v1.1.1 to v1.3 or higher.

    Just wanted to upgrade the TimescaleDB extension from the current v1.1.1 to v1.3 or higher to be able to utilize the Continuous Aggregates feature.

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

    We’ll send you updates on this idea

    1 comment  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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 →
  17. Support creating VNET Service endpoint in Azure Red Hat OpenShift

    Even though Azure DB for PostgreSQL provides secure connection, Applications on ARO needs to access Azure DB for PostgreSQL via internet.

    Currently, VNET for ARO doesn't allow any modification, therefore, there is no option avoiding going through internet when applications connect to Azure DB for PostgreSQL.

    There is no point in deploying a DB container on ARO. The user needs to consider how to manage DB.

    If ARO allows modifying VNET creating Service endpoint for Azure DB for PostgreSQL, it could provide more secure route and low latency connections as well.

    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 →
  18. 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.

    8 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 →
  19. 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.

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

    We’ll send you updates on this idea

    under review  ·  8 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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.

    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 →
← Previous 1 3 4 5
  • Don't see your idea?

Azure Database for PostgreSQL

Categories

Feedback and Knowledge Base