Planning your deployment

• Understanding Postgres Enterprise Manager components and architecture
  • PEM architecture
    • PEM server
    • PEM agent
    • PEM web application
    • SQL Profiler extension
• Deployment considerations
  • 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
    • Web server security configuration
    • PEM application security configurations
  • Web server installation options
    • PEM server and web server on separate hosts
    • PEM server and web server on the same host
  • High Availability Patterns for PEM Deployment
    • Running multiple instances of the PEM backend database
    • Running multiple PEM web application instances
    • Upgrading an HA PEM deployment
    • Load balancers, proxies and VIPs
    • Reference Architectures