1 Introduction

Table of Contents Previous Next


1 Introduction

PEM Query Tool - Chapter 2 introduces you to the PEM Query Tool. The Query Tool is a a feature-rich Interactive Development Environment (IDE) that allows you to issue ad-hoc SQL queries against Postgres servers.
Package Deployment – Chapter 3 introduces you to the PEM Package Deployment wizard.
Performance monitoring – Chapter 4 provides an introduction to monitoring and troubleshooting performance on your database servers.
Capacity planning – Chapter 5 discusses how to perform trend analysis and forecasting from data collected in Postgres Enterprise Manager.
Audit Manager – Chapter 6 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 Manager – Chapter 7 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 Expert – Chapter 8 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 Profiling – Chapter 9 describes how to capture a SQL workload and analyze the output to tune and fix poorly running SQL.
Tuning Wizard – Chapter 10 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 Enforcement – Chapter 11 discusses how to use Postgres Expert to uncover configuration or design issues that need correcting on your database servers.
Streaming Replication Wizard – Chapter 12 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.
Monitoring Failover Manager - Chapter 13 provides an overview of PEM functionality that allows you to monitor EDB Failover Manager.
Monitoring an xDB Replication Cluster - Chapter 14 provides an overview of PEM functionality that allows you to monitor EDB Failover Manager.
Performance Diagnostic – Chapter 15 provides an overview of PEM functionality that allows you to analyze the database performance for Advanced Server instances.
This document uses Postgres to mean either the PostgreSQL or EDB Postgres Advanced Server database.

1 Introduction

Table of Contents Previous Next