Difference between revisions of "Documentation"
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.2] (latest) |
− | *** [ | + | *** [https://www.pgpool.net/docs/41/en/html/ Pgpool-II 4.1] |
− | *** [ | + | *** [https://www.pgpool.net/docs/40/en/html/ Pgpool-II 4.0] |
− | *** [ | + | *** [https://www.pgpool.net/docs/37/en/html/ Pgpool-II 3.7] |
− | *** [ | + | *** [https://www.pgpool.net/docs/36/en/html/ Pgpool-II 3.6] |
** Pgpool-II manual (Japanese) | ** Pgpool-II manual (Japanese) | ||
− | *** [ | + | *** [https://www.pgpool.net/docs/latest/ja/html/ Pgpool-II 4.2] (latest) |
− | *** [ | + | *** [https://www.pgpool.net/docs/41/ja/html/ Pgpool-II 4.1] |
− | *** [ | + | *** [https://www.pgpool.net/docs/40/ja/html/ Pgpool-II 4.0] |
− | *** [ | + | *** [https://www.pgpool.net/docs/37/ja/html/ Pgpool-II 3.7] |
− | *** [ | + | *** [https://www.pgpool.net/docs/36/ja/html/ Pgpool-II 3.6] |
− | <!-- ** [ | + | <!-- ** [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 Pgpool-II''' | * '''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: | ||
− | *** 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] |
** Pgpool-II on Kubernetes''' | ** Pgpool-II on Kubernetes''' | ||
*** [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] | ||
Line 49: | Line 49: | ||
* [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 pgpool developers == | == Blog posts by pgpool developers == | ||
Line 72: | Line 72: | ||
* [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://realtechtalks.com/index.php/2019/04/02/pgpool-ii-load-balancing/ 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 87: | Line 87: | ||
== 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)] |
--> | --> |
Revision as of 00:55, 1 December 2020
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 Balancingon 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 developers
- 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