Postgres Enterprise Manager - Planning Guide

Welcome to Postgres Enterprise Manager (PEM) Plannning Guide. This guide describes architecutre and considerations when you are planning to use 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.

• Understanding Postgres Enterprise Manager components and architecture
  • PEM server
  • PEM agent
  • PEM web client
  • SQL Profiler plugin
• Deployment considerations
  • Web server installation options
    • PEM server and Apache web server on separate hosts
    • PEM server and Apache web server on the same host
      • Using Failover Manager for high availability
        • Initial product installation and configuration
        • Set up the primary node for streaming replication
        • Set up the standby nodes for streaming replication
        • Set up EFM to manage failover on all hosts
        • Current limitations
      • Connection pooling using pgBouncer
        • PEM server and agent connection management mechanism
        • Preparing the PEM database server
        • Configuring PgBouncer
        • Configuring the PEM agent
      • Authentication options
        • Configuring the PEM server to use Kerberos authentication
        • Configuring the PEM server to use Windows Active Directory Domain Services for Kerberos authentication (SSPI)
        • Configuring the PEM server to use two-factor authentication
      • Securing your deployment
        • Apache HTTPD security configurations
        • PEM application security configurations
      • Web server installation options
        • PEM server and Apache web server on separate hosts