{"id":7083,"date":"2016-02-09T19:19:56","date_gmt":"2016-02-09T18:19:56","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/"},"modified":"2016-02-09T19:19:56","modified_gmt":"2016-02-09T18:19:56","slug":"the-dbi-services-postgresql-reference-architecture-2-the-community-approach","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/","title":{"rendered":"The dbi services PostgreSQL reference architecture (2) &#8211; The community approach"},"content":{"rendered":"<p>In the <a href=\"http:\/\/dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-1-the-commercial-approach\/\" target=\"_blank\">last post<\/a> I looked at how dbi services designs a PostgreSQL architecture based on the products of <a href=\"http:\/\/www.enterprisedb.com\/\" target=\"_blank\">EnterpriseDB<\/a>. In this post I&#8217;ll look at the same questions but using pure community tools. If you do not need vendor support and do trust the community for providing help and fixes this is another way to go. And usually you can trust the community around PostgreSQL very well. The architecture itself is pretty much the same as in the last post. The tools are different.<\/p>\n<p>As in the last post there is a &#8220;minimal&#8221; configuration:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_minimal.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_minimal.png\" alt=\"pg_ref_community_minimal\" width=\"1024\" height=\"723\" class=\"aligncenter size-full wp-image-6994\" \/><\/a><\/p>\n<p>The picture is almost the same as with the commercial approach. The only little thing that changed is the backup and recovery tool: This time it is <a href=\"www.pgbarman.org\" target=\"_blank\">Barman<\/a> instead of BART. As just one tool changes but not the architecture as a whole the same restrictions apply as with the commercial setup:<\/p>\n<ul>\n<li>The application probably needs to be reconfigured to connect to the standby database in case the master goes down for any reason<\/li>\n<li>There is no integrated monitoring solution which alerts in case of issues. Sure, monitoring can be done by using scripts, <a href=\"https:\/\/bucardo.org\/wiki\/Check_postgres\" target=\"_blank\">check_postgres<\/a> or other tools but it needs extra effort<\/li>\n<\/ul>\n<p>Once there is the need for automated failover in case the primary goes down the next stage adds <a href=\"http:\/\/www.repmgr.org\/\" target=\"_blank\">repmgr<\/a>. But as repmgr (at least as of now) is not working with VIPs we&#8217;ll need to add another tool to the landscape: <a href=\"www.pgpool.net\" target=\"_blank\">pgpool-II<\/a>. Combining both connections can be redirected: Writes will go to the master and reads can go to the standby. In case of a failover pgpool will redirect both, reads and writes, to the surviving node. <\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_extended.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_extended.png\" alt=\"pg_ref_community_extended\" width=\"916\" height=\"724\" class=\"aligncenter size-full wp-image-7002\" \/><\/a><\/p>\n<p>What is missing here, same issue than in the last post, is a monitoring solution over all components. This is where the dbi services <a href=\"https:\/\/www.dbi-services.com\/offering\/products\/database-management-kit\/\" target=\"_blank\">DMK<\/a> comes into the game. DMK brings a set of monitoring scripts and pre-defined thresholds that can be used to monitor all components. <\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_full.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_full.png\" alt=\"pg_ref_community_full\" width=\"976\" height=\"749\" class=\"aligncenter size-full wp-image-7006\" \/><\/a><\/p>\n<p>The integration into monitoring tools such as <a href=\"https:\/\/www.nagios.org\/\" target=\"_blank\">Nagios<\/a>, <a href=\"https:\/\/www.icinga.org\/\" target=\"_blank\">Icinga<\/a>, <a href=\"http:\/\/www.zabbix.com\/\" target=\"_blank\">Zabbix<\/a> and many others is straight forward and easy. Its all based on customizable scripts and free for our customers. What else is missing? To add even more protection, flexibility and load balancing more replicas can be added to the landscape (one more in the picture below):<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_maa.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_maa.png\" alt=\"pg_ref_community_maa\" width=\"1028\" height=\"738\" class=\"aligncenter size-full wp-image-7008\" \/><\/a><\/p>\n<p>Again, this is a simplified overview but it should help in understanding the concepts. Technically the implementation requires a bit more planning and needs a lot of testing especially from the application side (this is true for any HA implementation and not limited to PostgreSQL, of course). But once this up and running you&#8217;ll have a reliable, robust and safe PostgreSQL architecture all based on community products.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the last post I looked at how dbi services designs a PostgreSQL architecture based on the products of EnterpriseDB. In this post I&#8217;ll look at the same questions but using pure community tools. If you do not need vendor support and do trust the community for providing help and fixes this is another way&hellip;&nbsp;<\/p>\n","protected":false},"author":28,"featured_media":7088,"comment_status":"open","ping_status":"open","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":[704,202,84,226],"class_list":["post-7083","post","type-post","status-publish","format-standard","has-post-thumbnail","category-database","tag-architecture","tag-backup","tag-high-availability","tag-recovery"],"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>The dbi services PostgreSQL reference architecture (2) - The community approach - 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\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The dbi services PostgreSQL reference architecture (2) - The community approach\" \/>\n<meta property=\"og:description\" content=\"In the last post I looked at how dbi services designs a PostgreSQL architecture based on the products of EnterpriseDB. In this post I&#8217;ll look at the same questions but using pure community tools. If you do not need vendor support and do trust the community for providing help and fixes this is another way&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/\" \/>\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=\"2016-02-09T18:19:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_minimal-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"723\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"The dbi services PostgreSQL reference architecture (2) &#8211; The community approach\",\"datePublished\":\"2016-02-09T18:19:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/\"},\"wordCount\":459,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/pg_ref_community_minimal-1.png\",\"keywords\":[\"architecture\",\"Backup\",\"High Availability\",\"Recovery\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/\",\"name\":\"The dbi services PostgreSQL reference architecture (2) - The community approach - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/pg_ref_community_minimal-1.png\",\"datePublished\":\"2016-02-09T18:19:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/pg_ref_community_minimal-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/pg_ref_community_minimal-1.png\",\"width\":1024,\"height\":723},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The dbi services PostgreSQL reference architecture (2) &#8211; The community approach\"}]},{\"@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":"The dbi services PostgreSQL reference architecture (2) - The community approach - 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\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/","og_locale":"en_US","og_type":"article","og_title":"The dbi services PostgreSQL reference architecture (2) - The community approach","og_description":"In the last post I looked at how dbi services designs a PostgreSQL architecture based on the products of EnterpriseDB. In this post I&#8217;ll look at the same questions but using pure community tools. If you do not need vendor support and do trust the community for providing help and fixes this is another way&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2016-02-09T18:19:56+00:00","og_image":[{"width":1024,"height":723,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_minimal-1.png","type":"image\/png"}],"author":"Open source Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Open source Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"The dbi services PostgreSQL reference architecture (2) &#8211; The community approach","datePublished":"2016-02-09T18:19:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/"},"wordCount":459,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_minimal-1.png","keywords":["architecture","Backup","High Availability","Recovery"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/","url":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/","name":"The dbi services PostgreSQL reference architecture (2) - The community approach - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_minimal-1.png","datePublished":"2016-02-09T18:19:56+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_minimal-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/pg_ref_community_minimal-1.png","width":1024,"height":723},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The dbi services PostgreSQL reference architecture (2) &#8211; The community approach"}]},{"@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\/7083","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=7083"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7083\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/7088"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}