Do you have an idea or suggestion based on your experience with Azure Database for PostgreSQL?

(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

Anonymous shared this idea  ·   ·  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

14 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Jeb Garcia commented  ·   ·  Flag as inappropriate

    Is there any update on this? This is a very critical feature to have to run applications in production

  • Anonymous commented  ·   ·  Flag as inappropriate

    Huge bummer, this is exactly the kind of thing a cloud service is supposed to make easier.

  • AdminAzure Database for PostgreSQL Product Team (Product Owner, Microsoft Azure) commented  ·   ·  Flag as inappropriate

    Same region read replicas have been actively developed and are expected to be ready for private preview in the next 4-6 weeks. We will send invitation to those who voted for this idea once it is available.

    Pardon delay(s) and thank you for your patience! As a young Azure service (< 1 y.o.!) we sometimes set goals that are too ambitious and then have to adjust estimates for delivery. We're doing our best to avoid it going forward, i.e. provide estimates only when we have high confidence.

    Please feel free to e-mail us at AskAzureDBforPostgreSQL@service.microsoft.com if you have any additional questions or concerns.

    Nik on behalf of the Azure Database for PostgreSQL team

  • Josh commented  ·   ·  Flag as inappropriate

    We're waiting to migrate our infrastructure to Azure. This feature was promised in May-June timeframe. Then delayed a few months. We are losing confidence. If this isn't done by end of Q3, we will choose AWS.

  • York commented  ·   ·  Flag as inappropriate

    Do you have a better ETA now? we are in urgent need for read replicas. If it's not planned within 3 months, we may have to switch to other service providers. Thanks

  • Kaustubh Pimputkar commented  ·   ·  Flag as inappropriate

    I will echo the comment above. This (geo-redundant capabilities under the hood) is a critical feature for us as we mature our product into a client-offering stage.

  • Alf Normann Klausen commented  ·   ·  Flag as inappropriate

    Hi, I would be interessted in replicating my on-site PostgreSQL db to a "Azure DB for PostGreSQL" plaform service database. Would this be supported too?

  • Anonymous commented  ·   ·  Flag as inappropriate

    +1 native Postgres Streaming Replication functionality needs to be supported. This should allow you to replicate to another Postgres managed db in Azure, as well as replicate from an on-premises Postgres database to a managed instance in Azure using the native streaming replication.

    https://wiki.postgresql.org/wiki/Streaming_Replication

    This can be done with SQL server currently in Azure.

    Organizations need to do this so they can replicate source/transactional databases that sit behind applications to Azure for query/reporting offload.

  • Marc Sitges Puy commented  ·   ·  Flag as inappropriate

    I can't find the way to setup a replication ***** for this service. It shouldn't be that difficult, it is allowed for MySQL Azure service, which is also still on beta

  • William Yeung commented  ·   ·  Flag as inappropriate

    I just did a quick review on Azure PostgreSQL, while they said HA is built in, I don't know what they actually referring to- from this command I am not very assured:

    SELECT slot_name, database,
    active, pg_xlog_location_diff(pg_current_xlog_insert_location(), restart_lsn) AS retained_bytes FROM pg_replication_slots;

    This shows you there is no replication comes from the server at all. The worst part is you can't setup one either based on the current design. The best managed db example to follow should be heroku, which gives you complete ability to do fork and follow.

  • William Yeung commented  ·   ·  Flag as inappropriate

    Ability to setup replications is critical, I don't see medium to large enterprise use this product at all without ability to ensure replication in place.

Feedback and Knowledge Base