
{"id":4607,"date":"2023-11-01T07:14:07","date_gmt":"2023-11-01T07:14:07","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=4607"},"modified":"2023-11-21T10:06:23","modified_gmt":"2023-11-21T10:06:23","slug":"logical-replication-from-standbys","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/","title":{"rendered":"Logical replication from Standbys"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\"><strong>Introduction:<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">One of the most useful features in PostgreSQL 16 is the ability to perform logical replication from physical replication standbys. This feature allows users to stream data to other PostgreSQL instances, giving developers new options for workload distribution. Additionally, it enables standbys to publish logical changes to other servers.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You may find valuable insights in our previous blog post titled Unleashing PG16 New Features <a href=\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a> <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This introductory piece explored the concept of Logical replication from a physical standby instance and laid the groundwork for the more detailed installation and configuration steps covered in this blog. If you haven&#8217;t already, we recommend giving it a read to gain an understanding of the topic before proceeding further.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example setup for Logical replication from a standby<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">In this example, I have three servers:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>one primary server<\/li>\n\n\n\n<li>two standby servers<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">One is used for streaming replication, while the other is for logical replication.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>In Primary server<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">In the primary server, we must create 2 users with replication privileges. For this example, I created a user for streaming the changes to the standby, and another to publish changes to the subscribers.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# \\du+\n                                    List of roles\n Role name |                         Attributes                         | Description\n-----------+------------------------------------------------------------+---\n postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS |\n pubuser   | Replication                                                           \n repuser   | Replication<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Next, I create a physical replication slot to copy changes from the primary to the standby.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" width=\"526\" height=\"82\" src=\"https:\/\/lh7-us.googleusercontent.com\/qxY27fPbL_JRtx_B7onEYFy1joTOFhieqSjIu65aVoOAJVk0ThnCcaP-h9rzgN7tG8XzVQJvrIQaarLNou8eT_PmyFxmPrurzlnl_IR0BVrr7TjF8uI6COEEN1Ay5sfjKnlq9THFa8l5n4IRjqrzhSOB7mi-MOYb\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I created two tables and granted privileges to <code>pubuser.<\/code><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>test=# GRANT SELECT ON TABLE t1,t2 TO pubuser;\nGRANT<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Now create <code>publication<\/code> for the tables on the primary server<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>test=# create publication testpub for all tables;\nCREATE PUBLICATION<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>In Standby1 server:<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">I&#8217;ve already created the standby server. Connecting to this standby will confirm it&#8217;s in read-only mode.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT pg_is_in_recovery();\n pg_is_in_recovery\n-------------------\n t<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">In the <code>postgresql.conf <\/code>file, we need to enable the following parameters:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>wal_level = logical\nhot_standby = on\nmax_wal_senders = 10  \nmax_replication_slots = 10\nhot_standby_feedback = on<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>In Standby2 server<\/strong>:<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Now, let&#8217;s create the subscription on the standby2 server using standy1 as the source:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" width=\"624\" height=\"75\" src=\"https:\/\/lh7-us.googleusercontent.com\/FS6f7QfDZRzhkqAwxbXZ04gfz-8xpqgEBGYGo3Xo05CYBLQ67RCPK3zoV4B3qiHwGlqUhqAfc4KSzIngz9LyhlLu72KeOtFSB1jM6CEdCSp3G1QmnidrHtaElTd6z0NFUoricHuVyrlJLqCrc47flsa1uUs6u8qA\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It may sometimes happen that this process isn\u2019t complete immediately because the standy1 is still waiting to sync up the data from the Primary server. If it does happen, our recourse is to call the<code> <strong>pg_log_standby_snapshot()<\/strong> <\/code>on the primary, so that the replication state gets refreshed on standby1, thereby allowing other replication commands to be executed on standby1 thereafter. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We can see the following in the screenshot below:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" width=\"362\" height=\"88\" src=\"https:\/\/lh7-us.googleusercontent.com\/pUlIMs6F4BGwLcEhCP3bXudts06b3RpeorO7uv5P03NJ1A1l96WpkbMQ5PCA80T5S7OCwLpBhmb5PqyxTwc9Nq-ZC7LywU1FOf_G8X7s1oY2LNU0jnpKlJYl04oigkhUrVLc6DWv-POy66N9DYXGBaZsLNRHVSzS\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now we can verify the replication state in the standby1 server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"172\" src=\"https:\/\/lh7-us.googleusercontent.com\/YruthmM-Tk8zNLr9aV3O70NqgGkBUtZLJnAcpZX431MeJWvwTZnAvDm7CgOWxBLtBAAO-mBalbwhyHHSdJC1zL5ZYevcYtuZKUE3uEpXxhb-hwCOHTgLDVda-Nsh8Rv6XoX4WV4DjecdKfp2Wpw1qbqmyu2rJLUa\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Summary<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQL&#8217;s evolution as a leading database platform continues to introduce new and robust data flow options. Logical replication from standbys, a feature that has seen continuous development and enhancements, takes a significant leap forward in PG 16, thanks to the tireless efforts of the PostgreSQL community. With this release, users will benefit from several powerful capabilities on standby servers, including the ability to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create logical replication slots<\/li>\n\n\n\n<li>Initiate logical decoding<\/li>\n\n\n\n<li>Subscribe to changes on a standby<\/li>\n\n\n\n<li>Persist logical replication slots even after a failover<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Furthermore, utilizing a standby server as a source for logical replication subscribers will be a seamless process, with only a handful of adjustments required:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enabling hot_standby_feedback = on<\/li>\n\n\n\n<li>Leveraging a physical replication slot to replicate data from the upstream to the standby<\/li>\n\n\n\n<li>Implementing pg_log_standby_snapshot() on the primary, ensuring subscribers don&#8217;t stall while creating a subscription to a standby.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: One of the most useful features in PostgreSQL 16 is the ability to perform logical replication from physical replication [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":4612,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[23,42,89],"tags":[44,90,26],"class_list":["post-4607","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql-14","category-postgresql-15","category-postgresql-16","tag-postgres15","tag-postgres16","tag-postgresql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Logical replication from Standbys - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Logical replication from Standbys - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Introduction: One of the most useful features in PostgreSQL 16 is the ability to perform logical replication from physical replication [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-01T07:14:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-21T10:06:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"883\" \/>\n\t<meta property=\"og:image:height\" content=\"883\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Venkat Akhil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Venkat Akhil\" \/>\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:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/\"},\"author\":{\"name\":\"Venkat Akhil\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\"},\"headline\":\"Logical replication from Standbys\",\"datePublished\":\"2023-11-01T07:14:07+00:00\",\"dateModified\":\"2023-11-21T10:06:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/\"},\"wordCount\":498,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png\",\"keywords\":[\"postgres15\",\"postgres16\",\"postgresql\"],\"articleSection\":[\"PostgreSQL 14\",\"PostgreSQL 15\",\"PostgreSQL 16\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/\",\"name\":\"Logical replication from Standbys - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png\",\"datePublished\":\"2023-11-01T07:14:07+00:00\",\"dateModified\":\"2023-11-21T10:06:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png\",\"width\":883,\"height\":883},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Logical replication from Standbys\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\",\"name\":\"Venkat Akhil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"caption\":\"Venkat Akhil\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Logical replication from Standbys - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Logical replication from Standbys - OpenSource DB","og_description":"Introduction: One of the most useful features in PostgreSQL 16 is the ability to perform logical replication from physical replication [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2023-11-01T07:14:07+00:00","article_modified_time":"2023-11-21T10:06:23+00:00","og_image":[{"width":883,"height":883,"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png","type":"image\/png"}],"author":"Venkat Akhil","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Venkat Akhil","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/"},"author":{"name":"Venkat Akhil","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328"},"headline":"Logical replication from Standbys","datePublished":"2023-11-01T07:14:07+00:00","dateModified":"2023-11-21T10:06:23+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/"},"wordCount":498,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png","keywords":["postgres15","postgres16","postgresql"],"articleSection":["PostgreSQL 14","PostgreSQL 15","PostgreSQL 16"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/","url":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/","name":"Logical replication from Standbys - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png","datePublished":"2023-11-01T07:14:07+00:00","dateModified":"2023-11-21T10:06:23+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png","width":883,"height":883},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/logical-replication-from-standbys\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Logical replication from Standbys"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328","name":"Venkat Akhil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","caption":"Venkat Akhil"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"}]}},"rttpg_featured_image_url":{"full":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png",883,883,false],"landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png",883,883,false],"portraits":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png",883,883,false],"thumbnail":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4-150x150.png",150,150,true],"medium":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4-300x300.png",300,300,true],"large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png",883,883,false],"1536x1536":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png",883,883,false],"2048x2048":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png",883,883,false],"ultp_layout_landscape_large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png",800,800,false],"ultp_layout_landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png",570,570,false],"ultp_layout_portrait":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png",600,600,false],"ultp_layout_square":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/11\/image-4.png",600,600,false]},"rttpg_author":{"display_name":"Venkat Akhil","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-15\/\" rel=\"category tag\">PostgreSQL 15<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-16\/\" rel=\"category tag\">PostgreSQL 16<\/a>","rttpg_excerpt":"Introduction: One of the most useful features in PostgreSQL 16 is the ability to perform logical replication from physical replication [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=4607"}],"version-history":[{"count":8,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4607\/revisions"}],"predecessor-version":[{"id":4851,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4607\/revisions\/4851"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media\/4612"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=4607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=4607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=4607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}