Table of Contents Previous Next


1 Introduction

Postgres Enterprise Manager OverviewChapter 2 provides information about PEM functionality, components, architecture, and supported platforms.
Installation, configuration and general setupChapter 3 provides an overview of PEM's installation and configuration steps.
General database administration Chapter 4 will assist you in performing general database administration tasks, and SQL query and stored procedure development.
Package Deployment Chapter 5 introduces you to the PEM Package Deployment wizard.
Performance monitoringChapter 6 provides an introduction to monitoring and troubleshooting performance on your database servers.
Capacity planningChapter 7 discusses how to perform trend analysis and forecasting from data collected in Postgres Enterprise Manager.
Audit ManagerChapter 8 provides information about using Audit Manager to configure logging attributes, and using the Audit Log Analysis dashboard to filter and review the log files.
Log ManagerChapter 9 walks you through using Log Manager to modify server log configuration parameters, and using the Server Log Analysis dashboard to filter and review the server log.
Postgres Log Analysis ExpertChapter 10 introduces you to the Log Analysis expert. The Log Analysis Expert analyzes the log files of registered servers and produces a report that provides an analysis of your Postgres cluster's usage based on log file entries.
SQL ProfilingChapter 11 describes how to capture a SQL workload and analyze the output to tune and fix poorly running SQL.
Tuning WizardChapter 12 walks you through using the PEM Tuning Wizard. The PEM Tuning Wizard reviews your installation and recommends a set of configuration options that will help tune your installation.
Postgres Expert - Best Practices EnforcementChapter 13 discusses how to use Postgres Expert to uncover configuration or design issues that need correcting on your database servers.
Streaming Replication Wizard Chapter 14 discusses using the Streaming Replication wizard to configure Postgres Streaming Replication on new or existing servers, and how to monitor the servers when the replication scenario is up and running.
This document uses Postgres to mean either the PostgreSQL or EDB Postgres Advanced Server database.

1 Introduction

Table of Contents Previous Next