{"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\/sites\/2\/2022\/04\/pg_ref_community_minimal.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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\/sites\/2\/2022\/04\/pg_ref_community_extended.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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\/sites\/2\/2022\/04\/pg_ref_community_full.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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\/sites\/2\/2022\/04\/pg_ref_community_maa.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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;]<\/p>\n","protected":false},"author":29,"featured_media":7088,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[704,202,84,77,226],"type_dbi":[],"class_list":["post-7083","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-architecture","tag-backup","tag-high-availability","tag-postgresql","tag-recovery"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>The dbi services PostgreSQL reference architecture (2) - The community approach - 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\/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;]\" \/>\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 Blog\" \/>\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\/sites\/2\/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=\"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=\"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\":\"Daniel Westermann\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"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,\"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\\\/sites\\\/2\\\/2022\\\/04\\\/pg_ref_community_minimal-1.png\",\"keywords\":[\"architecture\",\"Backup\",\"High availability\",\"PostgreSQL\",\"Recovery\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"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 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\\\/sites\\\/2\\\/2022\\\/04\\\/pg_ref_community_minimal-1.png\",\"datePublished\":\"2016-02-09T18:19:56+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"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\\\/sites\\\/2\\\/2022\\\/04\\\/pg_ref_community_minimal-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/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\":\"Accueil\",\"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 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 &amp;\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":"The dbi services PostgreSQL reference architecture (2) - The community approach - 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\/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;]","og_url":"https:\/\/www.dbi-services.com\/blog\/the-dbi-services-postgresql-reference-architecture-2-the-community-approach\/","og_site_name":"dbi Blog","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\/sites\/2\/2022\/04\/pg_ref_community_minimal-1.png","type":"image\/png"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","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":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"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,"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\/sites\/2\/2022\/04\/pg_ref_community_minimal-1.png","keywords":["architecture","Backup","High availability","PostgreSQL","Recovery"],"articleSection":["Database Administration &amp; Monitoring"],"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 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\/sites\/2\/2022\/04\/pg_ref_community_minimal-1.png","datePublished":"2016-02-09T18:19:56+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"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\/sites\/2\/2022\/04\/pg_ref_community_minimal-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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":"Accueil","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 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 &amp;\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\/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\/29"}],"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"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}