PEM Installation Guide

Postgres Enterprise Manager (PEM) is designed to assist database administrators, system architects, and performance analysts when administering, monitoring, and tuning PostgreSQL and Advanced Server database servers. PEM has been designed to manage and monitor a single server or multiple servers from a single console, allowing complete control over monitored databases.

This document provides step-by-step instructions to guide you through the installation of Postgres Enterprise Manager.

Throughout this guide, the term Postgres refers to either a PostgreSQL or an Advanced Server installation, where either is appropriate.

Language pack installers contain supported languages that may be used with EDB Postgres Advanced Server and EnterpriseDB PostgreSQL database installers. The language pack installer allows you to install Perl, TCL/TK, and Python without installing supporting software from third party vendors. For more information about installing and using Language Pack, please see the EDB Postgres Language Pack Guide, available from the EnterpriseDB Website.

• What’s New
• Postgres Enterprise Manager - Overview
  • Supported Platforms
  • Hardware Prerequisites
  • Software Prerequisites
• Installing Postgres Enterprise Manager
  • Installing the PEM Server on Windows
    • Installing the PEM Server and PEM-HTTPD on the Same Host
    • Installing the PEM Server and PEM-HTTPD on Separate Hosts
      • Specifying a Database Host
      • Installing Web Services
    • Installing the PEM Server on an Existing Postgres Server
      • Preparing the Postgres Server
        • Installing the sslutils Extension
        • Creating a Service Script or Registering the Service
      • Invoking the PEM Server Installer
    • Invoking the Server Installer from Command Line
      • Invoking the PEM Server Installer in Unattended Mode
      • Invoking the PEM Server Installer in Text Mode
  • Installing the PEM Server on Linux
    • Prerequisites for installing the PEM server on a Linux host
      • Additional Prerequisites for RHEL, CentOS, or SLES Hosts
    • Installing the PEM Server on a CentOS or RHEL Host
    • Installing the PEM Server on a Debian or Ubuntu Host
    • Installing PEM Server on a SLES Host
    • Configuring the PEM Server
  • Creating a PEM Repository in an Isolated Network
  • Installing a PEM Agent on Windows
    • Invoking the Agent Installer from the Command Line
      • Invoking the PEM Agent Installer in Unattended Mode
      • Invoking the PEM Agent Installer in Text Mode
  • Installing a PEM Agent on Linux
    • Installing a PEM agent on a CentOS or RHEL host
    • Installing a PEM Agent on a Debian or Ubuntu Host
    • Installing a PEM Agent on a SLES Host
    • Registering an Agent
• The PEM Web Interface
• Installing the SQL Profiler Plugin
  • Installing SQL Profiler using Graphical Installer
  • Configuring SQL Profiler
• Upgrading and Uninstalling PEM Components
• Reference - Linux Service Script
• Conclusion