Chapter 5. 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.8. Health Check
5.9. Failover and Failback
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 Sockect Layer (SSL)
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. Behaivor on escalation and de-escalation
5.14.6. Life checking Pgpool-II
5.14.7. Lifecheck Heartbeat mode configuration
5.14.8. Lifecheck Query mode configuration
5.14.9. 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.