{"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:43:11","modified_gmt":"2023-10-27T13:43:11","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 – 1 – Setting it up"},"content":{"rendered":"\n

One of our oldest partners, DBVISIT<\/a>, recently released their product 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’re going to set this up, and in a follow up post we’ll see how this product can be used to easily switchover to a replica and recover from failures.<\/p>\n\n\n\n

We’ll be using three SLES 15<\/a> nodes for this setup (system requirements here<\/a>), and this is how it is going to look like:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

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

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

Taking the picture from above, a PostgreSQL instance is already running on the left database node:<\/p>\n\n\n

\npostgres@sles15-dbvisit-db1:\/home\/postgres\/ [PG1] psql -c "select version()";\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
The next step is to install the agent on both the database nodes (software can be downloaded from here<\/a>).<\/p>\n\n\n\n
We’re going to install the product into a dedicated directory:<\/p>\n\n\n
\npostgres@sles15-dbvisit-db1:\/home\/postgres\/ [PG1] mkdir \/u01\/app\/postgres\/product\/dbvisit\n<\/pre><\/div>\n\n\n
As it is not recommended to run the installer from the target directory we’ll start from \/tmp:<\/p>\n\n\n
\npostgres@sles15-dbvisit-db1:\/home\/postgres\/ [PG1] cd \/tmp\/\n15:03:55 postgres@sles15-dbvisit-db1:\/tmp\/ [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\/ [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\/ [PG1] tar axf standby-v11.5.0.tar.gz \n15:04:36 postgres@sles15-dbvisit-db1:\/tmp\/ [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
This gives us two installers, one for the agent and another one for the console. As we’re on a database node we start with the agent installer. We’ll just run it and follow the instructions:<\/p>\n\n\n
\npostgres@sles15-dbvisit-db1:\/tmp\/ [PG1] .\/install-agent-v11.5.0\n+----------------------------------------------------------------------+\n|          ____  _                  _ _           __  __ ____          |\n|         \/ ___|| |_ __ _ _ __   __| | |__  _   _|  \\\/  |  _ \\         |\n|         \\___ \\| __\/ _' | '_ \\ \/ _' | '_ \\| | | | |\\\/| | |_) |        |\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 '\/u01\/app\/postgres\/product\/dbvisit'...\nWriting Agent configuration file '\/u01\/app\/postgres\/product\/dbvisit\/standbymp\/conf\/dbvagentmanager.ini'...\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 "root" 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
Finally register the service and start it up, as described in the output of the installer:<\/p>\n\n\n
\npostgres@sles15-dbvisit-db1:\/tmp\/ [PG1] sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvagentmanager service install --user postgres\n15:15:45 postgres@sles15-dbvisit-db1:\/tmp\/ [PG1] sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvagentmanager service start\npostgres@sles15-dbvisit-db1:\/tmp\/ [PG1] systemctl list-unit-files | grep dbv\ndbvagentmanager.service                                                   enabled         disabled\npostgres@sles15-dbvisit-db1:\/tmp\/ [PG1] systemctl status dbvagentmanager.service\n\u25cf dbvagentmanager.service - The Dbvisit StandbyMP Agent provides connectivity to databases on this computer. This Agent is used & ma>\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
Once it is up and running repeat all the steps on the remaining database node.<\/p>\n\n\n\n
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
\npostgres@sles15-dbvisit-mgmt:\/tmp> .\/install-control-v11.5.0 \n+----------------------------------------------------------------------+\n|          ____  _                  _ _           __  __ ____          |\n|         \/ ___|| |_ __ _ _ __   __| | |__  _   _|  \\\/  |  _ \\         |\n|         \\___ \\| __\/ _' | '_ \\ \/ _' | '_ \\| | | | |\\\/| | |_) |        |\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 '\/u01\/app\/postgres\/product\/dbvisit'...\nWriting Control Center configuration file '\/u01\/app\/postgres\/product\/dbvisit\/standbymp\/conf\/dbvcontrol.ini'...\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 "root" 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
Same procedure here: Create and start the service:<\/p>\n\n\n
\npostgres@sles15-dbvisit-mgmt:\/tmp> sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvcontrol service install --user postgres\npostgres@sles15-dbvisit-mgmt:\/tmp> sudo \/u01\/app\/postgres\/product\/dbvisit\/standbymp\/bin\/dbvcontrol service start\npostgres@sles15-dbvisit-mgmt:\/tmp> systemctl list-unit-files | grep dbv\ndbvcontrol.service                                                        enabled         disabled\npostgres@sles15-dbvisit-mgmt:\/tmp> systemctl status dbvcontrol.service\n\u25cf dbvcontrol.service - The Dbvisit StandbyMP Control Center provides centralized coordination for Dbvisit StandbyMP Agent operation>\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
That’s it, the management console should be available over https on port 4433 the third node:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The default user name and password is admin\/admin and once you logged in you’ll land on the default screen:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
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
That’s it for now, in the next post we’re going to create a new “PostgreSQL Configuration”.<\/p>\n","protected":false},"excerpt":{"rendered":"
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’re going to set this up, and in a follow up post we’ll see how this product can be […]<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198],"tags":[372,2683,77,2922],"type_dbi":[2749],"class_list":["post-28934","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","tag-dbvisit","tag-dbvisit-11","tag-postgresql","tag-standbymp","type-postgresql"],"acf":[],"yoast_head":"\nDBVISIT StandbyMP for PostgreSQL - 1 - Setting it up - dbi 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’re going to set this up, and in a follow up post we’ll see how this product can be […]\" \/>\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 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-27T13:37:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-27T13:43:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/10\/Screenshot_20231027_144252.png\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\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\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"DBVISIT StandbyMP for PostgreSQL – 1 – Setting it up\",\"datePublished\":\"2023-10-27T13:37:00+00:00\",\"dateModified\":\"2023-10-27T13:43:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/\"},\"wordCount\":410,\"commentCount\":0,\"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\/sites\/2\/2023\/10\/Screenshot_20231027_144252.png\",\"keywords\":[\"dbvisit\",\"Dbvisit 11\",\"PostgreSQL\",\"StandbyMP\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\"],\"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 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\/sites\/2\/2023\/10\/Screenshot_20231027_144252.png\",\"datePublished\":\"2023-10-27T13:37:00+00:00\",\"dateModified\":\"2023-10-27T13:43:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"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\/sites\/2\/2023\/10\/Screenshot_20231027_144252.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBVISIT StandbyMP for PostgreSQL – 1 – Setting it up\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"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\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"DBVISIT StandbyMP for PostgreSQL - 1 - Setting it up - dbi 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’re going to set this up, and in a follow up post we’ll see how this product can be […]","og_url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/","og_site_name":"dbi Blog","article_published_time":"2023-10-27T13:37:00+00:00","article_modified_time":"2023-10-27T13:43:11+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/10\/Screenshot_20231027_144252.png","type":"","width":"","height":""}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","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":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"DBVISIT StandbyMP for PostgreSQL – 1 – Setting it up","datePublished":"2023-10-27T13:37:00+00:00","dateModified":"2023-10-27T13:43:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/"},"wordCount":410,"commentCount":0,"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\/sites\/2\/2023\/10\/Screenshot_20231027_144252.png","keywords":["dbvisit","Dbvisit 11","PostgreSQL","StandbyMP"],"articleSection":["Database Administration & Monitoring","Database management"],"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 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\/sites\/2\/2023\/10\/Screenshot_20231027_144252.png","datePublished":"2023-10-27T13:37:00+00:00","dateModified":"2023-10-27T13:43:11+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"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\/sites\/2\/2023\/10\/Screenshot_20231027_144252.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DBVISIT StandbyMP for PostgreSQL – 1 – Setting it up"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","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":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_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\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=28934"}],"version-history":[{"count":15,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/28934\/revisions"}],"predecessor-version":[{"id":28962,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/28934\/revisions\/28962"}],"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"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=28934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}