PEM Installation Guide on Windows

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 EDB 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 EDB Website.

• PEM - Hardware and Software Requirements
  • Hardware Prerequisites
  • Software Prerequisites
• PEM Architecture
  • The PEM Server
  • The PEM Agent
  • The PEM Web Client
  • The SQL Profiler Plugin
• 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
    • Installing the PEM Server on an Existing Postgres Server
    • Invoking the Server Installer from Command Line
  • Configuring the PEM Server to use Two-Factor Authentication
  • Mail Server configuration
  • Installing a PEM Agent on Windows
    • Invoking the Agent Installer from the Command Line
• The PEM Web Interface
• Uninstalling Postgres Enterprise Manager Components