Documentation

Official documentation

• Pgpool-II
  • Pgpool-II manual (English)
    • Pgpool-II 4.7
    • Pgpool-II 4.6 (latest)
    • Pgpool-II 4.5
    • Pgpool-II 4.4
    • Pgpool-II 4.3
    • Pgpool-II 4.2
  • Pgpool-II manual (Japanese)
    • Pgpool-II 4.7
    • Pgpool-II 4.6 (latest)
    • Pgpool-II 4.5
    • Pgpool-II 4.4
    • Pgpool-II 4.3
    • Pgpool-II 4.2

• Tutorials of Pgpool-II
  • Basic Configuration Example
    • English Japanese
  • Watchdog:
    • master-slave mode: English Japanese
  • AWS Configuration Example
    • English Japanese
  • Aurora Configuration Example
    • English Japanese
  • Kubernetes Configuration Example
    • English
  • Pgpool-II Exporter
    • English

Developer's documentation

• PostgreSQL HA Clusterwith Query Load Balancing on Kubernetes at PGCon 2020 Ottawa (English, PDF) (2020/05/27)
• PostgreSQLによるクラスタ運用および負荷分散術 at db tech showcase Tokyo 2019 (Japanese, PDF) (2019/9/25)
• Setup a High-Availability and Load Balancing PostgreSQL Cluster - New Features of Pgpool-II 4.1 - at PGConf.ASIA 2019 Bali (English, PDF) (2019/09/10)
• Introducing PostgreSQL SQL Parser - Use of PostgreSQL Parser in other Applications - at PGCon 2019 Ottawa (English, PDF) (2019/05/31)
• Celebrating its 15th Anniversary: Pgpool-II Past, Present and Future - Part 2 at PGConf.ASIA 2018 (English, PDF) (2018/12/11)
• Celebrating its 15th Anniversary: Pgpool-II Past, Present and Future - Part 1 at PGConf.ASIA 2018 (English, PDF) (2018/12/11)
• PostgreSQL HA with Pgpool-II and whats been happening in Pgpool world lately... at Pgpool-II Day - Pgpool-II 4.0 Anniversary - (English, PDF) (2018/9/25)
• PostgreSQL クラスタ環境の管理機能を大幅に強化！Pgpool-II 4.0 のご紹介 at Pgpool-II Day - Pgpool-II 4.0 Anniversary - (Japanese, PDF) (2018/9/25)
• 誕生から 15 年を迎えた Pgpool-II の過去と現在、そして未来 at Pgpool-II Day - Pgpool-II 4.0 Anniversary - (Japanese, PDF) (2018/9/25)
• 信頼性を向上させ、PostgreSQL 10 に対応した Pgpool-II 3.7 のご紹介 at PGConf.ASIA 2017 (2017/12/06)
• Pgpool-II: Past, Present and Future at PGConf.ASIA 2016 (Japanese, PDF) (2016/12/07)
• "How to manage a herd of elephants: PostgreSQL clusters using streaming replication and pgpool-II" at "PGConf.Russia 2016" (English, PDF) (2016/02/03)
• "How to manage a herd of elephants: Introducing new features of pgpool-II 3.5" at "PostgreSQL Conference China 2015" (English, PDF) (2015/11/21)
• pgpool-II 3.5 new features (English, Wiki)
• 6th Postgres Cluster Hackers Summit, pgCon 2015 "pgpool-II 3.5 How it will look like?" (English, PDF)
• 6th Postgres Cluster Hackers Summit, pgCon 2015 "pgpool-II Development Status Updates" (English, PDF)
• 5th Postgres Cluster Hackers Summit, pgCon 2014 "pgpool-II Development Status Updates" (English, PDF)
• 4th Postgres Cluster Hackers Summit, pgCon 2013 "pgpool-II Development Status Updates" (English, PDF)
• 3rd Postgres Cluster Hackers Summit, pgCon 2012 "pgpool-II Development Status Updates" (English, PDF)

Blog posts by Pgpool-II developers

• Dynamic spare process management in Pgpool-II By Tatsuo Ishii (2022/11/16)

• Grafana Dashboard for Pgpool-II Exporter By Bo Peng (2022/09-26)

• Query cache improvement in Pgpool-II 4.4 By Tatsuo Ishii (2022/9/26)

• How to make Pgpool-II Leader Switchover Seamless on AWS - Updating Route Table By Bo Peng (2022/9/19)

• Configuring and Managing VIP for Pgpool-II on AWS By Bo Peng (2022/9/10)

• Installing Crunchy Postgres Operator v5 on EKS By Bo Peng (2022/3/29)

• Installing Pgpool-II on Debian/Ubuntu By Bo Peng (2022/3/19)

• Pgpool-II Configuration Parameters - auto_failback By Bo Peng (2022/2/28)

• What's new in Pgpool-II 4.3? (part3) By Tatsuo Ishii (2022/2/11)

• What's new in Pgpool-II 4.3? (part2) By Tatsuo Ishii (2022/2/6)

• What's new in Pgpool-II 4.3? By Tatsuo Ishii (2022/1/31)

• Pgpool-II Configuration Parameters - enable_shared_relcache By Bo Peng (2021/9/22)

• Pgpool-II Configuration Parameters - reserved_connections By Bo Peng (2021/9/21)

• Failover triggered by PostgreSQL shutdown By Tatsuo Ishii (2021/8/24)

• Deploying Pgpool-II Exporter with Docker By Bo Peng (2021/7/26)

• Disaster Recovery Strategies for PostgreSQL Deployments on Kubernetes (Part 2) By Bo Peng (2021/7/04)

• Promoting specied node in Pgpool-II By Tatsuo Ishii (2021/6/18)

• Disaster Recovery Strategies for PostgreSQL Deployments on Kubernetes (Part 1) By Bo Peng (2021/5/31)

• Pgpool-II Logging and Debugging By Bo Peng (2021/4/30)
• Visibility with query cache By Tatsuo Ishii (2021/4/19)
• Logging of Pgpool-II on Kubernetes By Bo Peng (2021/3/30)
• Pgpool-II's Clustering Modes By Bo Peng (2021/2/28)
• What "pool" means in Pgpool-II? By Tatsuo Ishii (2021/2/6)
• Various Ways to Retrieve Pgpool-II's Statistics By Bo Peng (2021/1/31)
• Query Load Balancing in Pgpool-II By Bo Peng (2020/12/29)
• Timeouts in Pgpool-II connections By Tatsuo Ishii (2020/12/27)
• Deploy Pgpool-II on Kubernetes to Achieve Query Load Balancing and Monitoring By Bo Peng (2020/11/30)
• Monitoring PostgreSQL Cluster via Pgpool-II with Prometheus By Bo Peng (2020/10/31)
• Configuring Pgpool-II watchdog: It’s going to be a lot easier By Muhammad Usama (2020/10/08)
• pgpool II 4.2 features By Ahsan Hadi (2020/09/30)
• Fixing language in Pgpool-II 4.2 By Tatsuo Ishii (2020/09/30)
• How to Configure SCRAM and MD5 Authentication in Pgpool-II By Bo Peng (2020/09/28)
• New statistics data in Pgpool-II By Tatsuo Ishii (2020/08/30)
• Authentication in Pgpool-II By Bo Peng (2020/08/27)
• Connection Pooling in Pgpool-II By Bo Peng (2020/07/31)
• Snapshot Isolation Mode By Tatsuo Ishii (2020/07/25)
• Authenticating pgpool II with LDAP By Ahsan Hadi (2020/06/25)
• Setting up SSL certificate authentication with Pgpool-II By Muhammad Usama (2020/02/25)
• When primary server is far away from standby server By Tatsuo Ishii (2019/07/24)
• Pgpool II 4.1 taking the bull by its horn By Ahsan Hadi (2019/07/19)
• Statement level load balancing By Tatsuo Ishii (2019/04/01)
• Shared Relation Cache By Tatsuo Ishii (2019/03/24)
• Can you gain performance with Pgpool-II as a load balancer? By Muhammad Usama (2019/04/02)
• old blog posts
  • Setting up everything at one time
  • pgpool-II 3.3 alpha1 is out!
  • pgpool-II + now()
  • Pgpool-II talk at PostgreSQL Conference Europe 2012