PEM Agent User Guide

PEM is composed of three primary components: PEM server, PEM agent, and PEM web interface. The PEM agent is responsible for performing tasks on each managed machine and collecting statistics for the database server and operating system.

For information about the platforms and versions supported by PEM, see

Platform Compatibility .

This document provides information that is required to work with PEM agents. The guide will acquaint you with the basic registering, configuration, and management of agents. The guide is broken up into the following core sections:

• PostgresEnterpriseManager-Overview - This section provides an overview of PEM architecure.

• RegisteringaPEMAgent - This section provides information about registration of a PEM agent.

• ManagingaPEMagent - This section provides information about configuring and managing a PEM agent.

• TroubleshootingforPEMagent - This section provides information about troubleshooting for PEM agents.

This document uses Postgres to mean either the PostgreSQL or EDB Postgres Advanced Server database or EDB Postgres Extended.

pem_architecture registering_agent managing_pem_agent pem_agent_troubleshooting conclusion

• PEM architecture
  • The PEM server
  • The PEM agent
  • The PEM web client
  • The SQL Profiler plugin
• Registering an agent
  • Setting PEM agent configuration parameters
  • Using a non-root user account to register a PEM agent
• Managing a PEM agent
  • Agent privileges
  • Agent configuration
  • Agent properties
• PEM agent troubleshooting
  • Restoring a deleted PEM agent
  • Using the command line to delete a PEM agent with down or unknown status