pgpool-II 4.2.20 Documentation
Prev
Home
Next
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.
Architecure of the watchdog
5.
Server Configuration
5.1.
Setting Parameters
5.2.
Connections and Authentication
5.3.
Clustering 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
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
Prev
Home
Next
Architectural Fundamentals
Installation of
Pgpool-II