Postgres Enterprise Manager - Administration Guide

Welcome to Postgres Enterprise Manager (PEM) Administration Guide. This guide describes all the functionality and feature used when managing and administrating PEM. PEM consists of components that provide the management and analytical functionality for your EDB Postgres Advanced Server or PostgreSQL database. PEM is based on the Open Source pgAdmin 4 project. PEM is a comprehensive database design and management system. PEM is designed to meet the needs of both novice and experienced Postgres users alike, providing a powerful graphical interface that simplifies the creation, maintenance, and use of database objects.

• Registering a Postgres server
  • Manually registering a database server
  • Automatic server discovery
  • Using the pemworker utility to register a server
    • Using the pemworker utility to unregister a server
  • Verifying the connection and binding
  • Registering Postgres clusters on AWS
    • Monitoring a Postgres cluster running on AWS EC2
    • Monitoring a Postgres cluster running on AWS RDS
• Registering a PEM agent
  • Unregistering a PEM agent
  • Setting PEM agent configuration parameters
  • Using a non-root user account to register a PEM agent
• Managing a PEM server
  • Starting and stopping the PEM server and agents
  • Controlling the PEM server or PEM agent on Linux
  • Controlling the PEM server or PEM agent on Windows
  • Controlling the HTTPD server
  • Managing PEM authentication
  • Editing the PEM server configuration
  • Managing security
    • Login roles
    • Group roles
    • Using PEM pre-defined roles to manage access to PEM functionality
    • Using a team role
    • Object permissions
  • Server configuration parameters - reference
• Managing Postgres servers
  • Starting and stopping monitored database servers
  • Modifying the pg_hba.conf file
  • Creating and maintaining databases and objects
  • Template Linux service script
• Managing a PEM agent
  • Managing job notifications
    • Configuring job notifications at job level
    • Configuring job notifications at agent level
    • Configuring job notifications at server level
  • Managing PEM scheduled jobs
  • Agent privileges
  • Agent configuration
  • Agent properties
• Managing certificates
  • Replacing SSL certificates
  • Updating agent SSL certificates
• Managing configuration settings