Table of Contents 1 Introduction 1.1 What's New 1.2 Typographical Conventions Used in this Guide 2 Postgres Enterprise Manager - Overview 2.1 Why Postgres Enterprise Manager? 2.2 General Architecture 2.3 Supported Versions and Platforms 2.4 Installing PEM - Overview 3 Using the PEM Web Interface 3.1 The PEM Toolbar 3.2 Controlling and Customizing Charts, Graphs and Tables 4 Managing a Monitored Server 4.1 Manually Registering a Server 4.2 Automatic Server Discovery 4.3 Using the pemworker Utility to Register a Server 4.3.1 Using the pemworker Utility to UnRegister a Server 4.4 Verifying the Connection and Binding 4.5 Remotely Starting and Stopping Monitored Servers 5 General Database Administration 5.1 Editing the PEM Server Configuration 5.2 Starting and Stopping the PEM Server and Agents 5.3 Managing Security 5.3.1 Login Roles 5.3.2 Group Roles 5.3.3 Using PEM Pre-Defined Roles to Manage Access to PEM Functionality 5.3.4 Using a Team Role 5.3.5 Object Permissions 5.4 Creating and Maintaining Databases and Objects 5.5 Online Help and Documentation 6 Server Management 6.1 Controlling the PEM Server or PEM Agent on Linux 6.2 Controlling the PEM Server or PEM Agent on Windows 6.3 Controlling the HTTPD Server 6.4 Modifying the pg_hba.conf File 6.5 Managing PEM Authentication 6.6 Modifying PEM to Use a Proxy Server 6.7 Certificate Management 7 PEM Agent Management 7.1 PEM Agent Privileges 7.2 Agent Configuration 7.3 PEM Agent Properties 8 Replacing SSL Certificates 8.1 Updating Agent SSL Certificates