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. Add Support for PLV8 to Citus Cluster

    Currently Plv8 extension is supported for individual Azure Postgresql Instances, but it is not supported for the Citus clusters. This makes it impossible for ISVs to rely on scaling their PostgreSql solutions via Azure if they're using plv8. Please support plv8 for Citus so that there is a scalability path available to architects and ISVs.

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

    Would be very awesome to have built-in support for making database dumps.

    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 →
  3. Enable pg_autofailover on postgres 12 instance

    Please add postgres 12s auto failover for replicas.

    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 →
  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  ·  Flag idea as inappropriate…  ·  Admin →
  5. Provide ability to set "track_commit_timestamp" configuration parameter

    Implementing data synchronization that requires usage of
    "pgxactcommittimestamp". Enabling this requires "trackcommit_timestamp" configuration parameter to be set which is currently unavailable for Azure PostgreSQL.

    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 →
  6. create user from az cli

    Hello,
    It could be great to create user from az cli like
    "az postgres users create" The purpose of this feature allow me to create users automatically for a private postgres (without accessing the postgres from an outside machine or create a vm on the same subnet as my AKS)

    I would like to create several users, register them on k8s/secrets and run my software (and automatise these actions)

    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 →
  7. pg_stat_ssl view need to show client encryption status

    currently in Azure PostgreSQL database,

    pgstatssl view shows all connections from client as encrypted, which is false.

    I asked Azure support and the answer is because the client is connecting to a gateway instead of real server, and the gateway always connect to backend server encrypted, so pgstatssl is always showing the connection as encrypted.

    This defeated the purpose of pgstatssl view. I think it should be considered as a defect of Azure PostgresSQL .

    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. Multi master replication

    I'm a bit surprised to see that there is no support for multi master replication of postgres databases on Azure.

    This should have been considered when other replication features were requested and implemented.

    Please add support for multi master replication between any region without the arbitrary notion of partner and universal regions.

    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 →
  9. Support for postgres-elasticsearch-fdw

    It can be a lot of overhead fetching the data and then send to ES

    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 →
  10. Lower prices drastically for Azure Managed PostgreSQL

    I have been comparing the cost of managed Postgres on Azure to managed Postgres options on AWS and I'm absolutely floored at how much Azure charges.

    There is no way the current state of things is competitive! For people who have no choice, it seems like Azure is driving them away by deliberately making Postgres cost more than MSSQL.

    To make matters worse, the two only selectable basic tiers are so poor performing that they are totally unusable, taking literally upwards of 2 seconds for the most basic of queries on either the postgres system schema or my own application…

    1 vote
    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 →
  11. mysql_fdw

    please support mysql fdw for azure mysql databases

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

    pg_audit bugged?

    tried following the instructions to add the extension, I get error:

    The value 'pgaudit,timescaledb' for configuration 'sharedpreloadlibraries' is not valid. The allowed values are ', timescaledb'.

    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. Ability to use loopback IP in dblink as hostaddr

    In AWS when using dblink, you can use loopback IP 127.0.0.1 as hostaddr when you are using cross database queries. When we migrate from AWS PostgreSQL to Azure Database PostgreSQL, we need to point the hostname to either the instance IP or server name. Hopefully this will be a new feature so that we can do the migration without changing the our codes every time we migrate to another server. For more details, here's the case ID 120031124003015.

    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. Set the AD admin with API

    To be able to script the creation of a PostgreSQL Database, it could be great if it was possible to set the Azure AD admin with an API or Az CLI.

    Thanks,

    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 →
  15. Provide wal_level server parameter

    I wan to use debezium postgresql connector to my Azure database for postgresql . For that I need to set wal_level to logical but I dont find such server parameter.

    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. Monitor slow and long running queries on read replica

    Would be helpful to monitor and pull statistics for queries executed on replica in Query Performance Insights. Currently its not allowed for replica's as the query data store in Azure_sys Database is also replicated from master.

    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. PG_HBA: Sync rules from master to read replica to allow proper service failover

    As described in this issue (I won't rewrite the whole request again): https://github.com/MicrosoftDocs/azure-docs/issues/35906

    Azure's postgres PaaS is broken for the enterprise without this feature. I consider lack of this option a defect, not a feature request but am logging it here as directed.

    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. "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 →
  19. 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 →
  20. 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 →
  • Don't see your idea?

Azure Database for PostgreSQL

Categories

Feedback and Knowledge Base