{"id":4659,"date":"2015-05-18T11:07:00","date_gmt":"2015-05-18T09:07:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/"},"modified":"2015-05-18T11:07:00","modified_gmt":"2015-05-18T09:07:00","slug":"getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/","title":{"rendered":"getting started with postgres plus advanced server (4) – setting up the monitoring server"},"content":{"rendered":"

If you followed the first<\/a>, second<\/a> and the third post<\/a> the current ppas infrastructure consists of a primary database, a hot standby database and a backup and recovery server.
\nNow we will add the monitoring server on another host so that the system overview looks like this:<\/p>\n\n\n\n\n\n\n\n
server<\/strong><\/td>\nip address<\/strong><\/td>\npurpose<\/strong><\/td>\n<\/tr>\n
ppas<\/td>\n192.168.56.243<\/td>\nppas database cluster<\/td>\n<\/tr>\n
ppasstandby<\/td>\n192.168.56.244<\/td>\nppas hot standby database<\/td>\n<\/tr>\n
ppasbart<\/td>\n192.168.56.245<\/td>\nbackup and recovery server<\/td>\n<\/tr>\n
ppasem<\/td>\n192.168.56.246<\/td>\nppas enterprise manager<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

On the ppasem host we will now install postgres enterprise manager<\/a> to monitor our postgres infrastructure. As with ppas you’ll need to install java before you start:<\/p>\n

yum install java\nAnd as with the installer for ppas there are several ways to get pem installed on the system:\n<\/pre>\n
[root@ppaspem tmp]# chmod u+x pem_server-5.0.0-2-linux-x64.run\n[root@ppaspem tmp]# .\/pem_server-5.0.0-2-linux-x64.run --help\nPostgres Enterprise Manager Server 5.0.0-2\nUsage:\n\n --help                         Display the list of valid options\n\n --version                      Display product information\n\n --unattendedmodeui unattendedmodeui Unattended Mode UI\n                                Default: minimal\n                                Allowed: none minimal minimalWithDialogs\n\n --optionfile optionfile      Installation option file\n                                Default: \n\n --debuglevel debuglevel      Debug information level of verbosity\n                                Default: 2\n                                Allowed: 0 1 2 3 4\n...\n<\/pre>\n
We’ll go with the GUI mode for this demo. Basically it is just clicking next, next, next and everything should go fine. A lot of screenshots will follow:<\/p>\n
[root@ppaspem tmp]# .\/pem_server-5.0.0-2-linux-x64.run\n [root@ppaspem tmp]# systemctl list-unit-files | grep fire\n firewalld.service enabled\n [root@ppaspem tmp]# systemctl stop firewalld.service\n [root@ppaspem tmp]# systemctl disable firewalld.service\n rm '\/etc\/systemd\/system\/dbus-org.fedoraproject.FirewallD1.service'\n rm '\/etc\/systemd\/system\/basic.target.wants\/firewalld.service'\n [root@ppaspem tmp]#<\/pre>\n
\"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a>
\nOnce pem is installed adjust the httpd.conf to match the server’s IP-Address:<\/p>\n
[root@ppaspem tmp]# grep 192.168.56.246 \/opt\/PostgreSQL\/EnterpriseDB-ApachePHP\/apache\/conf\/httpd.conf\nListen 192.168.56.246:8080\nServerName 192.168.56.246:8080\n<\/pre>\n
Then do a restart:
\nservice EnterpriseDBApachePhp restart
\nNow you should be able to check the http connection:
\n\"alt\"<\/a>
\nFor interacting with the PEM there is the pem client. This client can be installed on any Linux or Windows host. I’ll do it on my linux box:
\nlocalhost:~\/Downloads$ chmod u+x pem_client-5.0.0-2-linux-x64.run
\nlocalhost:~\/Downloads$ .\/pem_client-5.0.0-2-linux-x64.run
\nlocalhost:~\/Downloads$ sudo .\/pem_client-5.0.0-2-linux-x64.run<\/p>\n
\"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a>
\nA shortcut in your Windows Start-Menu or you Linux Desktop should be available from now on:
\n \"alt\"<\/a>
\n One the client is started you can connect to the PEM server:
\n \"alt\"<\/a>\"alt\"<\/a> \"alt\"<\/a>
\n If the connection can be established you see the dashboard:
\n \"alt\"<\/a>
\n As we want to have at least the primary database monitored we will need to install pem agent on the primary host. Before we start the pem agent installation we need to allow connection to the postgres database on the pem host. To do this I’ll add all my postgres hosts (primary,standby,bart) to the pg_hba.conf file on the pem server:<\/p>\n
-bash-4.2$ tail -3 data\/pg_hba.conf\nhost     all             postgres        192.168.56.243\/32       md5\nhost     all             postgres        192.168.56.244\/32       md5\nhost     all             postgres        192.168.56.245\/32       md5\n<\/pre>\n
Remember to reload postgres for this changes to take effect:<\/p>\n
-bash-4.2$ pg_ctl -D data\/ reload\nserver signaled\n<\/pre>\n
Ready to install:<\/p>\n
[root@ppas tmp]# ls\npem_agent-5.0.0-2-linux-x64.run  primary_base_backup\n[root@ppas tmp]# chmod u+x pem_agent-5.0.0-2-linux-x64.run\n[root@ppas tmp]# .\/pem_agent-5.0.0-2-linux-x64.run \n<\/pre>\n
\"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a>
\n So now that the pem agent is installed on the primary database host we can add the database to pem. Remember to put the host from where you start the pem client into the pg_hba.conf file on the primary database server (otherwise you will not be able to connect):<\/p>\n
-bash-4.2$ tail -1 data\/pg_hba.conf\nhost    all             enterprisedb    192.168.56.1\/24            md5\n<\/pre>\n
Start the pem client and just add the database and create the binding for the pem agent:
\n \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a> \"alt\"<\/a>
\n Mission complete. Have fun with the Postgres Enterprise Manager. I might be a good idea to add the standby database, too. Btw.: There is a web client for PEM, too, but this requires a product key:
\n\"alt\"<\/a>\"alt\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
If you followed the first, second and the third post the current ppas infrastructure consists of a primary database, a hot standby database and a backup and recovery server. Now we will add the monitoring server on another host so that the system overview looks like this: server ip address purpose ppas 192.168.56.243 ppas database […]<\/p>\n","protected":false},"author":29,"featured_media":4660,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[77],"type_dbi":[],"class_list":["post-4659","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-postgresql"],"acf":[],"yoast_head":"\ngetting started with postgres plus advanced server (4) - setting up the monitoring server - 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\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"getting started with postgres plus advanced server (4) - setting up the monitoring server\" \/>\n<meta property=\"og:description\" content=\"If you followed the first, second and the third post the current ppas infrastructure consists of a primary database, a hot standby database and a backup and recovery server. Now we will add the monitoring server on another host so that the system overview looks like this: server ip address purpose ppas 192.168.56.243 ppas database […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-18T09:07:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_001.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"430\" \/>\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=\"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\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"getting started with postgres plus advanced server (4) – setting up the monitoring server\",\"datePublished\":\"2015-05-18T09:07:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/\"},\"wordCount\":444,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_001.png\",\"keywords\":[\"PostgreSQL\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/\",\"name\":\"getting started with postgres plus advanced server (4) - setting up the monitoring server - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_001.png\",\"datePublished\":\"2015-05-18T09:07:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_001.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_001.png\",\"width\":550,\"height\":430},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"getting started with postgres plus advanced server (4) – setting up the monitoring server\"}]},{\"@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 &\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":"getting started with postgres plus advanced server (4) - setting up the monitoring server - 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\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/","og_locale":"en_US","og_type":"article","og_title":"getting started with postgres plus advanced server (4) - setting up the monitoring server","og_description":"If you followed the first, second and the third post the current ppas infrastructure consists of a primary database, a hot standby database and a backup and recovery server. Now we will add the monitoring server on another host so that the system overview looks like this: server ip address purpose ppas 192.168.56.243 ppas database […]","og_url":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/","og_site_name":"dbi Blog","article_published_time":"2015-05-18T09:07:00+00:00","og_image":[{"width":550,"height":430,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_001.png","type":"image\/png"}],"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\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"getting started with postgres plus advanced server (4) – setting up the monitoring server","datePublished":"2015-05-18T09:07:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/"},"wordCount":444,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_001.png","keywords":["PostgreSQL"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/","url":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/","name":"getting started with postgres plus advanced server (4) - setting up the monitoring server - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_001.png","datePublished":"2015-05-18T09:07:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_001.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_001.png","width":550,"height":430},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-4-setting-up-the-monitoring-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"getting started with postgres plus advanced server (4) – setting up the monitoring server"}]},{"@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 &\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\/4659","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=4659"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4659\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4660"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4659"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}