{"id":10249,"date":"2017-06-15T15:14:52","date_gmt":"2017-06-15T13:14:52","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/"},"modified":"2017-06-15T15:14:52","modified_gmt":"2017-06-15T13:14:52","slug":"a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/","title":{"rendered":"A first look at EDB Postgres Enterprise Manager 7 beta &#8211; Connecting a PostgreSQL instance"},"content":{"rendered":"<p>In the <a href=\"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta\/\" target=\"_blank\">last post<\/a> we did a click\/click\/click setup of the PEM server. What we want to do now is to attach a PostgreSQL instance to the PEM server for being able to monitor and administer it. For that we need to install the PEM agent on a host where we have a PostgreSQL instance running (192.168.22.249 in my case, which runs PostgreSQL 10 Beta1). Lets go &#8230;<\/p>\n<p><!--more--><\/p>\n<p>As usual, when you want to have the systemd services generated automatically you should run the installation as root:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[root@pemclient postgres]# ls\npem_agent-7.0.0-beta1-1-linux-x64.run\n[root@pemclient postgres]# chmod +x pem_agent-7.0.0-beta1-1-linux-x64.run \n[root@pemclient postgres]# .\/pem_agent-7.0.0-beta1-1-linux-x64.run \n<\/pre>\n<p>The installation itself is not a big deal, just follow the screens:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent1.png\" alt=\"pem_agent1\" width=\"556\" height=\"425\" class=\"aligncenter size-full wp-image-17174\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent2.png\" alt=\"pem_agent2\" width=\"555\" height=\"430\" class=\"aligncenter size-full wp-image-17175\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent3.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent3.png\" alt=\"pem_agent3\" width=\"558\" height=\"420\" class=\"aligncenter size-full wp-image-17176\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent4.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent4.png\" alt=\"pem_agent4\" width=\"548\" height=\"427\" class=\"aligncenter size-full wp-image-17177\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent5.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent5.png\" alt=\"pem_agent5\" width=\"548\" height=\"423\" class=\"aligncenter size-full wp-image-17178\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent6.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent6.png\" alt=\"pem_agent6\" width=\"555\" height=\"428\" class=\"aligncenter size-full wp-image-17179\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent7.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent7.png\" alt=\"pem_agent7\" width=\"557\" height=\"433\" class=\"aligncenter size-full wp-image-17180\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent8.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent8.png\" alt=\"pem_agent8\" width=\"551\" height=\"425\" class=\"aligncenter size-full wp-image-17181\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent9.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent9.png\" alt=\"pem_agent9\" width=\"554\" height=\"429\" class=\"aligncenter size-full wp-image-17182\" \/><\/a><\/p>\n<p>Once done we have a new systemd service:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[root@pemclient postgres]# systemctl list-unit-files | grep pem\npemagent.service                              enabled \n<\/pre>\n<p>&#8230; and the processes that make up the PEM agent:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[root@pemclient postgres]# ps -ef | grep pem\nroot      3454     1  0 16:40 ?        00:00:00 \/u01\/app\/postgres\/product\/pem7\/agent\/agent\/bin\/pemagent -c \/u01\/app\/postgres\/product\/pem7\/agent\/agent\/etc\/agent.cfg\nroot      3455  3454  0 16:40 ?        00:00:00 \/u01\/app\/postgres\/product\/pem7\/agent\/agent\/bin\/pemworker -c \/u01\/app\/postgres\/product\/pem7\/agent\/agent\/etc\/agent.cfg --pid 3454\nroot      3515  2741  0 16:43 pts\/0    00:00:00 grep --color=auto pem\n<\/pre>\n<p>Heading back to the PEM web interface the new agent is visible immediately:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent10.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent10.png\" alt=\"pem_agent10\" width=\"589\" height=\"216\" class=\"aligncenter size-full wp-image-17185\" \/><\/a><\/p>\n<p>So, lets add the instance:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent11.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent11.png\" alt=\"pem_agent11\" width=\"480\" height=\"339\" class=\"aligncenter size-full wp-image-17187\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent12.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent12.png\" alt=\"pem_agent12\" width=\"511\" height=\"548\" class=\"aligncenter size-full wp-image-17189\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent17.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent17.png\" alt=\"pem_agent17\" width=\"504\" height=\"542\" class=\"aligncenter size-full wp-image-17197\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent14.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent14.png\" alt=\"pem_agent14\" width=\"508\" height=\"552\" class=\"aligncenter size-full wp-image-17190\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent15.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent15.png\" alt=\"pem_agent15\" width=\"599\" height=\"317\" class=\"aligncenter size-full wp-image-17191\" \/><\/a><\/p>\n<p>Of course, we need to allow connections to our PostgreSQL instance from the PEM server. Adding this to the pg_hba.conf and reloading the instance fixes the issue:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nhost    all             all             192.168.22.248\/32       md5\n<\/pre>\n<p>Once done:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent16.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent16.png\" alt=\"pem_agent16\" width=\"400\" height=\"322\" class=\"aligncenter size-full wp-image-17194\" \/><\/a><\/p>\n<p>&#8230; and the instance is there.<\/p>\n<p>In the next post we&#8217;ll setup some monitoring for our newly added PostgreSQL instance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the last post we did a click\/click\/click setup of the PEM server. What we want to do now is to attach a PostgreSQL instance to the PEM server for being able to monitor and administer it. For that we need to install the PEM agent on a host where we have a PostgreSQL instance [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":10250,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[713,1117,77],"type_dbi":[],"class_list":["post-10249","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-enterprisedb","tag-pem","tag-postgresql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>A first look at EDB Postgres Enterprise Manager 7 beta - Connecting a PostgreSQL instance - 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\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A first look at EDB Postgres Enterprise Manager 7 beta - Connecting a PostgreSQL instance\" \/>\n<meta property=\"og:description\" content=\"In the last post we did a click\/click\/click setup of the PEM server. What we want to do now is to attach a PostgreSQL instance to the PEM server for being able to monitor and administer it. For that we need to install the PEM agent on a host where we have a PostgreSQL instance [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-15T13:14:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"556\" \/>\n\t<meta property=\"og:image:height\" content=\"425\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"A first look at EDB Postgres Enterprise Manager 7 beta &#8211; Connecting a PostgreSQL instance\",\"datePublished\":\"2017-06-15T13:14:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/\"},\"wordCount\":198,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pem_agent1.png\",\"keywords\":[\"enterprisedb\",\"PEM\",\"PostgreSQL\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/\",\"name\":\"A first look at EDB Postgres Enterprise Manager 7 beta - Connecting a PostgreSQL instance - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pem_agent1.png\",\"datePublished\":\"2017-06-15T13:14:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pem_agent1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pem_agent1.png\",\"width\":556,\"height\":425},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A first look at EDB Postgres Enterprise Manager 7 beta &#8211; Connecting a PostgreSQL instance\"}]},{\"@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":"A first look at EDB Postgres Enterprise Manager 7 beta - Connecting a PostgreSQL instance - 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\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/","og_locale":"en_US","og_type":"article","og_title":"A first look at EDB Postgres Enterprise Manager 7 beta - Connecting a PostgreSQL instance","og_description":"In the last post we did a click\/click\/click setup of the PEM server. What we want to do now is to attach a PostgreSQL instance to the PEM server for being able to monitor and administer it. For that we need to install the PEM agent on a host where we have a PostgreSQL instance [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/","og_site_name":"dbi Blog","article_published_time":"2017-06-15T13:14:52+00:00","og_image":[{"width":556,"height":425,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent1.png","type":"image\/png"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"A first look at EDB Postgres Enterprise Manager 7 beta &#8211; Connecting a PostgreSQL instance","datePublished":"2017-06-15T13:14:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/"},"wordCount":198,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent1.png","keywords":["enterprisedb","PEM","PostgreSQL"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/","url":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/","name":"A first look at EDB Postgres Enterprise Manager 7 beta - Connecting a PostgreSQL instance - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent1.png","datePublished":"2017-06-15T13:14:52+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pem_agent1.png","width":556,"height":425},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/a-first-look-at-edb-postgres-enterprise-manager-7-beta-connecting-a-postgresql-instance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"A first look at EDB Postgres Enterprise Manager 7 beta &#8211; Connecting a PostgreSQL instance"}]},{"@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\/10249","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=10249"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10249\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10250"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10249"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}