Postgres Enterprise Manager (PEM) is an enterprise management tool designed to assist database administrators, system architects, and performance analysts in administering, monitoring, and tuning PostgreSQL and EnterpriseDB Advanced Server database servers. PEM can manage and monitor a handful of servers or hundreds of servers from a single console, allowing complete control over all aspects of your databases.A PEM installation consists of a PEM server, one or more PEM agents, and the backing database server (named pem). The PEM server includes a web interface that allows you to monitor and manage the database instances that are registered with a PEM agent. A PEM agent is responsible for returning metric information to the PEM server, and performing tasks on the database instances that are registered with that agent.The Ark console installation includes a pre-configured PEM server, a PEM agent, and the pem backing database. You also have the option of using a remote PEM server to monitor your Ark console. A remote server is a PEM server that has been installed and configured on another host.During deployment, you will be prompted to use the PEM Server Mode drop-down listbox to select a deployment mode:
• Select DISABLE to indicate that clusters deployed on the host should not be registered with the PEM server.
• Select LOCAL to indicate that you would like to use the PEM server that resides on your local host. If you select LOCAL, the PEM deployment will use default values assigned by the installer.
o The PEM Server DB Port will monitor port 5432.
• Select REMOTE to indicate that you would like to use a PEM server that resides on another host, and provide connection information on the Ark console deployment dialog (see Figure 2.8).
o Provide the host name or IP address of the PEM server host in the PEM Server Address field.
o Specify the port monitored for connections by the PEM server in the PEM Server DB Port field.
o Specify the port monitored for API connections in the PEM Server API Port field.
o Provide the name that should be used when authenticating with the PEM server in the PEM Server Username field.
o Provide the password associated with the PEM server user in the PEM Server Password field.If you select REMOTE, whenever a new cluster node is created on this console, it will be registered for monitoring by the PEM server. Please note that you must modify the pg_hba.conf file of the pem database on the remote PEM server to accept connections from the host of the Ark console. For detailed information about modifying the pg_hba.conf file, please see: