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. Incremental long term backups taken per hour

    Can you please support the incremental long term backups taken per hour/day of azure sql databases and managed instance databases?

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Renaming a Postgres Server Name

    After promoting a replica DB to a standalone server with this command
    az postgres server replica stop -y -n -g

    The new promoted server name is taken from prompted replica server name (which in most cases the name contains a replica substring and after promotion it raises some ambiguity as a name for master database)

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Better support of AAD groups for audit purposes

    Currently there are two ways to authenticate with an Azure PostgreSQL database:
    1) as a user / managed identity
    2) as a group

    1) has the advantage that the correct user is logged in PostgreSQL's (audit) logs, but the disadvantage that a user has to be both created and authorized. Currently there is no automation that handles the creation/authorization.
    2) has the advantage that no user has to be manually created (only the group needs permissions), but the disadvantage that only the group name is logged in PostgreSQL's (audit) logs

    Currently there is no way to only use AAD groups…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Support Azure AD authentication for PostgreSQL Flexible Server as soon as possible

    It's exciting to see the improvements Azure Database for PostgreSQL Flexible Server (currently in Preview) has made over the old single server deployment model.

    However, at the moment it's missing a critical feature: Azure AD authentication, which is available in the older single server SKUs.

    Without this integration, VMs/Apps etc cannot utilize AAD managed identities to securely authenticate against the Flexible Server without using passwords. It's an important feature that I'm sure those who're on Single Server won't want to give up.

    Hopefully this can be accomplished by the time Flexible Server goes GA, or at least soon after that.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. pl/python

    When can we expect support for the PL/Python extension for the Azure Postgres Database. I would improve overall functionality massively.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  6. Service health notifications do not specify about PG minor version upgrades

    Neither Service health notifications do specify nor Azure publishes details in the RDS portal about PG minor version upgrades. Please try to enhance the notifications or by any means of communication in providing more details to the end users.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  7. MSSQL to PostgreSQL Migration Tools

    Current Azure Database Migration Guide does not support MSSQL to PostgreSQL migration. We hope this capability will be available in near future.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    This is extension is required in order to use the very popular and Open-Source Orange Reporting Service.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  9. In PostgreSQL 11 "REINDEX DATABASE" command used to run concurrently

    In PostgreSQL 11 "REINDEX DATABASE" command used to run concurrently, but in Azure PostgreSQL DB it doesn't. That's why I can't run the command - I can't make my server unresponsive for ~ 1 hour.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  10. Azure Database for PostgreSQL - IoT Edge support

    Similar to Azure SQL Database Edge - It would be great to have support for Azure Database for PostgreSQL running on IoT Edge.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Backup centre for Gov Cloud

    Backup centre for Gov Cloud

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Allow per-role log settings

    Due to the log_statement GUC being context superuser [1], it is not possible to set per-role logging; e.g. to log all data modifications of personalized accounts vs. application users. This makes auditing somewhat harder and it would be nice if there was a solution for this, though I understand this would likely mean changing upstream PostgreSQL

    [1] This is modified to rds_superuser for RDS Postgres

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Citus worker node storage having a limit of 2TiB.

    Why is the citus worker node storage having a limit of 2TiB. If one of my distributed column has data above 2TiB what is the strategy then. For eg. My distribution column is tenantId and for that tenantId there is data more than 2TiB.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Provide a way to alter pricing level from basic to general in postgressql in GUI

    Provide a way to use the portal GUI to alter the pricing level of a database from basic to general.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  15. Support Service Principal as Azure AD Administrator

    Azure Database for PostgreSQL supports setting an Azure AD Administrator and login in using Azure AD identities.

    However, the support is somewhat lacking compared to Azure SQL Database:


    • Configuring an Azure AD Administrator using an ARM template is not documented (though appears to work very similarly)


    • There does not appear to be a supported way of using a Service Principal, rather than a user, as the Azure AD Administrator for an instance.


    The latter is supported in Azure SQL Database, and it is very useful for entirely automated flows. It would be great it support for it was added.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. LTR for backup extended to 10 yrs

    35 days of max retention for Az Db for PG is too few for many customers. Moreover, the type of backup of the whole Postgres virtual server is not practical sometimes.
    MS offers LTR for individual Az SQL DBs. They should offer something similar for individual Postgres DBs (pg_dump style) with PiTR restores in the short term and option of LTR cold backups.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. AAD login to Postgress with password

    Hi,
    Currently I am login AAD to Postgres using 3 step method
    1. login to AZ
    2. generate access token
    3. Login to database

    instead of generating token and login to database. Can we directly use AAD password and connect to database in single step authentication

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  18. interactive

    Java, C++ are not my language, very technical. Interesting concept.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. pg_stat_statements

    The vendor of the application we are using[1] states in the documentation that the following PostgreSQL server parameter is mandatory:
    shared_preload_libraries = pg_stat_statements

    It does not seem possible to set this value in Azure Database for PostgreSQL server.

    We would like this capability so that we can host this app in Azure.


    1. https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#AWA/Admin/admin_PostgreSQL.htm

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  20. Database Gateway outage/maintenance

    When database Gateway has outage/maintenance, the connections in the current connection pool will be invalid, and the application will get a connection closed exception when uses these invalid connections.

    We have experienced this issue twice in the last 2 months, here are the tickets 120091923000210 and 120101323000265.

    The support team suggested us to re-try logic in the code, but it's not feasible in our application. In this case, it will be great to send us a alter then we know what happened, it will save us and the support team time to investigate the database.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    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