{"id":28998,"date":"2023-11-06T08:09:18","date_gmt":"2023-11-06T07:09:18","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=28998"},"modified":"2023-11-06T08:09:18","modified_gmt":"2023-11-06T07:09:18","slug":"dbvisit-standbymp-for-postgresql-3-switchovers","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/","title":{"rendered":"DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In the last two posts (<a href=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a> and <a href=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>) we&#8217;ve installed and configured <a href=\"https:\/\/dbvisit.com\/solutions\/disaster-recovery-for-postgresql\" target=\"_blank\" rel=\"noreferrer noopener\">DBVISIT StandbyMP<\/a> for PostgreSQL and created a simple primary -&gt; replica setup. Most of the replication setup was GUI driven and almost nothing had to be done manually, except for the creation of a user and configuration of <a href=\"https:\/\/www.postgresql.org\/docs\/current\/auth-pg-hba-conf.html\" target=\"_blank\" rel=\"noreferrer noopener\">pg_hba.conf<\/a>. Currently we have the primary replicating to the replica and the StandbyMP management console managing this configuration:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"795\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912-1024x795.png\" alt=\"\" class=\"wp-image-29000\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912-1024x795.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912-300x233.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912-768x596.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912.png 1116w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">One advantage of such a setup is, that the replica can take over the role of the primary and vice versa, e.g. when patching is required on one of the nodes. In StandbyMP this is called a &#8220;Graceful Switchover&#8221;, so lets try to do this and see what happens:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"218\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120107-1024x218.png\" alt=\"\" class=\"wp-image-29001\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120107-1024x218.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120107-300x64.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120107-768x163.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120107-1536x326.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120107.png 1694w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"361\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120225-1024x361.png\" alt=\"\" class=\"wp-image-29002\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120225-1024x361.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120225-300x106.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120225-768x271.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120225.png 1528w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"117\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120312-1024x117.png\" alt=\"\" class=\"wp-image-29003\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120312-1024x117.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120312-300x34.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120312-768x87.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120312-1536x175.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_120312.png 1686w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This takes a few second and the instances will have switched the roles:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"145\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot_20231106_080311-1024x145.png\" alt=\"\" class=\"wp-image-29253\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot_20231106_080311-1024x145.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot_20231106_080311-300x42.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot_20231106_080311-768x108.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot_20231106_080311.png 1232w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The same works of course in the other direction. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you prefer a graphical user interface for setting up and operating a primary -&gt; replica configuration, then this could be an option for you. It is really easy to setup and you don&#8217;t have to touch the command line.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the last two posts (here and here) we&#8217;ve installed and configured DBVISIT StandbyMP for PostgreSQL and created a simple primary -&gt; replica setup. Most of the replication setup was GUI driven and almost nothing had to be done manually, except for the creation of a user and configuration of pg_hba.conf. Currently we have the&hellip;&nbsp;<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[],"class_list":["post-28998","post","type-post","status-publish","format-standard","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers - dbi services Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers\" \/>\n<meta property=\"og:description\" content=\"In the last two posts (here and here) we&#8217;ve installed and configured DBVISIT StandbyMP for PostgreSQL and created a simple primary -&gt; replica setup. Most of the replication setup was GUI driven and almost nothing had to be done manually, except for the creation of a user and configuration of pg_hba.conf. Currently we have the&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-06T07:09:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1116\" \/>\n\t<meta property=\"og:image:height\" content=\"866\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers\",\"datePublished\":\"2023-11-06T07:09:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/\"},\"wordCount\":191,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Screenshot_20231030_115912-1024x795.png\",\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/\",\"name\":\"DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Screenshot_20231030_115912-1024x795.png\",\"datePublished\":\"2023-11-06T07:09:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Screenshot_20231030_115912.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Screenshot_20231030_115912.png\",\"width\":1116,\"height\":866},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-3-switchovers\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"caption\":\"Open source Team\"},\"description\":\"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/open-source-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers - dbi services Blog","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:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/","og_locale":"en_US","og_type":"article","og_title":"DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers","og_description":"In the last two posts (here and here) we&#8217;ve installed and configured DBVISIT StandbyMP for PostgreSQL and created a simple primary -&gt; replica setup. Most of the replication setup was GUI driven and almost nothing had to be done manually, except for the creation of a user and configuration of pg_hba.conf. Currently we have the&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2023-11-06T07:09:18+00:00","og_image":[{"width":1116,"height":866,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912.png","type":"image\/png"}],"author":"Open source Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Open source Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers","datePublished":"2023-11-06T07:09:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/"},"wordCount":191,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912-1024x795.png","articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/","url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/","name":"DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912-1024x795.png","datePublished":"2023-11-06T07:09:18+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_115912.png","width":1116,"height":866},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-3-switchovers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DBVISIT StandbyMP for PostgreSQL \u2013 3 \u2013 Switchovers"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","caption":"Open source Team"},"description":"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.","url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/28998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=28998"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/28998\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=28998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=28998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=28998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}