{"id":14555,"date":"2020-08-20T14:36:15","date_gmt":"2020-08-20T12:36:15","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/"},"modified":"2020-08-20T14:36:15","modified_gmt":"2020-08-20T12:36:15","slug":"the-edb-tool-set-integration-into-pem-edb-bart","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/","title":{"rendered":"The EDB tool-set integration into PEM &#8211; EDB BART"},"content":{"rendered":"<p>When it comes to our PostgreSQL customers we basically have two types: There are customers that do not want to have a subscription. For these types of customers we go with plain <a href=\"https:\/\/www.postgresql.org\/\" target=\"_blank\" rel=\"noopener noreferrer\">community PostgreSQL<\/a> and a choice of other open source components for supporting backup and recovery, high availability and monitoring\/alerting. The other type of customer usually already has a subscription for the underlying Linux operating system and wants to have the same supported model for their PostgreSQL deployment. For these types of customers we usually recommend <a href=\"https:\/\/www.enterprisedb.com\" target=\"_blank\" rel=\"noopener noreferrer\">EnterpriseDB<\/a>. One advantage of EnterpriseDB is, that you get all the tools from one vendor and that these tools are integrated into the management solution that you get with an EDB subscription. In this post we&#8217;ll not dig into how these tools need to be setup, but rather have a look at how these tools look like, how they integrate and what you can do with them.<\/p>\n<p><!--more--><\/p>\n<p>When you go with community PostgreSQL and it comes to monitoring, you have plenty of choices. Selecting the right tool for your environment or using an already existing monitoring solution in your company can be a challenging task. When it comes to EnterpriseDB to you get <a href=\"https:\/\/www.enterprisedb.com\/products\/postgresql-enterprise-manager-best-gui-tools-database-management\" target=\"_blank\" rel=\"noopener noreferrer\">PEM (Postgres Enterprise Manager):<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1-1.jpg\" alt=\"\" width=\"1500\" height=\"692\" class=\"aligncenter size-full wp-image-42618\" \/><\/a><\/p>\n<p>This is how the screen looks like when login: You have a general overview over your PEM agents and the PostgreSQL instances which have been added to the PEM directory. This gives you a raw idea on how your PostgreSQL setup is currently operating. If something is shown in the &#8220;Agents Down&#8221;, &#8220;Server Down&#8221; or &#8220;Alerts&#8221; section, you know immediately that you might have an issue. In general PEM works as many other monitoring solutions: You need to deploy the PEM agents on the hosts you want to have monitored (can be a host with or without a PostgreSQL instance) and the agents then report the statistics to the central PEM repository (which is a PostgreSQL instance). On top of that PEM repository database sits the PEM server which is responsible for the browser based graphical user interface.<\/p>\n<p>In the lower area of the home screen you will see the latest alerts (these are the default alerts and thresholds, you will anyway need to adjust that):<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edm-pem-2-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edm-pem-2-1.jpg\" alt=\"\" width=\"1500\" height=\"357\" class=\"aligncenter size-full wp-image-42622\" \/><\/a><\/p>\n<p>Up to now this is nothing special and every serious monitoring solution for PostgreSQL comes with some sort of that information. What makes PEM a great choice is the integration of the other EDB tools. What you can see in the upper left corner of the screen is, that there is an <a href=\"https:\/\/www.enterprisedb.com\/products\/postgresql-database-auto-backup-recovery-restore-script-tools\" target=\"_blank\" rel=\"noopener noreferrer\">EDB BART (Backup and recovery tool)<\/a> server configured into PEM:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-3.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-3.jpg\" alt=\"\" width=\"433\" height=\"224\" class=\"aligncenter size-full wp-image-42626\" \/><\/a><\/p>\n<p>For making that possible a PEM agent needs to be deployed on the BART host as well, even if no PostgreSQL instance is running there. The configuration is quite simple and straight forward:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-5.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-5.jpg\" alt=\"\" width=\"500\" height=\"821\" class=\"aligncenter size-full wp-image-42629\" \/><\/a><\/p>\n<p>Once a database server is configured for BART like this:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-6.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-6.jpg\" alt=\"\" width=\"1500\" height=\"839\" class=\"aligncenter size-full wp-image-42631\" \/><\/a><\/p>\n<p>&#8230; and the configuration is validated:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-7.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-7.jpg\" alt=\"\" width=\"1500\" height=\"842\" class=\"aligncenter size-full wp-image-42632\" \/><\/a><\/p>\n<p>&#8230; there is a full integration of EDB BART into EDB PEM. From now on full and incremental backups can be performed ad-hoc from the PEM console:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-8.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-8.jpg\" alt=\"\" width=\"1025\" height=\"613\" class=\"aligncenter size-full wp-image-42633\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-9.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-9.jpg\" alt=\"\" width=\"1063\" height=\"800\" class=\"aligncenter size-full wp-image-42635\" \/><\/a><\/p>\n<p>That kicks off a full backup which will be stored on the BART server. But even for looking at the existing backups you do not need to logon to the BART server anymore. PEM allows you to view that  directly in the console:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-10.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-10.jpg\" alt=\"\" width=\"1500\" height=\"550\" class=\"aligncenter size-full wp-image-42636\" \/><\/a><\/p>\n<p>Restoring backups to the same or to another server works from the console as well (as long as the PEM Agent and the EDB BART are installed on that server and password-less ssh connectivity is configured):<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-12.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-12.jpg\" alt=\"\" width=\"1482\" height=\"840\" class=\"aligncenter size-full wp-image-42639\" \/><\/a><\/p>\n<p>That&#8217;s it for the ad-hoc backups. Scheduling backups from PEM is the next great feature. Without PEM you usually do that via cron and need a script that sends notifications if the backup fails for whatever reason. With PEM you can just do it over the console:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-13.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-13.jpg\" alt=\"\" width=\"1060\" height=\"601\" class=\"aligncenter size-full wp-image-42641\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-14.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-14.jpg\" alt=\"\" width=\"1500\" height=\"245\" class=\"aligncenter size-full wp-image-42642\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-15.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-15.jpg\" alt=\"\" width=\"1500\" height=\"728\" class=\"aligncenter size-full wp-image-42643\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-16-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-16-1.jpg\" alt=\"\" width=\"1500\" height=\"371\" class=\"aligncenter size-full wp-image-42645\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-17.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-17.jpg\" alt=\"\" width=\"1500\" height=\"636\" class=\"aligncenter size-full wp-image-42646\" \/><\/a><\/p>\n<p>Once time is right, the backup will be executed:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-22-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-22-1.jpg\" alt=\"\" width=\"1200\" height=\"236\" class=\"aligncenter size-full wp-image-42653\" \/><\/a><\/p>\n<p>From now on backups are scheduled and we do not need to worry about scheduling the backups with our own scripts. What you definitely should do in addition, is to setup an &#8220;Email Group&#8221; for notifications:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-18.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-18.jpg\" alt=\"\" width=\"1093\" height=\"513\" class=\"aligncenter size-full wp-image-42648\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edm-pem-19.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edm-pem-19.jpg\" alt=\"\" width=\"1500\" height=\"404\" class=\"aligncenter size-full wp-image-42649\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-20.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-20.jpg\" alt=\"\" width=\"1500\" height=\"307\" class=\"aligncenter size-full wp-image-42650\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-21.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-21.jpg\" alt=\"\" width=\"1500\" height=\"850\" class=\"aligncenter size-full wp-image-42651\" \/><\/a><\/p>\n<p>As soon as the &#8220;Email Group&#8221; is there, you have that you can reference that group in the notifications section of the scheduled backups:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-23.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-23.jpg\" alt=\"\" width=\"1500\" height=\"527\" class=\"aligncenter size-full wp-image-42655\" \/><\/a><\/p>\n<p>Conclusion: I must say that PEM improved quite well over the last years. It still takes some time until you get used to the interface and you know where to find the stuff you are looking for. Once you know the integration of BART works really well and I am sure a lot of people will appreciate that. Having a central place where you can manage your PostgreSQL backups in a graphical way really adds value for people not so deeply into PostgreSQL. And even for people that work with PostgreSQL every day a single entry point can quite save some time if you need to get an overview quickly.<\/p>\n<p>In the next post we&#8217;ll look at the integration of EDB EFM (Failover Manager) into PEM.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When it comes to our PostgreSQL customers we basically have two types: There are customers that do not want to have a subscription. For these types of customers we go with plain community PostgreSQL and a choice of other open source components for supporting backup and recovery, high availability and monitoring\/alerting. The other type of [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":14577,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[1003,1004,1311,1117,77],"type_dbi":[],"class_list":["post-14555","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-bart","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 - EDB BART - 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-bart\/\" \/>\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 - EDB BART\" \/>\n<meta property=\"og:description\" content=\"When it comes to our PostgreSQL customers we basically have two types: There are customers that do not want to have a subscription. For these types of customers we go with plain community PostgreSQL and a choice of other open source components for supporting backup and recovery, high availability and monitoring\/alerting. The other type of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-20T12:36:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"886\" \/>\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=\"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\/the-edb-tool-set-integration-into-pem-edb-bart\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"The EDB tool-set integration into PEM &#8211; EDB BART\",\"datePublished\":\"2020-08-20T12:36:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/\"},\"wordCount\":840,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1.png\",\"keywords\":[\"Bart\",\"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-bart\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/\",\"name\":\"The EDB tool-set integration into PEM - EDB BART - 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-bart\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1.png\",\"datePublished\":\"2020-08-20T12:36:15+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-bart\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1.png\",\"width\":1920,\"height\":886},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/#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 &#8211; EDB BART\"}]},{\"@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 - EDB BART - 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-bart\/","og_locale":"en_US","og_type":"article","og_title":"The EDB tool-set integration into PEM - EDB BART","og_description":"When it comes to our PostgreSQL customers we basically have two types: There are customers that do not want to have a subscription. For these types of customers we go with plain community PostgreSQL and a choice of other open source components for supporting backup and recovery, high availability and monitoring\/alerting. The other type of [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/","og_site_name":"dbi Blog","article_published_time":"2020-08-20T12:36:15+00:00","og_image":[{"width":1920,"height":886,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"The EDB tool-set integration into PEM &#8211; EDB BART","datePublished":"2020-08-20T12:36:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/"},"wordCount":840,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1.png","keywords":["Bart","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-bart\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/","url":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/","name":"The EDB tool-set integration into PEM - EDB BART - 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-bart\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1.png","datePublished":"2020-08-20T12:36:15+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-bart\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb-pem-1.png","width":1920,"height":886},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/the-edb-tool-set-integration-into-pem-edb-bart\/#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 &#8211; EDB BART"}]},{"@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\/14555","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=14555"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14555\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14577"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14555"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}