{"id":14583,"date":"2020-08-21T08:27:59","date_gmt":"2020-08-21T06:27:59","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/"},"modified":"2020-08-21T08:27:59","modified_gmt":"2020-08-21T06:27:59","slug":"the-edb-tool-set-integration-into-pem-edb-efm","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/","title":{"rendered":"The EDB tool-set integration into PEM \u2013 EDB EFM"},"content":{"rendered":"<p>In the <a href=\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/\" target=\"_blank\" rel=\"noopener noreferrer\">last post<\/a> we had a look at how <a href=\"https:\/\/www.enterprisedb.com\/products\/postgresql-database-auto-backup-recovery-restore-script-tools\" target=\"_blank\" rel=\"noopener noreferrer\">EDB BART<\/a> integrates into <a href=\"https:\/\/www.enterprisedb.com\/products\/postgresql-enterprise-manager-best-gui-tools-database-management\" target=\"_blank\" rel=\"noopener noreferrer\">EDB PEM<\/a>, so backups and restores can be managed centrally from the PEM console. Another tool that comes with an EDB subscription is <a href=\"https:\/\/www.enterprisedb.com\/products\/postgresql-automatic-failover-manager-cluster-high-availability\" target=\"_blank\" rel=\"noopener noreferrer\">EDB EFM (EDB Failover Manager)<\/a>. We again will not cover how that tool works or how you need to set it up, but rather focus on how EFM integrates into PEM. What I expect from the integration of EFM into PEM is the following:<\/p>\n<ul>\n<li>On overview of the cluster status, it&#8217;s members and roles<\/li>\n<li>Initiating a controlled switchover<\/li>\n<li>Integrated health-checks and notifications<\/li>\n<\/ul>\n<p>So, let&#8217;s see what PEM brings on top of the command line when it comes to EFM.<\/p>\n<p><!--more--><\/p>\n<p>As said above we&#8217;ll not look at how EFM needs to be configured, this is already done here and the current status of the fail-over cluster is this:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n[root@edb-as12-1 efm-3.10]$ \/usr\/edb\/efm-3.10\/bin\/efm cluster-status efm\nCluster Status: efm\n\n        Agent Type  Address              Agent  DB       VIP\n        -----------------------------------------------------------------------\n        Standby     10.0.1.114           UP     UP       10.0.1.233\n        Witness     10.0.1.197           UP     N\/A      10.0.1.233\n        Master      10.0.1.82            UP     UP       10.0.1.233*\n\nAllowed node host list:\n        10.0.1.197 edb-bart edb-as12-1 edb-as12-2\n\nMembership coordinator: 10.0.1.197\n\nStandby priority host list:\n        10.0.1.114\n\nPromote Status:\n\n        DB Type     Address              WAL Received LSN   WAL Replayed LSN   Info\n        ---------------------------------------------------------------------------\n        Master      10.0.1.82                               0\/29000060         \n        Standby     10.0.1.114           0\/29000060         0\/29000060         \n\n        Standby database(s) in sync with master. It is safe to promote.\n<\/pre>\n<p>There is one primary database and one replica which is open for read only connections. In addition there is a witness EFM agent running on the BART host (this is the same host we used in the last post for storing the backups). The witness node is required if you want to have automatic fail-over as you need at least three agents to build the quorum. In addition EFM is configured to bring up a virtual IP address so the applications have a single point to connect to.<\/p>\n<p>PEM comes with a dashboard for streaming replication so that should show us the current status of our fail-over cluster:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg\" alt=\"\" width=\"1034\" height=\"709\" class=\"aligncenter size-full wp-image-42666\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-2.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-2.jpg\" alt=\"\" width=\"1456\" height=\"595\" class=\"aligncenter size-full wp-image-42667\" \/><\/a><\/p>\n<p>Not much we can see here. By default PEM does not know anything about EFM even if it is already configured and running (this might be something that can be improved in future versions of PEM. I do not see a reason why the PEM agent should not be able to auto-discover a configured EFM cluster). To make PEM aware of the EFM configuration we need to provide some basic information in the &#8220;Properties&#8221; dialog of each instance in the cluster (servers need to be disconnected for being able to adjust the properties):<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-3.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-3.jpg\" alt=\"\" width=\"1160\" height=\"703\" class=\"aligncenter size-full wp-image-42668\" \/><\/a><\/p>\n<p>Once we have the EFM details configured for each database server, the streaming replication dashboard will display the details of the EFM cluster:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-4.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-4.jpg\" alt=\"\" width=\"1500\" height=\"530\" class=\"aligncenter size-full wp-image-42670\" \/><\/a><\/p>\n<p>What you can see here is basically the same information you would see on the command line when you ask for the cluster status. What&#8217;s a bit strange is the mix of IP addresses and host names, but maybe that&#8217;s just cosmetic. What&#8217;s also strange is, that the &#8220;Status information&#8221; and &#8220;Xlog Information&#8221; columns are empty but they will only be populated if there is an error, if all is fine they are empty. The same is true for &#8220;Cluster status message&#8221;: It will only contain some information if something is not fine.<\/p>\n<p>What I would like to see on this screen in addition:<\/p>\n<ul>\n<li>The content of the efm.properties for each node<\/li>\n<li>A message indicating if it is currently safe to promote a replica (as you can see that in the command line output)<\/li>\n<li>The possibility to initiate a controlled switch-over<\/li>\n<li>Lag information in a time unit<\/a>\n<\/ul>\n<p>According to the <a href=\"https:\/\/www.enterprisedb.com\/edb-docs\/d\/edb-postgres-enterprise-manager\/user-guides\/enterprise-features-guide\/7.15\/monitoring_failover_manager.html\" target=\"_blank\" rel=\"noopener noreferrer\">documentation<\/a> there should be the possibility to initiate a fail-over from the management menu, but this option does not exist (or I am not able to find it):<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-5.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-5.jpg\" alt=\"\" width=\"948\" height=\"628\" class=\"aligncenter size-full wp-image-42673\" \/><\/a><\/p>\n<p>From an alerting perspective there are no predefined alerts for EFM:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-6.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-6.jpg\" alt=\"\" width=\"1500\" height=\"798\" class=\"aligncenter size-full wp-image-42675\" \/><\/a><\/p>\n<p>If you want to have that you need to create your own alerts and probes.<\/p>\n<p>Conclusion: The integration of EFM into PEM is not as far as it is for the BART integration. You get basic statistics once you configured the EFM settings but not more. Would be great if the points raised in this blog post would be integrated in a future release.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the last post we had a look at how EDB BART integrates into EDB PEM, so backups and restores can be managed centrally from the PEM console. Another tool that comes with an EDB subscription is EDB EFM (EDB Failover Manager). We again will not cover how that tool works or how you need [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":14584,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[1004,1311,1117,77],"type_dbi":[],"class_list":["post-14583","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-edb","tag-efm","tag-pem","tag-postgresql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>The EDB tool-set integration into PEM \u2013 EDB EFM - 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-edb-tool-set-integration-into-pem-edb-efm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The EDB tool-set integration into PEM \u2013 EDB EFM\" \/>\n<meta property=\"og:description\" content=\"In the last post we had a look at how EDB BART integrates into EDB PEM, so backups and restores can be managed centrally from the PEM console. Another tool that comes with an EDB subscription is EDB EFM (EDB Failover Manager). We again will not cover how that tool works or how you need [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-21T06:27:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1034\" \/>\n\t<meta property=\"og:image:height\" content=\"709\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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\/the-edb-tool-set-integration-into-pem-edb-efm\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"The EDB tool-set integration into PEM \u2013 EDB EFM\",\"datePublished\":\"2020-08-21T06:27:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/\"},\"wordCount\":636,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg\",\"keywords\":[\"edb\",\"efm\",\"PEM\",\"PostgreSQL\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/\",\"name\":\"The EDB tool-set integration into PEM \u2013 EDB EFM - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg\",\"datePublished\":\"2020-08-21T06:27:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg\",\"width\":1034,\"height\":709},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The EDB tool-set integration into PEM \u2013 EDB EFM\"}]},{\"@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 EDB tool-set integration into PEM \u2013 EDB EFM - 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-edb-tool-set-integration-into-pem-edb-efm\/","og_locale":"en_US","og_type":"article","og_title":"The EDB tool-set integration into PEM \u2013 EDB EFM","og_description":"In the last post we had a look at how EDB BART integrates into EDB PEM, so backups and restores can be managed centrally from the PEM console. Another tool that comes with an EDB subscription is EDB EFM (EDB Failover Manager). We again will not cover how that tool works or how you need [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/","og_site_name":"dbi Blog","article_published_time":"2020-08-21T06:27:59+00:00","og_image":[{"width":1034,"height":709,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg","type":"image\/jpeg"}],"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\/the-edb-tool-set-integration-into-pem-edb-efm\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"The EDB tool-set integration into PEM \u2013 EDB EFM","datePublished":"2020-08-21T06:27:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/"},"wordCount":636,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg","keywords":["edb","efm","PEM","PostgreSQL"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/","url":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/","name":"The EDB tool-set integration into PEM \u2013 EDB EFM - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg","datePublished":"2020-08-21T06:27:59+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-efm-1.jpg","width":1034,"height":709},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-efm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The EDB tool-set integration into PEM \u2013 EDB EFM"}]},{"@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\/14583","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=14583"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14583\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14584"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14583"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}