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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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.

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

    We’ll send you updates on this idea

    6 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  2. 19 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  3. (Same-region) Read replicas

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

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

    We’ll send you updates on this idea

    14 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Same-region read replicas in Azure Database for PostgreSQL are out of public preview and are now generally available. You can create up to 5 read replicas for every master server.

    New functionality enabled as part of GA includes
    - Command line option for creating replicas https://docs.microsoft.com/azure/postgresql/howto-read-replicas-cli
    - Introduced parameters that are helpful for some replication scenarios: hot_standby_feedback, max_standby_archive_delay, max_standby_streaming_delay, vacuum_defer_cleanup_age

    Learn more about read replicas in the overview (https://docs.microsoft.com/azure/postgresql/concepts-read-replicas) and how to create replicas from the Azure portal (https://docs.microsoft.com/azure/postgresql/howto-read-replicas-portal).

    Thank you for your support of this feature.

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

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

    12 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 →
  6. 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.

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

    We’ll send you updates on this idea

    8 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  7. Target for Data Factory (ADF)

    Data Factory supports PostgreSQL and Azure PostgreSQL as sources. Please add them as targets.

    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 →
  8. 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 maxstandbystreaming_delay property for the read replicas. Setting it to -1 would enable to take dumps for larger databases of 100GB+.

    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 →
  9. PostgreSQL in West Central US region

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

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

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  Region  ·  Flag idea as inappropriate…  ·  Admin →
  10. TimescaleDB extension

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

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

    We’ll send you updates on this idea

    29 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →

    Today is a great day – we are very excited to announce that we have enabled TimescaleDB extension in Azure Database for PostgreSQL!

    Please refer to this Azure blog post for details: https://azure.microsoft.com/blog/power-iot-and-time-series-workloads-with-timescaledb-for-azure-database-for-postgresql/

    Our team worked closely with awesome TimescaleDB team to make it happen. Please let us know what you think.

    Nik on behalf of the Azure Database for PostgreSQL team

  11. Ability to set max_prepared_transactions is required

    Ability to set maxpreparedtransactions is required

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

    We’ll send you updates on this idea

    7 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →
  12. Vnet integration

    Join the PostgreSQL server to a Vnet so we can avoid the requirement to expose a public IP address to the wider internet. Or, create a setting to allow just access from a given App Service.

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

    We’ll send you updates on this idea

    11 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  13. (Cross-region) Read replicas

    Would be great to have an ability to have a master in one region (e.g. Central US) and read-only replicas in other regions (e.g. West/East US)

    (renamed; merged with "active geo-replication")

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

    We’ll send you updates on this idea

    6 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  14. Citus on Azure

    Azure team edit: Original ask (idea) was for Citus columnar store but then at some point it was merged with the ask for Citus on Azure Database for PostgreSQL. If you're interested in voting for Citus columnar datastore, please vote for it here: https://feedback.azure.com/forums/597976-azure-database-for-postgresql/suggestions/36622771-citus-columnar-datastore

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

    We’ll send you updates on this idea

    6 comments  ·  Extension  ·  Flag idea as inappropriate…  ·  Admin →

    Now Citus is available as a managed service on Azure! Today we announced Hyperscale (Citus) on Azure Database for PostgreSQL.

    - Learn more about Hyperscale (Citus) on Azure: https://azure.microsoft.com/blog/get-high-performance-scaling-for-your-azure-database-workloads-with-hyperscale/
    - You can create Hyperscale (Citus) server group in Azure portal: https://ms.portal.azure.com/#create/Microsoft.PostgreSQLServer

    If you have suggestion for Hyperscale (Citus) on Azure Database for PostgreSQL, please post them on this UserVoice forum.

    Azure Database for PostgreSQL team

  15. 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
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. PostGIS extension version 2.4

    Please add support for PostGIS extension version 2.4. It adds vector based tile support.

    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 →
  17. Support for DB larger than 1TB

    when will there be larger storage options for Azure DB for PostgreSQL

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

    We’ll send you updates on this idea

    1 comment  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  18. 31 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  19. PostgreSQL as a service in Azure China

    We have made good experience with PostgreSQL as a service in Azure already (even in Preview).
    We would like to use it also in Azure China.

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Roadmap  ·  Flag idea as inappropriate…  ·  Admin →
  20. GA timeline? Already 2018!

    Despite MS keep trying to say it will be GA by end of 2017, it is already 2018 and thus far a lot of critical features are missing and no sign for completion:


    1. Custom VNET

    2. Replication - it’s not just for redundancy, for horizontal scaling there is no way to not include replication

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

    We’ll send you updates on this idea

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

Azure Database for PostgreSQL

Categories

Feedback and Knowledge Base