(Same-region) Read replicas
(merged with "replication support or is that built in")
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.
Rachel, on behalf of the Azure Database for PostgreSQL team
Jeb Garcia commented
Is there any update on this? This is a very critical feature to have to run applications in production
tyler weston commented
Hello. It has been a few months. Any update?
Hello, how is going? is there any ETA to that replication feature?
Huge bummer, this is exactly the kind of thing a cloud service is supposed to make easier.
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
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.
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
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
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?
marco caminiti commented
Exist a roadmap for this feature? an estimated time?
+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.
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
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
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
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.