pgpool-II 4.0.25 Documentation
PrevHomeNext

II. Server Administration

This part covers topics that are of interest to Pgpool-II administrators.

Table of Contents
3. Installation of Pgpool-II
3.1. Installation of Pgpool-II
3.2. Requirements
3.3. Getting The Source
3.4. Installing Pgpool-II
3.5. Installing pgpool_recovery
3.6. Installing pgpool-regclass
3.7. Creating insert_lock table
3.8. Setting up pgpool.conf
3.9. Compiling and installing documents
3.10. Installation from RPM
3.11. Tips for Installation
4. Server Setup and Operation
4.1. The Pgpool-II User Account
4.2. Configuring pcp.conf
4.3. Configuring Pgpool-II
4.4. Configuring backend information
5. Server Configuration
5.1. Setting Parameters
5.2. Connections and Authentication
5.3. Running mode
5.4. Backend Settings
5.5. Connection Pooling
5.6. Error Reporting and Logging
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.13. Secure Socket Layer (SSL)
5.14. Watchdog
5.15. Misc Configuration Parameters
6. Client Authentication
6.1. The pool_hba.conf File
6.2. Authentication Methods
6.3. Using different methods for frontend and backend authentication
6.4. Using AES256 encrypted passwords in pool_passwd
PrevHomeNext
Architecure of the watchdog Installation of Pgpool-II