{"id":14710,"date":"2020-11-01T09:09:35","date_gmt":"2020-11-01T08:09:35","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/"},"modified":"2020-11-01T09:09:35","modified_gmt":"2020-11-01T08:09:35","slug":"what-is-edb","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/","title":{"rendered":"What is EDB?"},"content":{"rendered":"<p>Last few days I played around with EDB tools. In this Blog I will introduce you to EDB.<\/p>\n<h2>What is EDB?<\/h2>\n<p>PostgreSQL is Open Source and has no owner. The owner of PostgreSQL is the community itself. That means, if you have any problems with your PostgreSQL which you cannot solve, you have tree options:<\/p>\n<ul>\n<li>Search the problem on Search Engines<\/li>\n<li>Ask the community<\/li>\n<li>Hire PostgreSQL Consultant<\/li>\n<\/ul>\n<p>On the PostgreSQL license we can read following:<\/p>\n<blockquote><p>Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.<\/p><\/blockquote>\n<p>The license could be found here: <a href=\"https:\/\/www.postgresql.org\/about\/licence\/\">https:\/\/www.postgresql.org\/about\/licence\/<\/a><\/p>\n<p>So that means you can copy the source code, add your own features and sell it. This is what EDB does. Enterprise DB extends the functionality of PostgreSQL. For example:<\/p>\n<ul>\n<li>Increases the security for example Password Management Policy and SQL injection protection<\/li>\n<li>More auditing<\/li>\n<li>Database Migration<\/li>\n<li>Ready to use Enterprise tools such as for Backup and High availability<\/li>\n<\/ul>\n<p>As the EDB is not free, they also offer support for their own Product. It\u2019s like CentOS and RedHat. Companies which are ready to pay for RedHat, they also want support for their Database.<\/p>\n<h2>Let\u2019s look two tools how they can help us<\/h2>\n<p><strong>EDB Backup and Recovery Tool (BART):<\/strong><\/p>\n<ul>\n<li>Manage multiple local or remote hosts for Backups<\/li>\n<li>Block-level incremental or Full Backups<\/li>\n<li>Global policies for Backup rotation<\/li>\n<li>Admin Panel with GUI<\/li>\n<li>And a lot of other features<\/li>\n<\/ul>\n<p><strong>Postgres Failover Manager<\/strong><\/p>\n<ul>\n<li>Automatically switch traffic to a standby database<\/li>\n<li>Monitor the system healthy<\/li>\n<li>Reconfigures load balancer on failover<\/li>\n<li>It needs a Load Balancer!<\/li>\n<li>And a lot of other features<\/li>\n<\/ul>\n<p>There are also few Open Source Projects from EDB:<\/p>\n<ul>\n<li><strong>Pgpool-II<\/strong>\n<ul>\n<li>Load balancer between applications and PostgreSQL database<\/li>\n<li>High availability<\/li>\n<\/ul>\n<\/li>\n<li><strong>Foreign Data Wrappers<\/strong>\n<ul>\n<li>Extends the default Foreign Data Wrapper<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>To get access to EDB repository you need create an EDB account. You will have 60 days unlimited access to this repository. After that you need a subscription. <a href=\"https:\/\/www.enterprisedb.com\/user\/register?destination=\/repository-access-request%3Fdestination%3Dnode\/1255704%26resource%3D1255704%26ma_formid%3D2098\" target=\"_blank\" rel=\"noopener noreferrer\">Link to create EDB account<\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-43296\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial2.png\" alt=\"\" width=\"300\" height=\"204\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-43297\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial3.png\" alt=\"\" width=\"300\" height=\"156\" \/><\/a><\/p>\n<p>After you created EDB account and verified your E-Mail, you will have access to the EDB repositories. It&#8217;s very simple. You choose left site which tools you want to install and on the right side you see How to tutorial.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-43299\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial4.png\" alt=\"\" width=\"300\" height=\"120\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Conclusion<\/strong>: If you need Enterprise Database solutions and you need 24\/7 support, you might be look at EDB solutions. But if you need only High Availability or Backups tools there are also awesome Open Source projects for example &#8220;Patroni&#8221; for High Availability developed by Zalando. The tool &#8220;pgbackrest&#8221; is very simple to use to create PostgreSQL Backups, Mouhamadou has a greate <a href=\"https:\/\/www.dbi-services.com\/blog\/backup-and-restore-postgresql-with-pgbackrest-i\/\" target=\"_blank\" rel=\"noopener noreferrer\">Blog about pgbackrest<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last few days I played around with EDB tools. In this Blog I will introduce you to EDB. What is EDB? PostgreSQL is Open Source and has no owner. The owner of PostgreSQL is the community itself. That means, if you have any problems with your PostgreSQL which you cannot solve, you have tree options: [&hellip;]<\/p>\n","protected":false},"author":28,"featured_media":14714,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-14710","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring"],"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>What is EDB? - 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\/what-is-edb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is EDB?\" \/>\n<meta property=\"og:description\" content=\"Last few days I played around with EDB tools. In this Blog I will introduce you to EDB. What is EDB? PostgreSQL is Open Source and has no owner. The owner of PostgreSQL is the community itself. That means, if you have any problems with your PostgreSQL which you cannot solve, you have tree options: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-01T08:09:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1121\" \/>\n\t<meta property=\"og:image:height\" content=\"645\" \/>\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: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\/what-is-edb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\"},\"headline\":\"What is EDB?\",\"datePublished\":\"2020-11-01T08:09:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/\"},\"wordCount\":466,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial1.png\",\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/\",\"name\":\"What is EDB? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial1.png\",\"datePublished\":\"2020-11-01T08:09:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial1.png\",\"width\":1121,\"height\":645},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is EDB?\"}]},{\"@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\/59554f0d99383431eb6ed427e338952b\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"caption\":\"Open source Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What is EDB? - 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\/what-is-edb\/","og_locale":"en_US","og_type":"article","og_title":"What is EDB?","og_description":"Last few days I played around with EDB tools. In this Blog I will introduce you to EDB. What is EDB? PostgreSQL is Open Source and has no owner. The owner of PostgreSQL is the community itself. That means, if you have any problems with your PostgreSQL which you cannot solve, you have tree options: [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/","og_site_name":"dbi Blog","article_published_time":"2020-11-01T08:09:35+00:00","og_image":[{"width":1121,"height":645,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial1.png","type":"image\/png"}],"author":"Open source Team","twitter_card":"summary_large_image","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\/what-is-edb\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"headline":"What is EDB?","datePublished":"2020-11-01T08:09:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/"},"wordCount":466,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial1.png","articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/","url":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/","name":"What is EDB? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial1.png","datePublished":"2020-11-01T08:09:35+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/what-is-edb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/EDB-tutorial1.png","width":1121,"height":645},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/what-is-edb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What is EDB?"}]},{"@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\/59554f0d99383431eb6ed427e338952b","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","caption":"Open source Team"},"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\/14710","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=14710"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14710\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14714"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14710"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}