Table of Contents Previous Next


3 Installing Postgres Enterprise Manager™ : 3.1 Using a Graphical Installer to Install the PEM Server : 3.1.3 Installing the PEM Server on an Existing Postgres Server

You can use an existing Postgres server (version 9.3 or later) to host the PEM server and the pem database. Postgres installers and pre-requisite software extensions are freely available from the EnterpriseDB website at:
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:
Ensure that the Postgres server contains an installation of the sslutils extension. For more information, see Section 3.1.3.1.1.
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 at:
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.
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:
4.
Move into the sslutils folder, and enter:
Remember: You are not required to manually add the sslutils extension when using the following Postgres installations:
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.
1.
Copy the sslutils package to the Postgres installation directory.
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
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:
Copy the .dll libraries and .sql files into place:
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 Section 7 Linux Service Script (Sample). For information about customizing a Postgres service, visit:
pg_ctl register [-N service_name] [-U user_name]
[-P
password] [-D data_directory]
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 Postgres core documentation, available at:

3 Installing Postgres Enterprise Manager™ : 3.1 Using a Graphical Installer to Install the PEM Server : 3.1.3 Installing the PEM Server on an Existing Postgres Server

Table of Contents Previous Next