Server Configuration
- Table of Contents
- 5.1. Setting Parameters
- 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.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.