Connection Manager

PGD 6.0 introduces a new Connection Manager which replaces the PGD 5’s proxy solution with a tightly integrated approach using a background worker to expose read-write, read-only and http-status network interfaces in PGD.

• Overview of durability options covers the features and benefits of Connection Manager.

• Connection Manager Authentication covers how authentication works with Connection Manager.

• Connection pooling covers the built-in connection pooling modes and how to configure them.

• Load Balancing with Connection Manager covers how to use load balancing with Connection Manager.

• Configuring Connection Manager details the configuration options available and how to set them.

• Monitoring the Connection Manager covers the tables and HTTP endpoints available for monitoring.

• Connection Manager overview
  • About Connection Manager
  • Using Connection Manager
  • Authentication
  • Connection pooling
  • Load balancing
  • Configuration
  • Monitoring
• Connection Manager Authentication
  • Connection Manager connection types
  • Connection Manager authentication methods
  • Connection Manager authentication options
  • Unsupported pg_hba.conf rules
  • LDAP authentication notes and constraints
• Connection pooling
  • Configuring the pool mode
  • Configuring the reset mode
  • Managing session parameters
  • Using prepared statements
  • Reusing connections
  • Unsupported features
• Load Balancing with Connection Manager
  • Connection Manager routing
    • HAProxy example: Connection Manager routing
  • Direct routing
    • HAProxy example: Direct routing
• Configuring Connection Manager
  • Configuring Connection Manager
• Monitoring the Connection Manager
  • Available SQL tables and views
  • Available HTTP/HTTPS endpoints
  • Logging