{"id":28934,"date":"2023-10-27T15:37:00","date_gmt":"2023-10-27T13:37:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=28934"},"modified":"2023-10-27T15:37:00","modified_gmt":"2023-10-27T13:37:00","slug":"dbvisit-standbymp-for-postgresql-1-setting-it-up","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/","title":{"rendered":"DBVISIT StandbyMP for PostgreSQL &#8211; 1 &#8211; Setting it up"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">One of our oldest partners, <a href=\"https:\/\/www.dbi-services.com\/technologies\/dbvisit\/\" target=\"_blank\" rel=\"noreferrer noopener\">DBVISIT<\/a>, recently released their product <a href=\"https:\/\/dbvisit.com\/solutions\/disaster-recovery-for-postgresql\" target=\"_blank\" rel=\"noreferrer noopener\">StandbyMP<\/a> for PostgreSQL. The goal of this product is to provide a graphical user and management interface over a PostgreSQL streaming replication cluster. In this post we&#8217;re going to set this up, and in a follow up post we&#8217;ll see how this product can be used to easily switchover to a replica and recover from failures.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We&#8217;ll be using three <a href=\"https:\/\/www.suse.com\/products\/server\/\" target=\"_blank\" rel=\"noreferrer noopener\">SLES 15<\/a> nodes for this setup (system requirements <a href=\"https:\/\/dbvisit.atlassian.net\/wiki\/spaces\/DSMP\/pages\/3238264943\/System+Requirements#3.2.--Linux\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>), and this is how it is going to look like:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"582\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252.png\" alt=\"\" class=\"wp-image-28937\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252-300x186.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252-768x476.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">There needs to be an agent installed on the database nodes, and a management console either on a third node (preferred) or on the replica node.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The only requirement to get started is, that the operating systems are already running (of course), the PostgreSQL binaries are installed on the database nodes and a PostgreSQL instance is already running on one of the database nodes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Taking the picture from above, a PostgreSQL instance is already running on the left database node:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [1]; title: ; notranslate\" title=\"\">\npostgres@sles15-dbvisit-db1:\/home\/postgres\/ &#x5B;PG1] psql -c &quot;select version()&quot;;\n                                                version                                                \n-------------------------------------------------------------------------------------------------------\n PostgreSQL 16.0 on x86_64-pc-linux-gnu, compiled by gcc (SUSE Linux) 7.5.0, 64-bit\n(1 row)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">The next step is to install the agent on both the database nodes (software can be downloaded from <a href=\"https:\/\/dbvisit.com\/try-standby#full-trial\">here<\/a>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We&#8217;re going to install the product into a dedicated directory:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\npostgres@sles15-dbvisit-db1:\/home\/postgres\/ &#x5B;PG1] mkdir \/u01\/app\/postgres\/product\/dbvisit\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">As it is not recommended to run the installer from the target directory we&#8217;ll start from \/tmp:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [1,2,5,9,10]; title: ; notranslate\" title=\"\">\npostgres@sles15-dbvisit-db1:\/home\/postgres\/ &#x5B;PG1] cd \/tmp\/\n15:03:55 postgres@sles15-dbvisit-db1:\/tmp\/ &#x5B;PG1] unzip Dbvisit_StandbyMP-v11.5.0-linux.zip\nArchive:  Dbvisit_StandbyMP-v11.5.0-linux.zip\n  inflating: standby-v11.5.0.tar.gz  \n15:04:02 postgres@sles15-dbvisit-db1:\/tmp\/ &#x5B;PG1] ls\nDbvisit_StandbyMP-v11.5.0-linux.zip  systemd-private-9042516f97e94fdaa06816cca20aa6ee-systemd-logind.service-rHTenh\nstandby-v11.5.0.tar.gz\n15:04:09 postgres@sles15-dbvisit-db1:\/tmp\/ &#x5B;PG1] tar axf standby-v11.5.0.tar.gz \n15:04:36 postgres@sles15-dbvisit-db1:\/tmp\/ &#x5B;PG1] ls\nDbvisit_StandbyMP-v11.5.0-linux.zip  standby-v11.5.0.tar.gz\ninstall-agent-v11.5.0                systemd-private-9042516f97e94fdaa06816cca20aa6ee-systemd-logind.service-rHTenh\ninstall-control-v11.5.0\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">This gives us two installers, one for the agent and another one for the console. As we&#8217;re on a database node we start with the agent installer. We&#8217;ll just run it and follow the instructions:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [1,13,14,21,22,23,24,29,30]; title: ; notranslate\" title=\"\">\npostgres@sles15-dbvisit-db1:\/tmp\/ &#x5B;PG1] .\/install-agent-v11.5.0\n+----------------------------------------------------------------------+\n|          ____  _                  _ _           __  __ ____          |\n|         \/ ___|| |_ __ _ _ __   __| | |__  _   _|  \\\/  |  _ \\         |\n|         \\___ \\| __\/ _&#039; | &#039;_ \\ \/ _&#039; | &#039;_ \\| | | | |\\\/| | |_) |        |\n|          ___) | || (_| | | | | (_| | |_) | |_| | |  | |  __\/         |\n|         |____\/ \\__\\__,_|_| |_|\\__,_|_.__\/ \\__, |_|  |_|_|            |\n|          Copyright 2022                   |___\/   By Dbvisit         |\n+----------------------------------------------------------------------+\n\nWelcome to Dbvisit StandbyMP setup version v11.5.0.\n\n? Please carefully read the end-user license agreement at https:\/\/dbvisit.com\/eula. Do you agree to the terms of this agreement? Yes\n? Which directory should the software be installed into? \/u01\/app\/postgres\/product\/dbvisit\n\n- - - You are now configuring the Dbvisit StandbyMP Agent - - -\n\nThe Agent will listen on the following discovered addresses:\n -  127.0.0.1\n -  192.168.122.61\n? Agent File Transfer Port: 7890\n? Fully Qualified Domain Name for this host: sles15-dbvisit-db1.it.dbi-services.com\n? Fully Qualified Domain Name for the Control Center: sles15-dbvisit-mgmt.it.dbi-services.com\n? Agent Communications Port: 5533\nEach Dbvisit StandbyMP Agent and the Dbvisit StandbyMP Control Center must\nbe configured with the same passphrase. This is how we know that they are all\nintended to be part of the same system. Please specify a strong passphrase - we\nsuggest at least 12 characters, containing at least 2 numbers and 2 symbols.\n? Passphrase: ********\n? Confirm Passphrase: ********\n\n- - - Dbvisit StandbyMP Agent configuration finished - - -\n\n\n- - - Ready to perform installation - - -\n\n? Do you wish to proceed with the setup using the supplied configuration options? Proceed with setup\n\n- - - Performing installation - - -\n\nCopying software files to &#039;\/u01\/app\/postgres\/product\/dbvisit&#039;...\nWriting Agent configuration file &#039;\/u01\/app\/postgres\/product\/dbvisit\/standbymp\/conf\/dbvagentmanager.ini&#039;...\n\n- - - File creation complete - - -\n\n\nTo enable the installed Dbvisit StandbyMP components to run as system services, you will need to execute some commands as the &quot;root&quot; user in order to complete the setup.\n\nTo install the system service(s), you can run, substituting the name of the user to run as if it is different from the current user:\n        sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvagentmanager service install --user postgres\nTo start the system service(s), you can run:\n        sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvagentmanager service start\n\n- - - Installation successful! - - -\n\n\n- - - Configuration Summary - - -\n\nInstall Directory:                                  \/u01\/app\/postgres\/product\/dbvisit\nFully Qualified Domain Name for this host:          sles15-dbvisit-db1.it.dbi-services.com\nFully Qualified Domain Name for the Control Center: sles15-dbvisit-mgmt.it.dbi-services.com\nAgent Communications Port:                          5533\nAgent File Transfer Port:                           7890\n\n- - - Installation Summary - - -\n\nThe following actions have been performed:\n -  Installed Dbvisit StandbyMP Agent software into: \/u01\/app\/postgres\/product\/dbvisit\/standbymp\n -  Agent settings are available in the configuration file: \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/conf\/dbvagentmanager.ini\n -  Generated new security certificates in: \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/certificates\n\n- - - INSTALLATION SUCCESSFUL - - -\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Finally register the service and start it up, as described in the output of the installer:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [1,2,3,5]; title: ; notranslate\" title=\"\">\npostgres@sles15-dbvisit-db1:\/tmp\/ &#x5B;PG1] sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvagentmanager service install --user postgres\n15:15:45 postgres@sles15-dbvisit-db1:\/tmp\/ &#x5B;PG1] sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvagentmanager service start\npostgres@sles15-dbvisit-db1:\/tmp\/ &#x5B;PG1] systemctl list-unit-files | grep dbv\ndbvagentmanager.service                                                   enabled         disabled\npostgres@sles15-dbvisit-db1:\/tmp\/ &#x5B;PG1] systemctl status dbvagentmanager.service\n\u25cf dbvagentmanager.service - The Dbvisit StandbyMP Agent provides connectivity to databases on this computer. This Agent is used &amp; ma&gt;\n     Loaded: loaded (\/etc\/systemd\/system\/dbvagentmanager.service; enabled; vendor preset: disabled)\n     Active: active (running) since Fri 2023-10-27 15:15:54 CEST; 39s ago\n   Main PID: 18210 (dbvagentmanager)\n      Tasks: 7\n     CGroup: \/system.slice\/dbvagentmanager.service\n             \u2514\u2500 18210 \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvagentmanager service run\n\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Once it is up and running repeat all the steps on the remaining database node.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The installation of the console (or the control center) on the third node is very much the same, except that the other installer is used:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [1,13,14,21,22,27,28]; title: ; notranslate\" title=\"\">\npostgres@sles15-dbvisit-mgmt:\/tmp&gt; .\/install-control-v11.5.0 \n+----------------------------------------------------------------------+\n|          ____  _                  _ _           __  __ ____          |\n|         \/ ___|| |_ __ _ _ __   __| | |__  _   _|  \\\/  |  _ \\         |\n|         \\___ \\| __\/ _&#039; | &#039;_ \\ \/ _&#039; | &#039;_ \\| | | | |\\\/| | |_) |        |\n|          ___) | || (_| | | | | (_| | |_) | |_| | |  | |  __\/         |\n|         |____\/ \\__\\__,_|_| |_|\\__,_|_.__\/ \\__, |_|  |_|_|            |\n|          Copyright 2022                   |___\/   By Dbvisit         |\n+----------------------------------------------------------------------+\n\nWelcome to Dbvisit StandbyMP setup version v11.5.0.\n\n? Please carefully read the end-user license agreement at https:\/\/dbvisit.com\/eula. Do you agree to the terms of this agreement? Yes\n? Which directory should the software be installed into? \/u01\/app\/postgres\/product\/dbvisit\n\n- - - You are now configuring the Dbvisit StandbyMP Control Center - - -\n\nThe Control Center will listen on the following discovered addresses:\n -  127.0.0.1\n -  192.168.122.63\n? Control Center Web Server Port: 4433\n? Agent Communications Port: 5533\nEach Dbvisit StandbyMP Agent and the Dbvisit StandbyMP Control Center must\nbe configured with the same passphrase. This is how we know that they are all\nintended to be part of the same system. Please specify a strong passphrase - we\nsuggest at least 12 characters, containing at least 2 numbers and 2 symbols.\n? Passphrase: ********\n? Confirm Passphrase: ********\n\n- - - Dbvisit StandbyMP Control Center configuration finished - - -\n\n\n- - - Ready to perform installation - - -\n\n? Do you wish to proceed with the setup using the supplied configuration options? Proceed with setup\n\n- - - Performing installation - - -\n\nCopying software files to &#039;\/u01\/app\/postgres\/product\/dbvisit&#039;...\nWriting Control Center configuration file &#039;\/u01\/app\/postgres\/product\/dbvisit\/standbymp\/conf\/dbvcontrol.ini&#039;...\n\n- - - File creation complete - - -\n\n\nTo enable the installed Dbvisit StandbyMP components to run as system services, you will need to execute some commands as the &quot;root&quot; user in order to complete the setup.\n\nTo install the system service(s), you can run, substituting the name of the user to run as if it is different from the current user:\n        sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvcontrol service install --user postgres\nTo start the system service(s), you can run:\n        sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvcontrol service start\n\n- - - Installation successful! - - -\n\n\n- - - Configuration Summary - - -\n\nInstall Directory:              \/u01\/app\/postgres\/product\/dbvisit\nControl Center Web Server Port: 4433\nAgent Communications Port:      5533\n\n- - - Installation Summary - - -\n\nThe following actions have been performed:\n -  Installed Dbvisit StandbyMP Control Center software into: \/u01\/app\/postgres\/product\/dbvisit\/standbymp\n -  Control Center settings are available in the configuration file: \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/conf\/dbvcontrol.ini\n -  Generated new security certificates in: \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/certificates\n\n- - - INSTALLATION SUCCESSFUL - - -\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Same procedure here: Create and start the service:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [1,2,3,5]; title: ; notranslate\" title=\"\">\npostgres@sles15-dbvisit-mgmt:\/tmp&gt; sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvcontrol service install --user postgres\npostgres@sles15-dbvisit-mgmt:\/tmp&gt; sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvcontrol service start\npostgres@sles15-dbvisit-mgmt:\/tmp&gt; systemctl list-unit-files | grep dbv\ndbvcontrol.service                                                        enabled         disabled\npostgres@sles15-dbvisit-mgmt:\/tmp&gt; systemctl status dbvcontrol.service\n\u25cf dbvcontrol.service - The Dbvisit StandbyMP Control Center provides centralized coordination for Dbvisit StandbyMP Agent operation&gt;\n     Loaded: loaded (\/etc\/systemd\/system\/dbvcontrol.service; enabled; vendor preset: disabled)\n     Active: active (running) since Fri 2023-10-27 15:25:29 CEST; 17s ago\n   Main PID: 3885 (dbvcontrol)\n      Tasks: 11\n     CGroup: \/system.slice\/dbvcontrol.service\n             \u2514\u2500 3885 \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvcontrol service run\nlines 1-7\/7 (END)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s it, the management console should be available over https on port 4433 the third node:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"997\" height=\"623\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_152927.png\" alt=\"\" class=\"wp-image-28959\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_152927.png 997w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_152927-300x187.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_152927-768x480.png 768w\" sizes=\"auto, (max-width: 997px) 100vw, 997px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The default user name and password is admin\/admin and once you logged in you&#8217;ll land on the default screen:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"452\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_153126-1024x452.png\" alt=\"\" class=\"wp-image-28960\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_153126-1024x452.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_153126-300x133.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_153126-768x339.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_153126.png 1410w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Here you can already see, what could be an advantage of using StandbyMP: It gives you one management interface for Oracle, SQL Server and PostgreSQL clusters. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s it for now, in the next post we&#8217;re going to create a new &#8220;PostgreSQL Configuration&#8221;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of our oldest partners, DBVISIT, recently released their product StandbyMP for PostgreSQL. The goal of this product is to provide a graphical user and management interface over a PostgreSQL streaming replication cluster. In this post we&#8217;re going to set this up, and in a follow up post we&#8217;ll see how this product can be&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":[372,2683],"class_list":["post-28934","post","type-post","status-publish","format-standard","category-database","tag-dbvisit","tag-dbvisit-11"],"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 - 1 - Setting it up - 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-1-setting-it-up\/\" \/>\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 - 1 - Setting it up\" \/>\n<meta property=\"og:description\" content=\"One of our oldest partners, DBVISIT, recently released their product StandbyMP for PostgreSQL. The goal of this product is to provide a graphical user and management interface over a PostgreSQL streaming replication cluster. In this post we&#8217;re going to set this up, and in a follow up post we&#8217;ll see how this product can be&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/\" \/>\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-10-27T13:37:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252.png\" \/>\n\t<meta property=\"og:image:width\" content=\"940\" \/>\n\t<meta property=\"og:image:height\" content=\"582\" \/>\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=\"3 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-1-setting-it-up\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"DBVISIT StandbyMP for PostgreSQL &#8211; 1 &#8211; Setting it up\",\"datePublished\":\"2023-10-27T13:37:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/\"},\"wordCount\":410,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Screenshot_20231027_144252.png\",\"keywords\":[\"Dbvisit\",\"Dbvisit 11\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/\",\"name\":\"DBVISIT StandbyMP for PostgreSQL - 1 - Setting it up - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Screenshot_20231027_144252.png\",\"datePublished\":\"2023-10-27T13:37:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Screenshot_20231027_144252.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Screenshot_20231027_144252.png\",\"width\":940,\"height\":582},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-1-setting-it-up\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBVISIT StandbyMP for PostgreSQL &#8211; 1 &#8211; Setting it up\"}]},{\"@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 - 1 - Setting it up - 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-1-setting-it-up\/","og_locale":"en_US","og_type":"article","og_title":"DBVISIT StandbyMP for PostgreSQL - 1 - Setting it up","og_description":"One of our oldest partners, DBVISIT, recently released their product StandbyMP for PostgreSQL. The goal of this product is to provide a graphical user and management interface over a PostgreSQL streaming replication cluster. In this post we&#8217;re going to set this up, and in a follow up post we&#8217;ll see how this product can be&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2023-10-27T13:37:00+00:00","og_image":[{"width":940,"height":582,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252.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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"DBVISIT StandbyMP for PostgreSQL &#8211; 1 &#8211; Setting it up","datePublished":"2023-10-27T13:37:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/"},"wordCount":410,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252.png","keywords":["Dbvisit","Dbvisit 11"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/","url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/","name":"DBVISIT StandbyMP for PostgreSQL - 1 - Setting it up - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252.png","datePublished":"2023-10-27T13:37:00+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252.png","width":940,"height":582},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DBVISIT StandbyMP for PostgreSQL &#8211; 1 &#8211; Setting it up"}]},{"@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\/28934","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=28934"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/28934\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=28934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=28934"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=28934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}