Installing the PEM Server on Windows

At the heart of each PEM installation is the server. In a production environment, the server will typically be a dedicated machine, monitoring a large number of Postgres servers or a smaller number of busy servers.

The PEM server backend database may be an EnterpriseDB distribution of the PostgreSQL or Advanced Server database server, or an existing Postgres server installed from another source. The Postgres backing database server must be any of the supported versions, and will contain a database named pem, which is used by the PEM server as a repository.

  • If you would like to use an existing Postgres server to host the PEM server, the PEM server installer can create the pem database on the Postgres host. You must manually satisfy the software pre-requisites if you choose to use an existing server.

    For more information about using an existing Postgres server to host the PEM server backend database, see Installing the PEM Server on an Existing Postgres Server section.

  • If you do not wish to use an existing installation of Postgres as the PEM server host, the PEM server installer can install PostgreSQL, satisfy the server host’s software pre-requisites, and create an instance (a PostgreSQL database cluster) that contains the pem database.

    This is the simplest PEM server installation option.

PEM-HTTPD is made available for Postgres installations through the PEM server installer or the StackBuilder utility. If PEM-HTTPD is already installed on the host, the PEM server installer will review and update the existing installation if required. If the PEM server host does not contain an existing PEM-HTTPD installation, the PEM server installer will add it.

Before installing the PEM server, you must decide if you wish to run PostgreSQL and PEM-HTTPD on the same host or on separate hosts. If you intend to run the PostgreSQL database server and PEM-HTTPD on different hosts, then you must run the PEM server installer twice – once on each host, as detailed in Installing the PEM Server and PEM-HTTPD on Separate Hosts section.

The PEM server installer will also install the software required to access the server via the PEM web interface. You can access the web interface with a supported version of your browser of choice.

The PEM web interface

The PEM web interface

You can use the web interface to review information about objects that reside on monitored servers, manage databases and database objects that reside on monitored servers, or review statistical information gathered by the PEM server. The interface also provides access to clusters that reside on registered EDB Ark consoles.

Installing the PEM Server and PEM-HTTPD on the Same Host

The easiest PEM server installation configuration consists of a PEM backend database server (hosted on a PostgreSQL database installed with the PEM server installer) and a PEM-HTTPD service that reside on the same host. In this configuration, the PEM server installer will provide the pre-requisite software for the backend host and create a service script (on Linux) or register the service (on Windows).

To invoke the PEM server installer on a Windows system, right click the installer icon and select Run as Administrator. The installer displays a Welcome dialog.

The PEM Server Installer's Welcome dialog

The PEM Server Installer’s Welcome dialog

Click Next to continue to the License Agreement dialog.

The Licencse Agreement

The License Agreement

Carefully review the license agreement before highlighting the appropriate radio button and accepting the agreement. Click Next to continue to the Installation Directory dialog.

Specify an installation directory

Specify an installation directory

Use the Installation Directory dialog to specify the location of the PEM server:

  • By default, the PEM server is installed in C:\Program Files\PEM on Windows. Accept the default location, or use the Installation Directory button to open a browser dialog and select the directory in which the PEM server will be installed.

  • Use the Show advanced options check box to instruct the installer to open the Advanced options dialog.

    Use the Advanced options dialog when installing the Postgres database server and the PEM-HTTPD on different hosts, or if you wish the PEM server to reside on an existing Postgres server installation.

To install the PostgreSQL server packaged with the installer and PEM-HTTPD on the same host, leave the Show advanced options box unchecked and click Next.

The PEM server installer will perform a pre-installation check for PEM-HTTPD, LanguagePack, and PostgreSQL 10. If the installer does not locate these packages, it will inform you in the Dependency missing dialog.

the installer checks for pre-requisites

The installer checks for pre-requisites

If the dependencies are missing, the PEM server installer will launch the respective installation wizards; follow the onscreen directions presented by the installation wizards for each package.

After installing any missing dependencies, the installation process continues by displaying the Database Server Installation Details dialog.

Credentials of the PostgreSQL superuser

Enter the name and password of the PostgreSQL superuser

The information provided on the Database Server Installation Details dialog enables the installer to connect to the PostgreSQL server. Provide the User name and Password of a database superuser. After supplying the requested information, click Next to continue to the Network Details dialog.

After providing the name and password of the Postgres database superuser, you may be prompted for the password to the user account under which the PEM agent will run. If prompted, provide the password, and press Next to continue.

Supply the network address

Supply the network address from which the agent will connect

Use the Network Details dialog to specify the CIDR-style network address from which the PEM agents will connect to the server (the client-side address).

You may specify the address of a network host, or a network address range. For example, if you wish to monitor database servers with the addresses 192.168.10.23, 192.168.10.76 and 192.168.10.184, enter 192.168.10.0/24 to allow connections with hosts in that network.

The specified address will be added to the server’s pg_hba.conf file. You can specify additional network addresses by manually adding entries to the pg_hba.conf file on the PostgreSQL server if required, using the initial entry as a template.

When you’ve added the Network address, click Next to continue to the Agent Details dialog.

The PEM server installer will install a PEM agent on the host on which the server resides, to monitor the server and provide alert processing and garbage collection services. A certificate will also be installed in the location specified in the Agent certificate path field.

Agent details description that resides on the server

Provide a Description for the agent that resides on the server

Enter an alternate description or select an alternate agent certificate path for the PEM agent, or accept the defaults. Click Next to continue to the Ready to Install dialog.

The installation is ready to begin

The installation is ready to begin

The wizard is now ready to install the PEM server.

Click Back to modify any of the options previously selected, or Next to continue with the installation.

the installation in progress

The installation in progress

During the installation process, the installer will copy files to the system, and set up the database and web services required to run PEM. When the installation completes, a popup dialog opens confirming that the webservice has been configured, and is listening on port 8443, and that the pem database has been created and configured.

A popup confirms the installation details

A popup confirms the installation details

Click OK to acknowledge that the webservice has been configured, and that the pem database has been created, and continue to the Completed… dialog.

The PEM server installation is complete

The PEM server installation is complete

Installing the PEM Server and PEM-HTTPD on Separate Hosts

To use separate hosts for the PEM server backend database and PEM-HTTPD, you must:

  1. Invoke the PEM server installer on the host of the Postgres server that will contain the pem database. During the installation, select the Database option on the Advanced options dialog, and provide connection information for the Postgres server.

  2. Modify the pg_hba.conf file of the Postgres installation on which the PEM server (and pem database) resides, allowing connections from the host of the PEM-HTTPD server.

  3. Invoke the PEM server installer on the host of the PEM-HTTPD server, selecting the Web Services option on the Installation Type dialog.

To invoke the PEM server installer on a Windows system, right click the installer icon and select Run as Administrator. The installer displays a Welcome dialog.

The PEM server Installer's Welcome dialog

The PEM Server Installer’s Welcome dialog

Click Next to continue to the License Agreement dialog.

The License Agreement

The License Agreement

Carefully review the license agreement before highlighting the appropriate radio button and accepting the agreement; click Next to continue.

The Installation Directory dialog

The Installation Directory dialog

Use fields on the Installation Directory dialog to specify the directory in which the PEM server will reside, and to access the Advanced options dialog:

  • By default, the PEM server is installed in the C:\Program Files\PEM on Windows. Accept the default location, or use the Installation Directory field to open a browser dialog and select the directory in which the PEM server will be installed.

  • To install the PEM server and PEM-HTTPD on separate hosts, you must use the Advanced options dialog to specify the installation type (Web Services or Database). Select the Show advanced options check box to instruct the installer to include the Advanced options dialog in the installation process.

Click Next to continue to the Advanced Options dialog.

The Advanced Options dialog

The Advanced Options dialog

Use the radio buttons on the Advanced options dialog to specify the component or components that you would like to install:

  • Select Web Services and Database to indicate that the Postgres server and PEM-HTTPD will both reside on the current host. If you select the Web Services and Database option, the PEM server installer will allow you to specify which Postgres server you wish to use for the PEM server before checking for a PEM-HTTPD installation.

  • Select Web Services to install PEM-HTTPD on the current host, while using a Postgres database server that resides on another host to host the PEM server and pem database.

Note

You must complete the PEM server installation process on the host of the PEM server (and pem backend database), selecting Database on the Advanced options dialog, and modifying the connection properties of the pg_hba.conf file on the PEM server before using the Web Services option to install PEM-HTTPD.

This option invokes the installation steps documented in Installing Web Services section.

  • Select Database to use an existing Postgres server, or to install only the database server that is distributed with the PEM server installer. This option invokes the installation steps documented in Specifying a Database Host.

After selecting an installation option, click Next to continue.

Specifying a Database Host

Selecting the Database option on the Advanced options dialog allows you to specify connection information for the host on which the PEM server backend database (named pem) will reside.

The PEM server Installer's Welcome dialog

The Advanced options dialog

Click Next to continue to the Database Server Selection dialog.

Selecting a database server

Selecting a database server

Use the drop-down listbox on the Database Server Selection dialog to select a host for the PEM server backend database. You can:

  • Select a host from existing Postgres installations that reside on the current host.

Note

You may be required to add the sslutils package to your installation.

  • Select the PostgreSQL 9.6 option to install the Postgres server that is distributed with the PEM server installer. If you decide to use the version of PostgreSQL that is bundled with the PEM server installer, the EnterpriseDB one-click PostgreSQL installer will open and walk you through the installation.

  • Select Other Database Server to specify connection information for a Postgres server that was not installed using a one-click graphical installer from EnterpriseDB. For information about the software pre-requisites for the PEM server database host, please see Preparing the Postgres Server section.

Click Next to continue.

If the PEM server will reside on an existing Postgres server, the Database Server Installation Details dialog shown in opens.

The Database Server Installation Details dialog

The Database Server Installation Details dialog

The information required on the Database Server Installation Details dialog may vary; the PEM server installer will ask you to provide only the information about the selected installation that it cannot locate:

  • Specify the name of a Postgres database superuser in the User field.

  • Specify the password associated with that user in the Password field.

Click Next to continue.

If prompted, provide the system password for the service account under which the PEM agent will run, and click Next to continue to the Network Details dialog.

Supply the network address

Supply the network address from which the agent will connect

Use the Network Details dialog to specify the CIDR-style network address from which PEM agents will connect to the server (the client-side address). The specified address will be added to the server’s pg_hba.conf file.

Note

You can specify additional network addresses by manually adding entries to the pg_hba.conf file on the PostgreSQL server.

Accept the default (specifying the localhost), or specify a Network address range, and click Next to continue to the Agent Details dialog.

The PEM server installer will install a PEM agent on the host on which the server resides, to monitor the server and provide alert processing and garbage collection services. A certificate will also be installed in the location specified in the Agent certificate path field.

Provide a Description for the agent

Provide a Description for the agent

You can enter an alternate description or an alternate agent certificate path for the PEM agent, or accept the defaults. Click Next to continue.

The installation is ready to begin

The installation is ready to begin

The wizard is now ready to install the PEM server. Click Back to modify any of the options previously selected, or Next to proceed with the installation.

The installation in progress

The installation in progress

During the installation process, the installer will copy files to the system, and set up the PEM server’s backend database. A popup dialog opens confirming that the pem database has been created and configured.

Click OK to confirm that the pem database has been created

Click OK to confirm that the pem database has been created

Click OK to acknowledge that the pem database has been created, and continue to the Completed… dialog.

The PEM server installation is complete

The PEM server installation is complete

When the database portion of the PEM server installation is complete, you can invoke the PEM server on another host to install (or upgrade) PEM-HTTPD.

Installing Web Services

Selecting the Web Services radio button on the Advanced options dialog instructs the PEM server installer to either install PEM-HTTPD on the current host or update an existing PEM-HTTPD installation.

Selecting the Web Services option on the Advanced options dialog

Selecting the Web Services option on the Advanced options dialog

Note

The current host may not be the host of the PEM backing database.

Before selecting this option, you must have:

  • Completed an installation of the PEM server installer on a host system, during which you specified a backing database for the PEM server.

  • Modified the pg_hba.conf file on the PEM server database host to allow connections from the PEM-HTTPD host, and restarted the database server.

When you select the Web Services option and click Next, the PEM server installer will check the current host for existing PEM-HTTPD and LanguagePack installations.

If the installer does not locate the components, the installer will inform you that one or more dependencies are missing.

The installer has detected missing dependencies

The installer has detected missing dependencies

Click Next to instruct the server to install LanguagePack

The installer has detected missing dependencies

The installer has detected missing dependencies

After installing language pack, the installer will invoke the PEM-HTTPD setup wizard.

The PEM-HTTPD installation wizard

The PEM-HTTPD installation wizard

Follow the onscreen instructions of the PEM-HTTPD Setup Wizard. When the wizard completes the installation, click Finish to open the Database Server Installation Details dialog.

The Database Server Installation Details dialog

The Database Server Installation Details dialog

Use the fields on the Database Server Installation Details dialog to provide connection information for the Postgres installation that is hosting the PEM server installation:

  • Enter the name or IP address of the PEM server host in the Host field.

  • Enter the port number on which the Postgres server is listening in the Port field.

  • Enter the name of a Postgres database superuser in the User field.

  • Enter the password associated with the Postgres superuser in the Password field.

Click Next to continue. Before completing the PEM server installation, the installer will contact the database host. The pg_hba.conf file on the PEM database host must be configured to accept connections from the host of the httpd server and the firewall must allow a connection for the installation to continue. The PEM server installer will complete the PEM server installation, adding only those items that must reside on the host of the PEM-HTTPD server.

Installing the PEM Server on an Existing Postgres Server

You can use an existing Postgres server to host the PEM server and the pem database. Postgres installers and pre-requisite software extensions are freely available on the EnterpriseDB website at

This section provides information about configuring an existing Postgres server for a PEM server installation.

Note

The steps that follow should be considered guidelines only; the actual steps required to configure your Postgres installation will vary depending on the configuration of your Postgres server.

The following versions of Postgres are pre-configured to contain the sslutils extension and a service script; no additional preparation is required to use the following Postgres versions as a PEM backend database server:

  • PostgreSQL (as bundled with the PEM Server installer)

  • Advanced Server

Preparing the Postgres Server

Before installing the PEM server on an existing Postgres server, you must:

After preparing the server, you can use the PEM server installer to install PEM on the existing Postgres server.

Installing the sslutils Extension

The Postgres server on which the PEM server will reside must contain the sslutils extension. The sslutils package is freely available for download from the EnterpriseDB website

When the web page opens, select the link for the SRC- SSL Utils 1.2 package. When the download completes, extract the file, and copy it into the Postgres installation directory.

On Linux

If the Postgres server resides on a Linux system, you must use the gcc compiler to build sslutils.

  1. Use yum to install gcc:

    yum install gcc

  2. Set the value of PATH so it can locate the pg_config program:

    export PATH=$PATH:/opt/postgres_inst_dir/9.x/bin/

  3. Then, use yum to install the sslutil dependencies:

    yum install openssl-devel

  4. Move into the sslutils folder, and enter:

    make USE_PGXS=1
    make USE_PGXS=1 install
  5. Use psql to create the sslutils extension:

    CREATE EXTENSION sslutils

On Windows

Remember: You are not required to manually add the sslutils extension when using the following Postgres installations:

  • PostgreSQL (as distributed with the PEM server installer)

  • Advanced Server

sslutils must be built with the same compiler that was used to compile the backend Postgres installation. If you are using a backend Postgres database that was installed on a Windows platform using a PostgreSQL one-click installer (from EnterpriseDB) or an Advanced Server installer, you must use Visual Studio to build sslutils.

While specific details of the installation process will vary by platform and compiler, the basic steps are the same. You must:

  1. Copy the sslutils package to the Postgres installation directory.

  2. Open the command line of the appropriate compiler, and navigate into the sslutils directory.

  3. Use the following commands to build sslutils:

    SET USE_PGXS=1

    SET GETTEXTPATH=<path_to_gettext>

    SET OPENSSLPATH=<path_to_openssl>

    SET PGPATH=<path_to_pg_installation_dir>

    SET ARCH=x86

    REM Set ARCH x64 for 64 bit

    msbuild sslutils.proj /p:Configuration=Release

    Where:

    path_to_gettext specifies the location of the GETTEXT library and header files.

    path_to_openssl specifies the location of the openssl library and header files.

    path_to_pg_installation_dir specifies the location of the Postgres installation.

  4. Copy the compiled sslutils files to the appropriate directory for your installation. The sslutils directory will contain the following files:

    sslutils--1.1.sql

    sslutils--unpackaged--1.1.sql

    sslutils--pemagent.sql.in

    sslutils.dll

    Copy the .dll libraries and .sql files into place:

    COPY sslutils*.sql* "%PGPATH%\share\extension\"

    COPY sslutils.dll "%PGPATH%\lib\"

Creating a Service Script or Registering the Service

A service script allows the PEM server to start, stop or restart the server if necessary when performing configuration management, certificate management, or other administrative tasks.

When you install a PostgreSQL or an Advanced Server database using an installer from EnterpriseDB (such as the PostgreSQL one-click installer), the installer will create a service script, or on Windows, register the service for you. If you have built the Postgres installation from source, you are required to manually create a service script.

While the PEM server installer checks for the presence of the service script, it does not check the integrity of the script itself; for PEM to function properly, you must ensure that the service script works as expected.

Writing a Linux Service Script

On Linux, the service script must reside in the /etc/init.d directory. The service script must be able to start, stop and restart the database server. Service scripts are platform-specific; you can find a sample service script for Linux in Linux Service Script (Sample) section. For information about customizing a Postgres service, visit:

Registering a Service on Windows

If you are using Windows to host the PEM backend database, you must register the name of the Postgres server with the Windows service manager. If you are using a Postgres server that was created using an EnterpriseDB installer, the service will be registered automatically. If you are manually building the installation, you can use the register clause of the Postgres pg_ctl command to register the service. The syntax of the command is:

pg_ctl register [-N <service_name>] [-U <user_name>] | [-P <password>] [-D <data_directory>]

Where:

service name specifies the name of the Postgres cluster.

user_name specifies the name of an operating system user with sufficient privileges to access the Postgres installation directory and start the Postgres service.

password specifies the operating system password associated with the user.

data_directory specifies the location of the Postgres data directory.

For more information about using the pg_ctl command and the available command options, see the

Invoking the PEM Server Installer

After preparing the existing Postgres server, invoke the PEM server installer. Assume superuser (or, on Windows, Administrative) privileges and navigate into the directory that contains the installer. Then, invoke the installer with the command:

./pem_server-7.<x>.<x>-<x>-<platform>

Where x is the major and minor versions of PEM and platform is the platform.

The installer displays a Welcome dialog.

The PEM server Installer's Welcome Dialog

The PEM server Installer’s Welcome Dialog

Click Next to continue to the License Agreement dialog.

The License Agreement

The License Agreement

Carefully review the license agreement before highlighting the appropriate radio button and accepting the agreement; click Next to continue to the Installation Directory dialog.

The Installation Directory dialog

The Installation Directory dialog

Use the Installation Directory dialog to specify the location of the PEM server and access the Advanced options dialog:

  • Use the Installation Directory field to open a browser dialog and select the directory in which the PEM server will be installed.

  • If you are installing the PEM server on an existing server, check the box next to Show advanced options to instruct the installer to include the Advanced options dialog in the installation process.

Click Next to continue.

The Advanced Options dialog

The Advanced Options dialog

Use the radio buttons on the Advanced options dialog to specify an installation type. Select:

  • Web Services and Database if both the Postgres server and the PEM-HTTPD server will reside on the current host. This option is valid if you are using an existing Postgres server to host the PEM server, or using the PEM server installer to install the Postgres server on which the PEM server will reside.

    If you select Web Services and Database, the PEM server installer will check the current host for a PEM-HTTPD installation, and upgrade or install PEM-HTTPD if necessary.

  • Web Services if only the PEM-HTTPD server will reside on the current host. See Installing Web Services section for more information about invoking this option.

  • Database if you are installing only the PEM server (and creating the pem backend database) on the current host. This option is valid if you are using an existing Postgres server to host the PEM server, or using the PEM server installer to install the PostgreSQL server on which PEM will reside.

After selecting an installation option, click Next to continue.

The Database Server Selection dialog

The Database Server Selection dialog

Use the drop-down listbox on the Database Server Selection dialog to select a backend database for the PEM server:

  • Select the name of a Postgres server on the current host that was installed using a Postgres one-click installer or Advanced Server installer.

  • Select the PostgreSQL 9.6 (Packaged) option to instruct the installation wizard to install and use the PostgreSQL server that is packaged with the PEM server installer.

  • Select Other Database Server to instruct the PEM server installer to use a Postgres database that was installed from a source other than an EnterpriseDB installer (i.e. from an rpm, or built from source).

Note

The selected database server must include an installation of the sslutils contrib module, and have a startup script (on Linux) or a registered service (on Windows).

For information about Preparing the Postgres Server, please see this section.

If you selected Web Services and Database on the Advanced options dialog, the installation wizard will check the current host for an existing PEM-HTTPD installation, and upgrade or install the service as needed.

If you selected Database on the Advanced options dialog, the Database Server Installation Details dialog opens.

The Database Server Installation Details dialog

The Database Server Installation Details dialog

Use the fields on the Database Server Installation Details dialog to describe the connection to the Postgres server that will host the PEM server:

  • Enter the port number on which the Postgres server listens in the Port field.

  • Enter the name of a database superuser in the User field.

  • Enter the password associated with the superuser in the Password field.

  • Enter the name of the service script for the Postgres server in the Service Name field.

Note

For information about preparing a service script, please see this section

Click Next to continue.

Supply the network address from which the agent will connect

Supply the network address from which the agent will connect

Use the Network Details dialog to specify the CIDR-style network address from which the PEM agents will connect to the server (the client-side address). The specified address will be added to the server’s pg_hba.conf file.

You can specify additional network addresses by manually adding entries to the pg_hba.conf file on the PostgreSQL server if required, using the initial entry as a template.

When you’ve added the Network address, click Next to continue to the Agent Details dialog.

The PEM server installer will install a PEM agent to the host on which the server resides, to monitor the server and provide alert processing and garbage collection services. A certificate will also be installed in the location specified in the Agent certificate path field.

Provide a Description for the agent that resides on the server

Provide a Description for the agent that resides

You can enter an alternate description or an alternate agent certificate path for the PEM agent, or accept the defaults. Click Next to continue to the Ready to Install dialog.

The installation is ready to begin

The installation is ready to begin

The wizard is now ready to install the PEM server. Click Back to modify any of the options previously selected, or Next to continue with the installation.

The installation in progress

The installation in progress

During the installation process, the installer will copy files to the system, and set up the PEM server’s backend database. A popup dialog opens confirming that the pem database has been created and configured.

Click OK to confirm that the pem database has been created

Click OK to confirm that the pem database has been created

Click OK to acknowledge that the pem database has been created, and continue to the Completed… dialog.

The PEM server installation is complete

The PEM server installation is complete

If you are using a PEM-HTTPD service that resides on a separate host, you must:

  • Modify the pg_hba.conf file on the Postgres server host to allow connections between the hosts.

  • Invoke the PEM server installer on the host of the PEM-HTTPD server. See Installing Web Services section for more information about installing PEM-HTTPD.

Invoking the Server Installer from Command Line

The command line options of the PEM server and PEM agent installers offer functionality in situations where a graphical installation may not work because of limited resources or system configuration. You can:

  • Include the --mode unattended option when invoking the installer to perform an installation without additional user input.

  • Include the --mode text option when invoking the installer to perform an installation from the command line with an interactive installer.

Not all command line options are suitable for all platforms. For a complete reference guide to the command line options, include the --help option when you invoke the installer.

Invoking the PEM Server Installer in Unattended Mode

You can perform an unattended PEM server installation by providing installation preferences on the command line when invoking the installer. Please note that the system on which you are installing the PEM server must have internet access.

You must have Administrative privileges to install the PEM server. Before invoking the PEM server installer, you must install the following dependencies:

  • PostgreSQL

  • pem-httpd

  • Language Pack

You can use the PEM server installer to satisfy the dependencies of the PEM server; use the following command to extract the dependencies. Navigate to the location of the installer, and use the following command to extract the dependencies:

pem-server-7.<x>.<x>-windows-x64.exe --extract-dependents C:\

In our example, the files are extracted to the C:\ directory. After extracting the files, you must install each program. Navigate into the directory that contains the files (in our example, C:\), and enter:

edb-languagepack-<version>-windows-x64.exe --mode unattended
pem-httpd-<version>-windows-x64.exe --mode unattended
postgresql-<version>-windows-x64.exe –mode unattended

Then, you can invoke the PEM server installer:

pem-server-7.<x>.<x>-windows-x64.exe --mode unattended
--existing-user <registered_edb_user> --existing-password
<edb_user_password> --pgport <port> --pguser postgres
--pgpassword postgres -–cidr-address <cidr_address_range>
--agent_description pem-agent --systempassword <windows_password> --agent-crt-path C:\edb

Where:

registered_edb_user specifies the name of a registered EnterpriseDB user. To register, visit the EDB website

edb_user_password specifies the password associated with the EDB user account.

port specifies the port used by the backing PostgreSQL database; by default, the PostgreSQL database uses port 5432.

cidr_address_range specifies the address range that will be added to the pg_hba.conf file of the PEM server’s backing database to allow connections from the agents that will be monitored by the server. You may wish to specify a network range (for example, 192.168.2.0/24) to provide server access to agents that reside on the same network.

windows_password specifies the password associated with the Windows Administrator’s account.

Note

when invoked in unattended mode, the PostgreSQL installer creates a user named postgres, with a password of postgres.

Invoking the PEM Server Installer in Text Mode

You can invoke the PEM server installer at the command line to perform an interactive installation if your system does not support a full graphical installation. Please note that the system on which you are installing PEM must have internet access.

You must have Administrative privileges to install the PEM server. Before invoking the PEM server installer, you must install the following dependencies:

  • PostgreSQL

  • pem-httpd

  • Language Pack

You can use the PEM server installer to satisfy the dependencies of the PEM server; use the following command to extract the dependencies. Navigate to the location of the installer, and use the following command to extract the dependencies:

pem-server-7.<x>.<x>-windows-x64.exe --extract-dependents C:\

After extracting the files, you must install each program; navigate into the directory that contains the files, and enter:

edb-languagepack-<version>-windows-x64.exe --mode unattended
pem-httpd-<version>-windows-x64.exe --mode unattended
postgresql-<version>-windows-x64.exe --mode unattended

Then, you can invoke the PEM server installer with the following command:

pem-server-7.<x>.<x>-windows-x64.exe --mode text

Example

The example that follows demonstrates performing a text-mode installation on a Linux system; the installation process on a Windows system is similar.

When you invoke the installer, the installer welcomes you:

---------------------------------------------------------------------
Welcome to the Postgres Enterprise Manager (PEM) Server Setup Wizard.
---------------------------------------------------------------------

Before installing the PEM server, you must review and accept the terms of the PEM license agreement:

Please read the following License Agreement. You must accept the terms
of this agreement before continuing with the installation.
Review the license agreement; when prompted, accept the agreement, and
press Return.
Do you accept this license? [y/n]: y
-----------------------------------------------------------------

After accepting the license agreement, you will be prompted for the name and address of a registered EnterpriseDB user; provide the information when prompted:

EnterpriseDB User Account Information
Please enter the email address and password for your enterprisedb.com
user account.

Email address [ ]:
Password :
-------------------------------------------------------------------

Next, you will be prompted for an installation directory; you can use the default installation directory, or specify an alternate location.

Enter a Y after Show advanced options to access menu options that allow you to use a pre-existing Postgres server installation or PEM-HTTPD installation with the PEM server.

Installation Directory
Please select a directory for the PEM server installation.
Installation Directory [/opt/edb/pem]:
Show advanced options [y/N]:
------------------------------------------------------------------

Use the fields that follow the Database Server Installation Details heading to provide the name and password of the PostgreSQL database superuser for the PEM backing database:

Database Server Installation Details

Please specify user and password for the local server - 'PostgreSQL
10' installation running on port 5432.
User [postgres]:
Password :
-----------------------------------------------------------------

When prompted, provide the network address or range that will be added to the pg_hba.conf file of the PEM server host; this will allow PEM agents on monitored hosts to contact the server:

Network Details

Please enter the CIDR formatted network address range that agents will
connect to the server from, to be added to the server's pg_hba.conf
file. For example, 192.168.1.0/24.

Network address [127.0.0.1/32]:
--------------------------------------------------------------

Use the Agent Details fields to specify a descriptive name for the agent and the location of the agent certificate:

Agent Details.

Please specify a description for the agent.
Description. [Postgres Enterprise Manager Host]:
Agent certificate path [/root/.pem]:
------------------------------------------------------------------

The installer will prompt you before it proceeds with the installation; press Return to start the installation:

Setup is now ready to begin installing the PEM server on your computer.
Do you want to continue? [Y/n]:
Please wait while Setup installs the PEM server on your computer.

Installing
0%______________ 50% ______________ 100%
###########################

The installer will notify you when the installation is complete:

Info: Configured the webservice for Postgres Enterprise Manager (PEM)``
Server on port '8443'.
Created and configured the 'pem' database.
EnterpriseDB is the leading provider of value-added products and services for the Postgres community.
Please visit our website at www.enterprisedb.com