Server Configuration

Table of Contents
5.1. Setting Parameters
5.1.1. Parameter Names and Values
5.1.2. Parameter Interaction via the Configuration File
5.1.3. Parameter Interaction via SQL Clients
5.2. Connections and Authentication
5.2.1. Connection Settings
5.2.2. Authentication Settings
5.3. Running mode
5.3.1. Master slave mode
5.3.2. Replication mode
5.4. Backend Settings
5.4.1. Backend Connection Settings
5.4.2. Backend Data Settings
5.5. Connection Pooling
5.6. Error Reporting and Logging
5.6.1. Where To Log
5.6.2. When To Log
5.6.3. What To Log
5.7. Load Balancing
5.7.1. Condition for Load Balancing
5.7.2. Writing queries may affect Load Balancing
5.7.3. Load Balancing in Streaming Replication
5.7.4. Load Balancing Settings
5.8. Health Check
5.9. Failover and Failback
5.9.1. Failover and Failback Settings
5.9.2. Failover in the raw Mode
5.10. Online Recovery
5.11. Streaming Replication Check
5.12. In Memory Query Cache
5.12.1. Enabling in memory query cache
5.12.2. Choosing cache storage
5.12.3. Common configurations
5.12.4. Configurations to use shared memory
5.12.5. Configurations to use memcached
5.13. Secure Socket Layer (SSL)
5.13.1. SSL Settings
5.13.2. Generating SSL certificates
5.14. Watchdog
5.14.1. Enable watchdog
5.14.2. Watchdog communication
5.14.3. Upstream server connection
5.14.4. Virtual IP control
5.14.5. Behaviour on escalation and de-escalation
5.14.6. Controlling the Failover behavior
5.14.7. Life checking Pgpool-II
5.14.8. Lifecheck Heartbeat mode configuration
5.14.9. Lifecheck Query mode configuration
5.14.10. Watchdog servers configurations
5.15. Misc Configuration Parameters

There are many configuration parameters that affect the behavior of Pgpool-II . In the first section of this chapter we describe how to interact with configuration parameters. The subsequent sections discuss each parameter in detail.