II. Server Administration

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

Table of Contents
2. Installation of Pgpool-II
2.1. Planning
2.2. Installation of Pgpool-II
2.3. Requirements
2.4. Getting The Source
2.5. Installing Pgpool-II
2.6. Installing pgpool_recovery
2.7. Installing pgpool-regclass
2.8. Creating insert_lock table
2.9. Compiling and installing documents
2.10. Installation from RPM
2.11. Tips for Installation
3. Server Setup and Operation
3.1. The Pgpool-II User Account
3.2. Configuring pcp.conf
3.3. Configuring Pgpool-II
3.4. Configuring backend information
3.5. Starting Pgpool-II and PostgreSQL
3.6. Stopping Pgpool-II and PostgreSQL
3.7. Temporarily Shutting Down PostgreSQL
3.8. Backing up PostgreSQL database
4. Watchdog
4.1. Introduction
4.2. Integrating external lifecheck with watchdog
4.3. Restrictions on watchdog
4.4. Architecture of the watchdog
5. Server Configuration
5.1. Setting Parameters
5.2. Connections and Authentication
5.3. Process Management
5.4. Clustering mode
5.5. Backend Settings
5.6. Connection Pooling
5.7. Error Reporting and Logging
5.8. Load Balancing
5.9. Health Check
5.10. Failover and Failback
5.11. Online Recovery
5.12. Streaming Replication Check
5.13. In Memory Query Cache
5.14. Secure Socket Layer (SSL)
5.15. Watchdog
5.16. 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
7. Performance Considerations
7.1. Resource Requirement
7.2. Managing Client Connections
7.3. Read Query Load Balancing
7.4. In Memory Query Caching
7.5. Relation Cache
7.6. Other Performance Considerations