Difference between revisions of "Documentation"
(→Blog posts by pgpool developers) |
(→Official documentation) |
||
| (55 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
* '''Pgpool-II''' | * '''Pgpool-II''' | ||
** Pgpool-II manual (English) | ** Pgpool-II manual (English) | ||
| − | *** [ | + | *** [https://www.pgpool.net/docs/latest/en/html/ Pgpool-II 4.5] (latest) |
| − | *** [ | + | *** [https://www.pgpool.net/docs/44/en/html/ Pgpool-II 4.4] |
| − | *** [ | + | *** [https://www.pgpool.net/docs/43/en/html/ Pgpool-II 4.3] |
| − | *** [ | + | *** [https://www.pgpool.net/docs/42/en/html/ Pgpool-II 4.2] |
| + | *** [https://www.pgpool.net/docs/41/en/html/ Pgpool-II 4.1] | ||
** Pgpool-II manual (Japanese) | ** Pgpool-II manual (Japanese) | ||
| − | *** [ | + | *** [https://www.pgpool.net/docs/latest/ja/html/ Pgpool-II 4.5] (latest) |
| − | *** [ | + | *** [https://www.pgpool.net/docs/44/ja/html/ Pgpool-II 4.4] |
| − | *** [ | + | *** [https://www.pgpool.net/docs/43/ja/html/ Pgpool-II 4.3] |
| − | *** [ | + | *** [https://www.pgpool.net/docs/42/ja/html/ Pgpool-II 4.2] |
| + | *** [https://www.pgpool.net/docs/41/ja/html/ Pgpool-II 4.1] | ||
| − | <!-- ** [ | + | <!-- ** [https://www.pgpool.net/docs/latest/pgpool-zh_cn.html pgpool-II manual] (Simplified Chinese)--> |
| − | <!-- ** [ | + | <!-- ** [https://www.pgpool.net/docs/latest/tutorial-en.html pgpool-II tutorial] (English)--> |
| − | <!-- ** [ | + | <!-- ** [https://www.pgpool.net/docs/latest/tutorial-ja.html pgpool-II tutorial] (Japanese)--> |
| − | <!-- ** [ | + | <!-- ** [https://www.pgpool.net/docs/latest/tutorial-zh_cn.html pgpool-II tutorial] (Simplified Chinese)--> |
* '''pgpoolAdmin''' | * '''pgpoolAdmin''' | ||
| − | ** [ | + | ** [https://www.pgpool.net/docs/pgpoolAdmin/index_en.html pgpoolAdmin manual] (English) |
| − | ** [ | + | ** [https://www.pgpool.net/docs/pgpoolAdmin/index_ja.html pgpoolAdmin manual] (Japanese) |
| − | * '''Tutorials of | + | * '''Tutorials of Pgpool-II''' |
** Basic Configuration Example | ** Basic Configuration Example | ||
| − | *** [ | + | *** [https://www.pgpool.net/docs/latest/en/html/example-basic.html English] [https://www.pgpool.net/docs/latest/ja/html/example-basic.html Japanese] |
** Watchdog: | ** Watchdog: | ||
| − | + | *** master-slave mode: [https://www.pgpool.net/docs/latest/en/html/example-cluster.html English] [https://www.pgpool.net/docs/latest/ja/html/example-cluster.html Japanese] | |
| − | *** master-slave mode: [ | ||
** AWS Configuration Example | ** AWS Configuration Example | ||
| − | *** [ | + | *** [https://www.pgpool.net/docs/latest/en/html/example-aws.html English] [https://www.pgpool.net/docs/latest/ja/html/example-aws.html Japanese] |
| − | ** | + | ** Aurora Configuration Example |
| + | *** [https://www.pgpool.net/docs/latest/en/html/example-aurora.html English] [https://www.pgpool.net/docs/latest/ja/html/example-aurora.html Japanese] | ||
| + | ** Kubernetes Configuration Example | ||
*** [https://github.com/pgpool/pgpool2_on_k8s/blob/master/docs/index.md English] | *** [https://github.com/pgpool/pgpool2_on_k8s/blob/master/docs/index.md English] | ||
** Pgpool-II Exporter''' | ** Pgpool-II Exporter''' | ||
| Line 37: | Line 40: | ||
== Developer's documentation == | == Developer's documentation == | ||
| − | * [https://www.pgcon.org/events/pgcon_2020/sessions/session/45/slides/44/HA_Cluster_on_K8s.pdf PostgreSQL HA Clusterwith Query Load | + | * [https://www.pgcon.org/events/pgcon_2020/sessions/session/45/slides/44/HA_Cluster_on_K8s.pdf PostgreSQL HA Clusterwith Query Load Balancing on Kubernetes] at [https://www.pgcon.org/2020/ PGCon 2020 Ottawa] (English, PDF) (2020/05/27) |
* [https://www.sraoss.co.jp/event_seminar/2019/dbtech2019-sraoss-postgresql-cluster.pdf PostgreSQLによるクラスタ運用および負荷分散術] at [https://www.db-tech-showcase.com/dbts/tokyo db tech showcase Tokyo 2019] (Japanese, PDF) (2019/9/25) | * [https://www.sraoss.co.jp/event_seminar/2019/dbtech2019-sraoss-postgresql-cluster.pdf PostgreSQLによるクラスタ運用および負荷分散術] at [https://www.db-tech-showcase.com/dbts/tokyo db tech showcase Tokyo 2019] (Japanese, PDF) (2019/9/25) | ||
* [https://www.sraoss.co.jp/event_seminar/2019/PGConf.ASIA.Bali.2019-PENG.pdf Setup a High-Availability and Load Balancing PostgreSQL Cluster - New Features of Pgpool-II 4.1 -] at [https://2019.pgconf.asia/ PGConf.ASIA 2019 Bali] (English, PDF) (2019/09/10) | * [https://www.sraoss.co.jp/event_seminar/2019/PGConf.ASIA.Bali.2019-PENG.pdf Setup a High-Availability and Load Balancing PostgreSQL Cluster - New Features of Pgpool-II 4.1 -] at [https://2019.pgconf.asia/ PGConf.ASIA 2019 Bali] (English, PDF) (2019/09/10) | ||
| Line 47: | Line 50: | ||
* [https://www.sraoss.co.jp/event_seminar/2018/pgpool-past-now-and-future-20180925.pdf 誕生から 15 年を迎えた Pgpool-II の過去と現在、そして未来] at [https://www.sraoss.co.jp/event_seminar/2018/0925.php Pgpool-II Day - Pgpool-II 4.0 Anniversary -] (Japanese, PDF) (2018/9/25) | * [https://www.sraoss.co.jp/event_seminar/2018/pgpool-past-now-and-future-20180925.pdf 誕生から 15 年を迎えた Pgpool-II の過去と現在、そして未来] at [https://www.sraoss.co.jp/event_seminar/2018/0925.php Pgpool-II Day - Pgpool-II 4.0 Anniversary -] (Japanese, PDF) (2018/9/25) | ||
* [https://www.sraoss.co.jp/event_seminar/2017/Pgpool-II-3.7.pdf 信頼性を向上させ、PostgreSQL 10 に対応した Pgpool-II 3.7 のご紹介] at [https://www.pgconf.asia/JA/2017/day-2/#B5 PGConf.ASIA 2017] (2017/12/06) | * [https://www.sraoss.co.jp/event_seminar/2017/Pgpool-II-3.7.pdf 信頼性を向上させ、PostgreSQL 10 に対応した Pgpool-II 3.7 のご紹介] at [https://www.pgconf.asia/JA/2017/day-2/#B5 PGConf.ASIA 2017] (2017/12/06) | ||
| − | * [ | + | * [https://www.pgpool.net/download.php?f=Pgpool-II-history.pdf Pgpool-II: Past, Present and Future] at [https://www.pgconf.asia/EN/2016/day-2/#B3 PGConf.ASIA 2016] (Japanese, PDF) (2016/12/07) |
| − | * [ | + | * [https://pgpool.net/mediawiki/images/2016-02-Moscow-pgpool-II-3.5.pdf "How to manage a herd of elephants: PostgreSQL clusters using streaming replication and pgpool-II"] at [https://pgconf.ru/en/2016/89695 "PGConf.Russia 2016"] (English, PDF) (2016/02/03) |
| − | * [ | + | * [https://www.sraoss.co.jp/event_seminar/2015/pgpool-II-3.5.pdf "How to manage a herd of elephants: Introducing new features of pgpool-II 3.5"] at [https://www.eventdove.com/event/106042 "PostgreSQL Conference China 2015"] (English, PDF) (2015/11/21) |
| − | * [ | + | * [https://pgpool.net/mediawiki/index.php?title=pgpool-II_3.5_features&redirect=no pgpool-II 3.5 new features] (English, Wiki) |
| − | * [ | + | * [https://www.pgpool.net/pgpool-web/contrib_docs/pgpool-II-3.5.pdf 6th Postgres Cluster Hackers Summit, pgCon 2015 "pgpool-II 3.5 How it will look like?"] (English, PDF) |
| − | * [ | + | * [https://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2015.pdf 6th Postgres Cluster Hackers Summit, pgCon 2015 "pgpool-II Development Status Updates"] (English, PDF) |
| − | * [ | + | * [https://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2014.pdf 5th Postgres Cluster Hackers Summit, pgCon 2014 "pgpool-II Development Status Updates"] (English, PDF) |
| − | * [ | + | * [https://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2013.pdf 4th Postgres Cluster Hackers Summit, pgCon 2013 "pgpool-II Development Status Updates"] (English, PDF) |
| − | * [ | + | * [https://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2012.pdf 3rd Postgres Cluster Hackers Summit, pgCon 2012 "pgpool-II Development Status Updates"] (English, PDF) |
| − | == Blog posts by | + | == Blog posts by Pgpool-II developers == |
| + | * [https://pgsqlpgpool.blogspot.com/2022/11/dynamic-spare-process-management-in.html Dynamic spare process management in Pgpool-II] By Tatsuo Ishii (2022/11/16) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2022/09/grafana-pgpool2-exporter.html Grafana Dashboard for Pgpool-II Exporter] By Bo Peng (2022/09-26) | ||
| + | |||
| + | * [https://pgsqlpgpool.blogspot.com/2022/09/query-cache-improvement-in-pgpool-ii-44.html Query cache improvement in Pgpool-II 4.4] By Tatsuo Ishii (2022/9/26) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2022/09/configuring-vip-route-table.html How to make Pgpool-II Leader Switchover Seamless on AWS - Updating Route Table] By Bo Peng (2022/9/19) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2022/09/configuring-vip-in-cloud.html Configuring and Managing VIP for Pgpool-II on AWS] By Bo Peng (2022/9/10) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2022/03/pgo-v5-installation.html Installing Crunchy Postgres Operator v5 on EKS] By Bo Peng (2022/3/29) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2022/03/pgpool-debian.html Installing Pgpool-II on Debian/Ubuntu] By Bo Peng (2022/3/19) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2022/02/auto-failback.html Pgpool-II Configuration Parameters - auto_failback] By Bo Peng (2022/2/28) | ||
| + | |||
| + | * [https://pgsqlpgpool.blogspot.com/2022/02/whats-new-in-pgpool-ii-43-part3.html What's new in Pgpool-II 4.3? (part3)] By Tatsuo Ishii (2022/2/11) | ||
| + | |||
| + | * [https://pgsqlpgpool.blogspot.com/2022/02/whats-new-in-pgpool-ii-43-part2.html What's new in Pgpool-II 4.3? (part2)] By Tatsuo Ishii (2022/2/6) | ||
| + | |||
| + | * [https://pgsqlpgpool.blogspot.com/2022/01/whats-new-in-pgpool-ii-43.html What's new in Pgpool-II 4.3?] By Tatsuo Ishii (2022/1/31) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2021/09/enable-shared-relcache.html Pgpool-II Configuration Parameters - enable_shared_relcache] By Bo Peng (2021/9/22) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2021/09/reserved-connections.html Pgpool-II Configuration Parameters - reserved_connections] By Bo Peng (2021/9/21) | ||
| + | |||
| + | * [https://pgsqlpgpool.blogspot.com/2021/08/failover-triggered-by-postgresql.html Failover triggered by PostgreSQL shutdown] By Tatsuo Ishii (2021/8/24) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2021/07/deploying-pgpool2-exporter-with-docker.html Deploying Pgpool-II Exporter with Docker] By Bo Peng (2021/7/26) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2021/07/postgres-disaster-recovery-on-k8s-zalando.html Disaster Recovery Strategies for PostgreSQL Deployments on Kubernetes (Part 2)] By Bo Peng (2021/7/04) | ||
| + | |||
| + | * [https://pgsqlpgpool.blogspot.com/2021/06/promoting-specied-node-in-pgpool-ii.html Promoting specied node in Pgpool-II] By Tatsuo Ishii (2021/6/18) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2021/05/postgres-disaster-recovery-on-k8s.html Disaster Recovery Strategies for PostgreSQL Deployments on Kubernetes (Part 1)] By Bo Peng (2021/5/31) | ||
| + | |||
| + | * [https://b-peng.blogspot.com/2021/04/pgpool-logging-debugging.html Pgpool-II Logging and Debugging] By Bo Peng (2021/4/30) | ||
| + | * [https://pgsqlpgpool.blogspot.com/2021/04/visibility-with-query-cache.html Visibility with query cache] By Tatsuo Ishii (2021/4/19) | ||
| + | * [https://b-peng.blogspot.com/2021/03/logging-pgpool-on-k8s.html Logging of Pgpool-II on Kubernetes] By Bo Peng (2021/3/30) | ||
| + | * [https://b-peng.blogspot.com/2021/02/clustering-modes-in-pgpool.html Pgpool-II's Clustering Modes] By Bo Peng (2021/2/28) | ||
| + | * [https://pgsqlpgpool.blogspot.com/2021/02/what-pool-means-in-pgpool-ii.html What "pool" means in Pgpool-II?] By Tatsuo Ishii (2021/2/6) | ||
| + | * [https://b-peng.blogspot.com/2021/01/statistics-in-pgpool.html Various Ways to Retrieve Pgpool-II's Statistics] By Bo Peng (2021/1/31) | ||
| + | * [https://b-peng.blogspot.com/2020/12/load-balancing-in-pgpool.html Query Load Balancing in Pgpool-II] By Bo Peng (2020/12/29) | ||
| + | * [https://pgsqlpgpool.blogspot.com/2020/12/timeouts-in-pgpool-ii-connections.html Timeouts in Pgpool-II connections] By Tatsuo Ishii (2020/12/27) | ||
| + | * [https://b-peng.blogspot.com/2020/11/pgpool2-on-k8s.html Deploy Pgpool-II on Kubernetes to Achieve Query Load Balancing and Monitoring] By Bo Peng (2020/11/30) | ||
| + | * [https://b-peng.blogspot.com/2020/10/pgpool2-exporter.html Monitoring PostgreSQL Cluster via Pgpool-II with Prometheus] By Bo Peng (2020/10/31) | ||
| + | * [https://www.highgo.ca/2020/10/08/configuring-pgpool-ii-watchdog-its-going-to-be-a-lot-easier/ Configuring Pgpool-II watchdog: It’s going to be a lot easier] By Muhammad Usama (2020/10/08) | ||
| + | * [https://www.highgo.ca/2020/09/30/pgpool-ii-4-2-features/ pgpool II 4.2 features] By Ahsan Hadi (2020/09/30) | ||
| + | * [https://pgsqlpgpool.blogspot.com/2020/09/fixing-language-in-pgpool-ii-42.html Fixing language in Pgpool-II 4.2] By Tatsuo Ishii (2020/09/30) | ||
* [https://b-peng.blogspot.com/2020/09/how-to-configure-scram-and-md5.html How to Configure SCRAM and MD5 Authentication in Pgpool-II] By Bo Peng (2020/09/28) | * [https://b-peng.blogspot.com/2020/09/how-to-configure-scram-and-md5.html How to Configure SCRAM and MD5 Authentication in Pgpool-II] By Bo Peng (2020/09/28) | ||
* [https://pgsqlpgpool.blogspot.com/2020/08/new-statistics-data-in-pgpool-ii.html New statistics data in Pgpool-II] By Tatsuo Ishii (2020/08/30) | * [https://pgsqlpgpool.blogspot.com/2020/08/new-statistics-data-in-pgpool-ii.html New statistics data in Pgpool-II] By Tatsuo Ishii (2020/08/30) | ||
| Line 66: | Line 118: | ||
* [https://www.highgo.ca/2020/06/25/authenticating-pgpool-ii-with-ldap/ Authenticating pgpool II with LDAP] By Ahsan Hadi (2020/06/25) | * [https://www.highgo.ca/2020/06/25/authenticating-pgpool-ii-with-ldap/ Authenticating pgpool II with LDAP] By Ahsan Hadi (2020/06/25) | ||
* [https://www.highgo.ca/2020/02/25/setting-up-ssl-certificate-authentication-with-pgpool-ii/ Setting up SSL certificate authentication with Pgpool-II] By Muhammad Usama (2020/02/25) | * [https://www.highgo.ca/2020/02/25/setting-up-ssl-certificate-authentication-with-pgpool-ii/ Setting up SSL certificate authentication with Pgpool-II] By Muhammad Usama (2020/02/25) | ||
| − | * [ | + | * [https://pgsqlpgpool.blogspot.com/2019/07/when-primary-server-is-far-away-from.html When primary server is far away from standby server] By Tatsuo Ishii (2019/07/24) |
* [https://www.highgo.ca/2019/07/19/pgpool-ii-4-1-taking-the-bull-by-its-horn/ Pgpool II 4.1 taking the bull by its horn] By Ahsan Hadi (2019/07/19) | * [https://www.highgo.ca/2019/07/19/pgpool-ii-4-1-taking-the-bull-by-its-horn/ Pgpool II 4.1 taking the bull by its horn] By Ahsan Hadi (2019/07/19) | ||
| − | * [ | + | * [https://pgsqlpgpool.blogspot.com/2019/04/statement-level-load-balancing.html Statement level load balancing] By Tatsuo Ishii (2019/04/01) |
| − | * [ | + | * [https://pgsqlpgpool.blogspot.com/2019/03/shared-relation-cache.html Shared Relation Cache] By Tatsuo Ishii (2019/03/24) |
| − | * [ | + | * [https://www.highgo.ca/2019/09/06/can-you-gain-performance-with-pgpool-ii-as-a-load-balancer/ Can you gain performance with Pgpool-II as a load balancer?] By Muhammad Usama (2019/04/02) |
* '''old blog posts''' | * '''old blog posts''' | ||
| − | ** [ | + | ** [https://pgsqlpgpool.blogspot.jp/2013/06/settinng-up-everything-at-one-time.html Setting up everything at one time] |
| − | ** [ | + | ** [https://pgsqlpgpool.blogspot.jp/2013/06/pgpool-ii-33-alpha-1-is-out.html pgpool-II 3.3 alpha1 is out!] |
| − | ** [ | + | ** [https://pgsqlpgpool.blogspot.jp/2012/10/pgpool-ii-now.html pgpool-II + now()] |
| − | ** [ | + | ** [https://pgsqlpgpool.blogspot.jp/2012/08/pgpool-ii-talk-at-postgresql-conference.html Pgpool-II talk at PostgreSQL Conference Europe 2012] |
| Line 81: | Line 133: | ||
== User contributed documentation == | == User contributed documentation == | ||
* '''Documentation'''] | * '''Documentation'''] | ||
| − | ** [ | + | ** [https://www.pgpool.net/pgpool-web/contrib_docs/pgpool-II_for_beginners.pdf Gerd Koenig's "pgpool-II for beginners"] (English) |
| − | ** [ | + | ** [https://lets.postgresql.jp/documents/technical/pgpool/1 What is pgpool-II] (Japanese) |
| − | ** [ | + | ** [https://lets.postgresql.jp/documents/technical/pgpool/2 Creating a replication system using pgpool-II] (Japanese) |
| − | ** [ | + | ** [https://www.sraoss.co.jp/event_seminar/2010/20100702-03char10.pdf Making master/slave systems work better with pgpool-II] (English, PDF) |
** [[Relationship_between_max_pool,_num_init_children,_and_max_connections|Relationship between max_pool, num_init_children, and max_connections]](English, 2012/8/25) | ** [[Relationship_between_max_pool,_num_init_children,_and_max_connections|Relationship between max_pool, num_init_children, and max_connections]](English, 2012/8/25) | ||
| − | ** [ | + | ** [https://www.sraoss.co.jp/event_seminar/2013/20130212_pgpool_seminar_sraoss.pdf New features of pgpool-II, multifunctional middleware for PostgreSQL] (Japanese, PDF) |
| − | ** [ | + | ** [https://www.sraoss.co.jp/event_seminar/2013/20131115_dbshowtech.pdf Construct scale out configuration with PostgreSQL] (Japanese, PDF) |
| − | ** [ | + | ** [https://lets.postgresql.jp/documents/technical/pgpool-II-pgpool_setup/1 Let's try pgpool-II easy setup function] (Japanese) |
| − | ** [ | + | ** [https://lets.postgresql.jp/documents/technical/pgpool-II-3.3-watchdog/1 About pgpool-II 3.3 watchdog] (Japanese) |
| − | ** [ | + | ** [https://lets.postgresql.jp/documents/technical/pgpool-II-tcp-tuning/1 Improvements of connection performance in pgpool-II] (Japanese) |
| − | ** [ | + | ** [https://www.postgresql.jp/events/jpug-pgcon2013-files/C1_jpugpgcon2013_slide Construct high-availability, high-performance system with pgpool-II] (Japanese, PDF) |
* '''Tutorials of pgpool-II 3.6''' | * '''Tutorials of pgpool-II 3.6''' | ||
** Basic Configuration Example | ** Basic Configuration Example | ||
| − | *** [ | + | *** [https://www.pgpool.net/docs/latest/en/html/example-basic.html English] [https://www.pgpool.net/docs/latest/ja/html/example-basic.html Japanese] |
** Watchdog: | ** Watchdog: | ||
| − | *** Basic: [ | + | *** Basic: [https://www.pgpool.net/docs/latest/en/html/example-watchdog.html English] [https://www.pgpool.net/docs/latest/ja/html/example-watchdog.html Japanese] |
| − | *** master-slave mode: [ | + | *** master-slave mode: [https://www.pgpool.net/docs/latest/en/html/example-cluster.html English] [https://www.pgpool.net/docs/latest/ja/html/example-cluster.html Japanese] |
** AWS Configuration Example | ** AWS Configuration Example | ||
| − | *** [ | + | *** [https://www.pgpool.net/docs/latest/en/html/example-aws.html English] [https://www.pgpool.net/docs/latest/ja/html/example-aws.html Japanese] |
* '''Tutorials of Streaming Replication with pgpool-II (Obsolete)''' | * '''Tutorials of Streaming Replication with pgpool-II (Obsolete)''' | ||
** Simple Streaming replication setting with pgpool-II | ** Simple Streaming replication setting with pgpool-II | ||
| − | *** For pgpool-II 3.1 and PostgreSQL 9.1: [ | + | *** For pgpool-II 3.1 and PostgreSQL 9.1: [https://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/index.html English (2012/01/31) ] [https://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/index-ja.html Japanese (2012/6/1) ] |
| − | *** For pgpool-II 3.0 and PostgreSQL 9.0: [ | + | *** For pgpool-II 3.0 and PostgreSQL 9.0: [https://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting_3.0/index.html English] [https://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting_3.0/index-ja.html Japanese] |
** multiple server version | ** multiple server version | ||
| − | *** For pgpool-II 3.3 and PostgreSQL 9.3: [ | + | *** For pgpool-II 3.3 and PostgreSQL 9.3: [https://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/index.html English (2014/04/07)] [https://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/index-ja.html Japanese (2014/04/07)] |
| − | *** For pgpool-II 3.1 and PostgreSQL 9.1: [ | + | *** For pgpool-II 3.1 and PostgreSQL 9.1: [https://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/index.html English (2012/01/31)] [https://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.0/index-ja.html Japanese (2012/6/1)] |
| − | *** For pgpool-II 3.0 and PostgreSQL 9.0: [ | + | *** For pgpool-II 3.0 and PostgreSQL 9.0: [https://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/index.html English] [https://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.0/index-ja.html Japanese] |
* '''Tutorials of pgpool-II 3.3 (Obsolete)''' | * '''Tutorials of pgpool-II 3.3 (Obsolete)''' | ||
** Watchdog: | ** Watchdog: | ||
| − | *** master-slave mode: [ | + | *** master-slave mode: [https://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html English (2014/04/07)] [https://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/ja.html Japanese (2014/04/07)] |
* '''Tutorials of pgpool-II 3.2 (Obsolete)''' | * '''Tutorials of pgpool-II 3.2 (Obsolete)''' | ||
| − | ** On memory query cache: [ | + | ** On memory query cache: [https://www.pgpool.net/pgpool-web/contrib_docs/memqcache/en.html English (2012/07/20)] [https://www.pgpool.net/pgpool-web/contrib_docs/memqcache/ja.html Japanese (2012/07/20)] |
** Watchdog: | ** Watchdog: | ||
| − | *** Basic: [ | + | *** Basic: [https://www.pgpool.net/pgpool-web/contrib_docs/watchdog/en.html English (2012/07/20)] [https://www.pgpool.net/pgpool-web/contrib_docs/watchdog/ja.html Japanese (2012/07/20)] |
| − | *** master-slave mode: [ | + | *** master-slave mode: [https://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/en.html English (2012/10/22)] [https://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/ja.html Japanese (2012/10/15)] |
--> | --> | ||
Latest revision as of 04:13, 29 February 2024
Official documentation
- Pgpool-II
- Pgpool-II manual (English)
- Pgpool-II manual (Japanese)
- pgpoolAdmin
- pgpoolAdmin manual (English)
- pgpoolAdmin 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
