{"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) &#8211; setting up the monitoring server"},"content":{"rendered":"<p>If you followed the <a href=\"http:\/\/dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/\" target=\"_blank\">first<\/a>, <a href=\"http:\/\/dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-2-setting-up-a-backup-and-recovery-server\/\" target=\"_blank\">second<\/a> and the <a href=\"http:\/\/dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-3-setting-up-a-hot-standby-server\/\" target=\"_blank\">third post<\/a> the current ppas infrastructure consists of a primary database, a hot standby database and a backup and recovery server.<br \/>\nNow we will add the monitoring server on another host so that the system overview looks like this:<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>server<\/strong><\/td>\n<td><strong>ip address<\/strong><\/td>\n<td><strong>purpose<\/strong><\/td>\n<\/tr>\n<tr>\n<td>ppas<\/td>\n<td>192.168.56.243<\/td>\n<td>ppas database cluster<\/td>\n<\/tr>\n<tr>\n<td>ppasstandby<\/td>\n<td>192.168.56.244<\/td>\n<td>ppas hot standby database<\/td>\n<\/tr>\n<tr>\n<td>ppasbart<\/td>\n<td>192.168.56.245<\/td>\n<td>backup and recovery server<\/td>\n<\/tr>\n<tr>\n<td>ppasem<\/td>\n<td>192.168.56.246<\/td>\n<td>ppas enterprise manager<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>On the ppasem host we will now install <a href=\"http:\/\/www.enterprisedb.com\/products\/postgres-enterprise-manager\/\" target=\"_blank\">postgres enterprise manager<\/a> to monitor our postgres infrastructure. As with ppas you&#8217;ll need to install java before you start:<\/p>\n<pre>yum install java\nAnd as with the installer for ppas there are several ways to get pem installed on the system:\n<\/pre>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">[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<p>We&#8217;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<pre class=\"brush: java; gutter: true; first-line: 1\">[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<p><a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_001.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_001.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_002.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_002.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_003.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_003.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_004.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_004.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_005.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_005.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_006.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_006.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_007.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_007.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_008.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_008.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_009.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_009.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_010.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_010.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_011.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_011.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_012.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_012.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_013.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_013.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_014.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_014.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_015.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_015.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_016.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_016.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_017.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_017.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_018.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_018.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_019.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_019.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_020.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_020.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_021.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_021.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_022.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_022.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_023.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_023.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_024.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_024.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_025.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_025.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_026.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_026.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_027.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_027.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_028.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_028.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_029.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_029.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_030.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_030.png\" alt=\"alt\" \/><\/a><br \/>\nOnce pem is installed adjust the httpd.conf to match the server&#8217;s IP-Address:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">[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<p>Then do a restart:<br \/>\nservice EnterpriseDBApachePhp restart<br \/>\nNow you should be able to check the http connection:<br \/>\n<a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_031.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_031.png\" alt=\"alt\" \/><\/a><br \/>\nFor interacting with the PEM there is the pem client. This client can be installed on any Linux or Windows host. I&#8217;ll do it on my linux box:<br \/>\nlocalhost:~\/Downloads$ chmod u+x pem_client-5.0.0-2-linux-x64.run<br \/>\nlocalhost:~\/Downloads$ .\/pem_client-5.0.0-2-linux-x64.run<br \/>\nlocalhost:~\/Downloads$ sudo .\/pem_client-5.0.0-2-linux-x64.run<\/p>\n<p><a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_032.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_032.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_033.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_033.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_034.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_034.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_035.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_035.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_036.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_036.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_037.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_037.png\" alt=\"alt\" \/><\/a><br \/>\nA shortcut in your Windows Start-Menu or you Linux Desktop should be available from now on:<br \/>\n <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_042.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_042.png\" alt=\"alt\" \/><\/a><br \/>\n One the client is started you can connect to the PEM server:<br \/>\n <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_038.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_038.png\" alt=\"alt\" \/><\/a><a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_039.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_039.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_040.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_040.png\" alt=\"alt\" \/><\/a><br \/>\n If the connection can be established you see the dashboard:<br \/>\n <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_044.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_044.png\" alt=\"alt\" \/><\/a><br \/>\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&#8217;ll add all my postgres hosts (primary,standby,bart) to the pg_hba.conf file on the pem server:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">-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<p>Remember to reload postgres for this changes to take effect:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">-bash-4.2$ pg_ctl -D data\/ reload\nserver signaled\n<\/pre>\n<p>Ready to install:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">[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<p><a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_045.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_045.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_046.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_046.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_047.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_047.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_048.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_048.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_049.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_049.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_050.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_050.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_051.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_051.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_052.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_052.png\" alt=\"alt\" \/><\/a><br \/>\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<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">-bash-4.2$ tail -1 data\/pg_hba.conf\nhost    all             enterprisedb    192.168.56.1\/24            md5\n<\/pre>\n<p>Start the pem client and just add the database and create the binding for the pem agent:<br \/>\n <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_053.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_053.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_054.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_054.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_055.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_055.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_056.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_056.png\" alt=\"alt\" \/><\/a> <a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_058.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_058.png\" alt=\"alt\" \/><\/a><br \/>\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:<br \/>\n<a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_059.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_059.png\" alt=\"alt\" \/><\/a><a class=\"easyblog-thumb-preview\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_060.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Selection_060.png\" alt=\"alt\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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&hellip;&nbsp;<\/p>\n","protected":false},"author":28,"featured_media":4660,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[],"class_list":["post-4659","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>getting started with postgres plus advanced server (4) - setting up the monitoring server - dbi services | 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&hellip;&nbsp;\" \/>\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 services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\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\/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=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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=\"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\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"getting started with postgres plus advanced server (4) &#8211; 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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"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\\\/2022\\\/04\\\/Selection_001.png\",\"articleSection\":[\"Database\"],\"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 services | 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\\\/2022\\\/04\\\/Selection_001.png\",\"datePublished\":\"2015-05-18T09:07:00+00:00\",\"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\\\/2022\\\/04\\\/Selection_001.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/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) &#8211; setting up the monitoring server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"caption\":\"Open source Team\"},\"description\":\"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/open-source-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"getting started with postgres plus advanced server (4) - setting up the monitoring server - dbi services | 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&hellip;&nbsp;","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 services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","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\/2022\/04\/Selection_001.png","type":"image\/png"}],"author":"Open source Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Open source Team","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":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"getting started with postgres plus advanced server (4) &#8211; 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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"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\/2022\/04\/Selection_001.png","articleSection":["Database"],"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 services | 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\/2022\/04\/Selection_001.png","datePublished":"2015-05-18T09:07:00+00:00","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\/2022\/04\/Selection_001.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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) &#8211; setting up the monitoring server"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","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":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","caption":"Open source Team"},"description":"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.","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\/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\/28"}],"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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}