PGD Proxy

Managing application connections is an important part of high availability. PGD Proxy offers a way to manage connections to the EDB Postgres Distributed cluster. It acts as a proxy layer between the client application and the Postgres database.

• PGD Proxy overview provides an overview of the PGD Proxy, its processes, and how it interacts with the EDB Postgres Distributed cluster.

• Installing the PGD Proxy service covers installation of the PGD Proxy service on a host.

• Configuring PGD Proxy details the three levels (group, node, and proxy) of configuration on a cluster that control how the PGD Proxy service behaves.

• Administering PGD Proxy shows how to switch the write leader and manage the PGD Proxy.

• Monitoring PGD Proxy looks at how to monitor PGD Proxy through the cluster and at a service level.

• Read-only routing with PGD Proxy explains how the read-only routing feature in PGD Proxy enables read scalability.

• Monitoring Raft consensus provides an overview of the Raft consensus mechanism used to coordinate PGD Proxy.

• EDB Postgres Distributed Proxy overview
  • Leader selection
  • PGD Proxy cluster configuration
  • PGD Proxy service
  • How they work together
    • Consensus grace period
    • Network partition example
    • Read consensus grace period
    • Multi-host connection strings
• Installing PGD Proxy
  • Installing PGD Proxy
    • Installing through TPA
    • Configuration
    • PGD Proxy user
    • PGD Proxy service
    • Installing manually
• PGD Proxy configuration
  • Group-level configuration
  • Node-level configuration
  • Proxy-level configuration
    • Creating and dropping proxy configurations
    • Altering proxy configurations
• Administering PGD Proxy
  • Switching the write leader
    • Using SQL
    • Using PGD CLI
• Monitoring PGD Proxy
  • Monitoring through the cluster
    • Using SQL
  • Monitoring at the process level
    • Proxy health check
    • Readiness
    • Liveness
  • Proxy log location
    • syslog
• Read-only routing with PGD Proxy
  • Background
  • Read-only routing in PGD Proxy
    • Valid read-only nodes
  • Creating a proxy configuration
    • Creating a Read-Only Proxy
    • Using SQL
    • Using PGD CLI
  • Configuring running proxies
    • Configuring using SQL
    • Configuring using PGD CLI
• Proxies, Raft, and Raft subgroups
  • Proxy routing
  • Global routing
  • Local routing
  • More information
    • Creating Raft subgroups using TPA
    • Working with Raft subgroups and PGD CLI
    • Migrating to Raft subgroups
    • Raft elections in depth