Documentation
Official documentation
- Pgpool-II
- Pgpool-II manual (English)
- Pgpool-II manual (Japanese)
- Tutorials of Pgpool-II
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