{"id":28965,"date":"2023-10-30T10:38:58","date_gmt":"2023-10-30T09:38:58","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=28965"},"modified":"2023-10-30T10:38:58","modified_gmt":"2023-10-30T09:38:58","slug":"dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/","title":{"rendered":"DBVISIT StandbyMP for PostgreSQL &#8211; 2 &#8211; Creating a PostgreSQL configuration"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In the <a href=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/\" target=\"_blank\" rel=\"noreferrer noopener\">previous post <\/a>we&#8217;ve installed the <a href=\"https:\/\/dbvisit.com\/solutions\/disaster-recovery-for-postgresql\" target=\"_blank\" rel=\"noreferrer noopener\">DBVISIT StandbyMP<\/a> agents on the database nodes, and the management console on third node. In this post we&#8217;re going to create our first PostgreSQL configuration. At the end of this post we should have a primary PostgreSQL instance replicating to a replica, and this configuration is managed by DBVISIT StandbyMP. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is the same overview picture as in the last post and we should end up with something like this:<\/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\">As stated in the <a href=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-1-setting-it-up\/\" target=\"_blank\" rel=\"noreferrer noopener\">previous post<\/a>, a PostgreSQL instance should already be running on one of the database nodes, before a new configuration is created in the management console. Once this is ready, we can start to create the new configuration:<\/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_155203-1024x452.png\" alt=\"\" class=\"wp-image-28966\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155203-1024x452.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155203-300x133.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155203-768x339.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155203.png 1410w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This will bring up a new dialog which presents the hosts we&#8217;ve installed the agents on. In this setup, the PostgreSQL instance is running on the first node, so we&#8217;ll go with that:<\/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_155427-1024x452.png\" alt=\"\" class=\"wp-image-28967\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155427-1024x452.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155427-300x133.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155427-768x339.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155427.png 1410w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The agent already detected the data directory and the port of the running instance, and lists the available databases. Same for the binaries: Select the correct installation from the list and the screen will adapt and display the &#8220;Standby&#8221; section on the right:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"343\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155629-1024x343.png\" alt=\"\" class=\"wp-image-28968\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155629-1024x343.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155629-300x101.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155629-768x258.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155629-1536x515.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_155629.png 1858w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Same procedure: Select the second node and then manually provide the path to the PostgreSQL binaries. As no instance is running on the second node, this is not auto-detected:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"314\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160019-1024x314.png\" alt=\"\" class=\"wp-image-28972\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160019-1024x314.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160019-300x92.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160019-768x235.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160019-1536x470.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160019.png 1858w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Finally give your configuration a name and provide the license key you should have received right after downloading the software:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"412\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160612-1024x412.png\" alt=\"\" class=\"wp-image-28976\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160612-1024x412.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160612-300x121.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160612-768x309.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160612.png 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This created the configuration but did not yet create the replica:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"107\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160815-1024x107.png\" alt=\"\" class=\"wp-image-28978\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160815-1024x107.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160815-300x31.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160815-768x81.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160815-1536x161.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_160815.png 1667w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s create the replica. This will bring up the following screen:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"827\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102106-1024x827.png\" alt=\"\" class=\"wp-image-28990\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102106-1024x827.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102106-300x242.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102106-768x620.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102106.png 1132w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">As we do not have any additional users in the instance and the &#8220;postgres&#8221; user does not have a password, we&#8217;ll just create an additional user we&#8217;ll use for the replication:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\npostgres=# create user replicator with password &#039;replicator&#039; superuser;\nCREATE ROLE\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">As soon as this information is provided the screen comes up with this message:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"333\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102521-1024x333.png\" alt=\"\" class=\"wp-image-28991\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102521-1024x333.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102521-300x98.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102521-768x250.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102521.png 1110w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This means we need to pre-configure the pg_hba.conf (this is after the configuration change and reloading the configuration):<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\npostgres=# select * from pg_hba_file_rules where user_name&#x5B;1] = &#039;replicator&#039;;\n rule_number |           file_name            | line_number | type |   database    |  user_name   |    address     |     netmask     |  auth_method  | options | error \n-------------+--------------------------------+-------------+------+---------------+--------------+----------------+-----------------+---------------+---------+-------\n           7 | \/u02\/pgdata\/16\/PG1\/pg_hba.conf |         127 | host | {replication} | {replicator} | 192.168.122.61 | 255.255.255.255 | scram-sha-256 |         | \n           8 | \/u02\/pgdata\/16\/PG1\/pg_hba.conf |         128 | host | {replication} | {replicator} | 192.168.122.62 | 255.255.255.255 | scram-sha-256 |         | \n(2 rows)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Doing a quick &#8220;Replication Test&#8221; and starting the creation of the replica:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102953-1024x608.png\" alt=\"\" class=\"wp-image-28993\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102953-1024x608.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102953-300x178.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102953-768x456.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_102953.png 1109w\" 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=\"108\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_103053-1024x108.png\" alt=\"\" class=\"wp-image-28994\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_103053-1024x108.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_103053-300x32.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_103053-768x81.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_103053-1536x162.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231030_103053.png 1679w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This looks fine. Checking the primary for the status of the replication and the replication slots confirms, that we have a replica attached:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\npostgres=# \\x\nExpanded display is on.\npostgres=# select * from pg_stat_replication;\n-&#x5B; RECORD 1 ]----+------------------------------\npid              | 1862\nusesysid         | 16388\nusename          | replicator\napplication_name | PG1\nclient_addr      | 192.168.122.62\nclient_hostname  | \nclient_port      | 43946\nbackend_start    | 2023-10-30 10:30:34.49343+01\nbackend_xmin     | \nstate            | streaming\nsent_lsn         | 0\/4000060\nwrite_lsn        | 0\/4000060\nflush_lsn        | 0\/4000060\nreplay_lsn       | 0\/4000060\nwrite_lag        | \nflush_lag        | \nreplay_lag       | \nsync_priority    | 0\nsync_state       | async\nreply_time       | 2023-10-30 10:31:24.515879+01\n\npostgres=# select * from pg_replication_slots ;\n-&#x5B; RECORD 1 ]-------+----------\nslot_name           | dbvisit_1\nplugin              | \nslot_type           | physical\ndatoid              | \ndatabase            | \ntemporary           | f\nactive              | t\nactive_pid          | 1862\nxmin                | 742\ncatalog_xmin        | \nrestart_lsn         | 0\/4000060\nconfirmed_flush_lsn | \nwal_status          | reserved\nsafe_wal_size       | \ntwo_phase           | f\nconflicting         | \n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s it for now, in the next post we&#8217;ll look at how the system behaves for controlled switch- and unplanned failovers.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the previous post we&#8217;ve installed the DBVISIT StandbyMP agents on the database nodes, and the management console on third node. In this post we&#8217;re going to create our first PostgreSQL configuration. At the end of this post we should have a primary PostgreSQL instance replicating to a replica, and this configuration is managed by&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-28965","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 - 2 - Creating a PostgreSQL configuration - 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-2-creating-a-postgresql-configuration\/\" \/>\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 - 2 - Creating a PostgreSQL configuration\" \/>\n<meta property=\"og:description\" content=\"In the previous post we&#8217;ve installed the DBVISIT StandbyMP agents on the database nodes, and the management console on third node. In this post we&#8217;re going to create our first PostgreSQL configuration. At the end of this post we should have a primary PostgreSQL instance replicating to a replica, and this configuration is managed by&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/\" \/>\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-30T09:38:58+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=\"4 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-2-creating-a-postgresql-configuration\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"DBVISIT StandbyMP for PostgreSQL &#8211; 2 &#8211; Creating a PostgreSQL configuration\",\"datePublished\":\"2023-10-30T09:38:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/\"},\"wordCount\":405,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Screenshot_20231027_144252.png\",\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/\",\"name\":\"DBVISIT StandbyMP for PostgreSQL - 2 - Creating a PostgreSQL configuration - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Screenshot_20231027_144252.png\",\"datePublished\":\"2023-10-30T09:38:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\\\/#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-2-creating-a-postgresql-configuration\\\/#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; 2 &#8211; Creating a PostgreSQL configuration\"}]},{\"@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 - 2 - Creating a PostgreSQL configuration - 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-2-creating-a-postgresql-configuration\/","og_locale":"en_US","og_type":"article","og_title":"DBVISIT StandbyMP for PostgreSQL - 2 - Creating a PostgreSQL configuration","og_description":"In the previous post we&#8217;ve installed the DBVISIT StandbyMP agents on the database nodes, and the management console on third node. In this post we&#8217;re going to create our first PostgreSQL configuration. At the end of this post we should have a primary PostgreSQL instance replicating to a replica, and this configuration is managed by&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2023-10-30T09:38:58+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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"DBVISIT StandbyMP for PostgreSQL &#8211; 2 &#8211; Creating a PostgreSQL configuration","datePublished":"2023-10-30T09:38:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/"},"wordCount":405,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252.png","articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/","url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/","name":"DBVISIT StandbyMP for PostgreSQL - 2 - Creating a PostgreSQL configuration - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot_20231027_144252.png","datePublished":"2023-10-30T09:38:58+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standbymp-for-postgresql-2-creating-a-postgresql-configuration\/#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-2-creating-a-postgresql-configuration\/#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; 2 &#8211; Creating a PostgreSQL configuration"}]},{"@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\/28965","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=28965"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/28965\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=28965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=28965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=28965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}