{"id":1753,"date":"2019-01-28T00:00:00","date_gmt":"2019-01-28T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview"},"modified":"2025-06-11T05:45:49","modified_gmt":"2025-06-11T12:45:49","slug":"read-replicas-for-azure-database-for-postgresql-now-in-preview","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/","title":{"rendered":"Read Replicas for Azure Database for PostgreSQL now in preview"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><em>This blog is co-authored by Parikshit Savjani, Senior Program Manager and Rachel Agyemang, Program Manager, Microsoft Azure. <\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We are excited to announce <strong>public preview<\/strong> availability of <strong>Read Replicas for Azure Database for PostgreSQL<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/aka.ms\/postgresql\">Azure Database for PostgreSQL<\/a> now supports continuous, asynchronous replication of data from one Azure Database for PostgreSQL server (the \u201cmaster\u201d) to up to five Azure Database for PostgreSQL servers (the \u201cread replicas\u201d) in the same region. This allows read-heavy workloads to scale out horizontally and be balanced across replica servers according to users&#8217; preferences. Replica servers are read-only except for writes replicated from data changes on the master. Stopping replication to a replica server causes it to become a standalone server that accepts reads and writes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Key features associated with this functionality are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Turn-key addition and deletion of replicas.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Support for up to five read replicas in the same region.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">The ability to stop replication to any replica to make it a stand-alone, read-write server.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">The ability to monitor replication performance using two metrics, Replica Lag and Max lag across Replicas.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">For more information and instructions on how to create and manage read replicas, see the following articles:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/postgresql\/concepts-read-replicas\">Read replicas in Azure Database for PostgreSQL<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/postgresql\/howto-read-replicas-portal\">How to create and manage read replicas in Azure Database for PostgreSQL using the Azure portal<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">We are sharing some of the application patterns and reference architectures which our customers and partners have implemented leveraging the read replicas for scaling out their workload.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"microservices-pattern-with-read-scale-replicas\">Microservices Pattern with Read scale Replicas<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In this architecture pattern, the application is broken into multiple microservices with data modification APIs connecting to master server while reporting APIs connecting to read replicas. The data modification APIs are prefixed with \u201cSet-\u201d while reporting APIs are prefixed with \u201cGet-\u201c. The load balancer is used to route the traffic based on the API prefix.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp\" alt=\"2019-01-24_14-47-27\" style=\"border-radius:0px\" title=\"2019-01-24_14-47-27\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"bi-reporting\">BI Reporting<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For BI Reporting workload, data from disparate data sources is processed every few mins and loaded in the master server. The master server is dedicated for loads and processing not directly exposing it to BI users for reporting or analytics to ensure predictable performance. The reporting workload is scaled out across multiple read replicas to manage high user concurrency with low latency.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/39afb46f-ae0c-4e46-ae85-efaa1555ce9d.webp\" alt=\"image\" style=\"border-radius:0px\" title=\"image\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"iot-scenario\">IoT scenario<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For IoT scenario, the high-speed streaming data is loaded first in master node as a persistent layer. The master server is used for high speed data ingestion. The read replicas are leveraged for reporting and downstream data processing to take data driven actions.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/e281f533-e977-476d-9346-9d815bb5a5d8.webp\" alt=\"image\" style=\"border-radius:0px\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">We hope that you enjoy working with the latest features and functionality available in our Azure database service for PostgreSQL. Be sure to share your impressions via <a href=\"https:\/\/nam06.safelinks.protection.outlook.com\/?url=https%3A%2F%2Ffeedback.azure.com%2Fforums%2F597976-azure-database-for-postgresql&amp;data=02%7C01%7CKalyan.Sayyaparaju%40microsoft.com%7C2007f9b0dd8f4838f79208d67d86a468%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636834414829341130&amp;sdata=2llDF0Yx5TR1qAc9g%2FXC2TPuzzc9MEcBiY7gcli5dNc%3D&amp;reserved=0\">User Voice for PostgreSQL<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"additional-resources-for-azure-database-for-postgresql\">Additional resources for Azure Database for PostgreSQL<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/aka.ms\/PostgreSQL\">Service information<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/nam06.safelinks.protection.outlook.com\/?url=https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fpostgresql%2F&amp;data=02%7C01%7CKalyan.Sayyaparaju%40microsoft.com%7C2007f9b0dd8f4838f79208d67d86a468%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636834414829351138&amp;sdata=%2BGj5KlEJdWHYlUVxHv40%2FpBVIQCo0%2F1bhP5tSJwB0gc%3D&amp;reserved=0\">Documentation<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/nam06.safelinks.protection.outlook.com\/?url=https%3A%2F%2Ffeedback.azure.com%2Fforums%2F597976-azure-database-for-postgresql&amp;data=02%7C01%7CKalyan.Sayyaparaju%40microsoft.com%7C2007f9b0dd8f4838f79208d67d86a468%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636834414829351138&amp;sdata=753s%2BoYo4lUPh2smeND%2BIlmSFsUQ37MIYO7t%2BH4cX4k%3D&amp;reserved=0\">Feedback forum<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to announce public preview availability of Read Replicas for Azure Database for PostgreSQL. Azure Database for PostgreSQL now supports continuous, asynchronous replication of data from one Azure Database for PostgreSQL server (the &#8220;master\u201d) to up to five Azure Database for PostgreSQL servers (the \u201cread replicas\u201d) in the same region.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473,1466],"tags":[],"audience":[3057,3055,3056],"content-type":[],"product":[1565],"tech-community":[],"topic":[],"coauthors":[661],"class_list":["post-1753","post","type-post","status-publish","format-standard","hentry","category-databases","category-hybrid-multicloud","audience-data-professionals","audience-developers","audience-it-implementors","product-azure-database-for-postgresql","review-flag-iot-1680286585-835","review-flag-publi-1680286584-566"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Read Replicas for Azure Database for PostgreSQL now in preview | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"We are excited to announce public preview availability of Read Replicas for Azure Database for PostgreSQL. Azure Database for PostgreSQL now supports continuous, asynchronous replication of data from one Azure Database for PostgreSQL server (the &quot;master\u201d) to up to five Azure Database for PostgreSQL servers (the \u201cread replicas\u201d) in the same region.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Read Replicas for Azure Database for PostgreSQL now in preview | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to announce public preview availability of Read Replicas for Azure Database for PostgreSQL. Azure Database for PostgreSQL now supports continuous, asynchronous replication of data from one Azure Database for PostgreSQL server (the &quot;master\u201d) to up to five Azure Database for PostgreSQL servers (the \u201cread replicas\u201d) in the same region.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-28T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T12:45:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp\" \/>\n<meta name=\"author\" content=\"Kalyan Sayyaparaju\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kalyan Sayyaparaju\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/kalyan-sayyaparaju\/\",\"@type\":\"Person\",\"@name\":\"Kalyan Sayyaparaju\"}],\"headline\":\"Read Replicas for Azure Database for PostgreSQL now in preview\",\"datePublished\":\"2019-01-28T00:00:00+00:00\",\"dateModified\":\"2025-06-11T12:45:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/\"},\"wordCount\":464,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp\",\"articleSection\":[\"Databases\",\"Hybrid + multicloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/\",\"name\":\"Read Replicas for Azure Database for PostgreSQL now in preview | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp\",\"datePublished\":\"2019-01-28T00:00:00+00:00\",\"dateModified\":\"2025-06-11T12:45:49+00:00\",\"description\":\"We are excited to announce public preview availability of Read Replicas for Azure Database for PostgreSQL. Azure Database for PostgreSQL now supports continuous, asynchronous replication of data from one Azure Database for PostgreSQL server (the \\\"master\u201d) to up to five Azure Database for PostgreSQL servers (the \u201cread replicas\u201d) in the same region.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Read Replicas for Azure Database for PostgreSQL now in preview\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Read Replicas for Azure Database for PostgreSQL now in preview | Microsoft Azure Blog","description":"We are excited to announce public preview availability of Read Replicas for Azure Database for PostgreSQL. Azure Database for PostgreSQL now supports continuous, asynchronous replication of data from one Azure Database for PostgreSQL server (the \"master\u201d) to up to five Azure Database for PostgreSQL servers (the \u201cread replicas\u201d) in the same region.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/","og_locale":"en_US","og_type":"article","og_title":"Read Replicas for Azure Database for PostgreSQL now in preview | Microsoft Azure Blog","og_description":"We are excited to announce public preview availability of Read Replicas for Azure Database for PostgreSQL. Azure Database for PostgreSQL now supports continuous, asynchronous replication of data from one Azure Database for PostgreSQL server (the \"master\u201d) to up to five Azure Database for PostgreSQL servers (the \u201cread replicas\u201d) in the same region.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2019-01-28T00:00:00+00:00","article_modified_time":"2025-06-11T12:45:49+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp","type":"","width":"","height":""}],"author":"Kalyan Sayyaparaju","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Kalyan Sayyaparaju","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/kalyan-sayyaparaju\/","@type":"Person","@name":"Kalyan Sayyaparaju"}],"headline":"Read Replicas for Azure Database for PostgreSQL now in preview","datePublished":"2019-01-28T00:00:00+00:00","dateModified":"2025-06-11T12:45:49+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/"},"wordCount":464,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp","articleSection":["Databases","Hybrid + multicloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/","name":"Read Replicas for Azure Database for PostgreSQL now in preview | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp","datePublished":"2019-01-28T00:00:00+00:00","dateModified":"2025-06-11T12:45:49+00:00","description":"We are excited to announce public preview availability of Read Replicas for Azure Database for PostgreSQL. Azure Database for PostgreSQL now supports continuous, asynchronous replication of data from one Azure Database for PostgreSQL server (the \"master\u201d) to up to five Azure Database for PostgreSQL servers (the \u201cread replicas\u201d) in the same region.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/01\/d0c4b02c-769c-4d85-87c9-63cc00bee90a.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/read-replicas-for-azure-database-for-postgresql-now-in-preview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Read Replicas for Azure Database for PostgreSQL now in preview"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=1753"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1753\/revisions"}],"predecessor-version":[{"id":41431,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1753\/revisions\/41431"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=1753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=1753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=1753"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=1753"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=1753"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=1753"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=1753"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=1753"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=1753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}