Difference between revisions of "Documentation"

From pgpool Wiki
Jump to: navigation, search
(Official documentation)
(Developer's documentation)
 
(44 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
== Official documentation ==
 
== Official documentation ==
* '''pgpool-II'''
+
* '''Pgpool-II'''
** [http://www.pgpool.net/docs/latest/pgpool-en.html pgpool-II manual] (English)
+
** Pgpool-II manual (English)
** [http://www.pgpool.net/docs/latest/pgpool-ja.html pgpool-II manual] (Japanese)
+
** [http://www.pgpool.net/docs/latest/en/html/ Pgpool-II 4.1]
** [http://www.pgpool.net/docs/latest/pgpool-zh_cn.html pgpool-II manual] (Simplified Chinese)
+
** [http://www.pgpool.net/docs/40/en/html/ Pgpool-II 4.0]
** [http://www.pgpool.net/docs/latest/tutorial-en.html pgpool-II tutorial] (English)
+
** [http://www.pgpool.net/docs/37/en/html/ Pgpool-II 3.7]
** [http://www.pgpool.net/docs/latest/tutorial-ja.html pgpool-II tutorial] (Japanese)
+
** [http://www.pgpool.net/docs/36/en/html/ Pgpool-II 3.6]
** [http://www.pgpool.net/docs/latest/tutorial-zh_cn.html pgpool-II tutorial] (Simplified Chinese)
+
** Pgpool-II manual (Japanese)
 +
** [http://www.pgpool.net/docs/latest/ja/html/ Pgpool-II 4.1]
 +
** [http://www.pgpool.net/docs/40/ja/html/ Pgpool-II 4.0]
 +
** [http://www.pgpool.net/docs/37/ja/html/ Pgpool-II 3.7]
 +
** [http://www.pgpool.net/docs/36/ja/html/ Pgpool-II 3.6]
 +
 
 +
<!-- ** [http://www.pgpool.net/docs/latest/pgpool-zh_cn.html pgpool-II manual] (Simplified Chinese)-->
 +
<!-- ** [http://www.pgpool.net/docs/latest/tutorial-en.html pgpool-II tutorial] (English)-->
 +
<!-- ** [http://www.pgpool.net/docs/latest/tutorial-ja.html pgpool-II tutorial] (Japanese)-->
 +
<!-- ** [http://www.pgpool.net/docs/latest/tutorial-zh_cn.html pgpool-II tutorial] (Simplified Chinese)-->
  
 
* '''pgpoolAdmin'''
 
* '''pgpoolAdmin'''
Line 12: Line 21:
 
** [http://www.pgpool.net/docs/pgpoolAdmin/index_ja.html pgpoolAdmin manual] (Japanese)
 
** [http://www.pgpool.net/docs/pgpoolAdmin/index_ja.html pgpoolAdmin manual] (Japanese)
  
 +
 +
* '''Tutorials of pgpool-II 4.0'''
 +
** Basic Configuration Example
 +
*** [http://www.pgpool.net/docs/latest/en/html/example-basic.html English] [http://www.pgpool.net/docs/latest/ja/html/example-basic.html Japanese]
 +
** Watchdog:
 +
*** Basic: [http://www.pgpool.net/docs/latest/en/html/example-watchdog.html English] [http://www.pgpool.net/docs/latest/ja/html/example-watchdog.html Japanese]
 +
*** master-slave mode: [http://www.pgpool.net/docs/latest/en/html/example-cluster.html English] [http://www.pgpool.net/docs/latest/ja/html/example-cluster.html Japanese]
 +
** AWS Configuration Example
 +
*** [http://www.pgpool.net/docs/latest/en/html/example-aws.html English] [http://www.pgpool.net/docs/latest/ja/html/example-aws.html Japanese]
 +
 +
== Developer's documentation ==
 +
 +
* [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/Introducing%20PostgreSQL%20SQL%20Parser.pdf Introducing PostgreSQL SQL Parser - Use of PostgreSQL Parser in other Applications -] at [https://www.pgcon.org/2019/ PGCon 2019 Ottawa] (English, PDF) (2019/05/31)
 +
* [https://www.sraoss.co.jp/event_seminar/2018/pgconf.asia-JA-20181211-day1-B4-peng.pdf Celebrating its 15th Anniversary: Pgpool-II Past, Present and Future - Part 2] at [https://www.pgconf.asia/EN/2018/day1/#B4 PGConf.ASIA 2018] (English, PDF) (2018/12/11)
 +
* [https://www.sraoss.co.jp/event_seminar/2018/pgconf.asia-JA-20181211-day1-B4-ishii.pdf Celebrating its 15th Anniversary: Pgpool-II Past, Present and Future - Part 1]  at [https://www.pgconf.asia/EN/2018/day1/#B4 PGConf.ASIA 2018] (English, PDF) (2018/12/11)
 +
* [https://www.sraoss.co.jp/event_seminar/2018/PostgreSQL-HA-with-Pgpool-II-20180925.pdf PostgreSQL HA with Pgpool-II and whats been happening in Pgpool world lately...] at [https://www.sraoss.co.jp/event_seminar/2018/0925.php Pgpool-II Day - Pgpool-II 4.0 Anniversary -] (English, PDF) (2018/9/25)
 +
* [https://www.sraoss.co.jp/event_seminar/2018/Pgpool-II-4-20180925.pdf PostgreSQL クラスタ環境の管理機能を大幅に強化!Pgpool-II 4.0 のご紹介] 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)
 +
* [http://www.pgpool.net/download.php?f=Pgpool-II-history.pdf Pgpool-II: Past, Present and Future] at [http://www.pgconf.asia/EN/2016/day-2/#B3 PGConf.ASIA 2016] (Japanese, PDF) (2016/12/07)
 +
* [http://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)
 +
* [http://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 [http://www.eventdove.com/event/106042 "PostgreSQL Conference China 2015"] (English, PDF) (2015/11/21)
 +
* [http://pgpool.net/mediawiki/index.php?title=pgpool-II_3.5_features&redirect=no pgpool-II 3.5 new features] (English, Wiki)
 +
* [http://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)
 +
* [http://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2015.pdf 6th Postgres Cluster Hackers Summit, pgCon 2015 "pgpool-II Development Status Updates"] (English, PDF)
 +
* [http://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2014.pdf 5th Postgres Cluster Hackers Summit, pgCon 2014 "pgpool-II Development Status Updates"] (English, PDF)
 +
* [http://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2013.pdf 4th Postgres Cluster Hackers Summit, pgCon 2013 "pgpool-II Development Status Updates"] (English, PDF)
 +
* [http://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 ==
 +
 +
* '''Pgpool-II 4.1 New Features'''
 +
** [http://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)
 +
** [http://pgsqlpgpool.blogspot.com/2019/04/statement-level-load-balancing.html Statement level load balancing] By Tatsuo Ishii (2019/04/01)
 +
** [http://pgsqlpgpool.blogspot.com/2019/03/shared-relation-cache.html Shared Relation Cache] By Tatsuo Ishii (2019/03/24)
 +
 +
* [http://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'''
 +
** [http://pgsqlpgpool.blogspot.jp/2013/06/settinng-up-everything-at-one-time.html Setting up everything at one time]
 +
** [http://pgsqlpgpool.blogspot.jp/2013/06/pgpool-ii-33-alpha-1-is-out.html pgpool-II 3.3 alpha1 is out!]
 +
** [http://pgsqlpgpool.blogspot.jp/2012/10/pgpool-ii-now.html pgpool-II + now()]
 +
** [http://pgsqlpgpool.blogspot.jp/2012/08/pgpool-ii-talk-at-postgresql-conference.html Pgpool-II talk at PostgreSQL Conference Europe 2012]
 +
 +
 +
<!--
 
== User contributed documentation ==
 
== User contributed documentation ==
 
* '''Documentation'''
 
* '''Documentation'''
Line 26: Line 82:
 
** [http://www.postgresql.jp/events/jpug-pgcon2013-files/C1_jpugpgcon2013_slide Construct high-availability, high-performance system with pgpool-II] (Japanese, PDF)
 
** [http://www.postgresql.jp/events/jpug-pgcon2013-files/C1_jpugpgcon2013_slide Construct high-availability, high-performance system with pgpool-II] (Japanese, PDF)
  
* '''Tutorials of Streaming Replication with pgpool-II'''
+
* '''Tutorials of pgpool-II 3.6'''
 +
** Basic Configuration Example
 +
*** [http://www.pgpool.net/docs/latest/en/html/example-basic.html English] [http://www.pgpool.net/docs/latest/ja/html/example-basic.html Japanese]
 +
** Watchdog:
 +
*** Basic: [http://www.pgpool.net/docs/latest/en/html/example-watchdog.html English] [http://www.pgpool.net/docs/latest/ja/html/example-watchdog.html Japanese]
 +
*** master-slave mode: [http://www.pgpool.net/docs/latest/en/html/example-cluster.html English] [http://www.pgpool.net/docs/latest/ja/html/example-cluster.html Japanese]
 +
** AWS Configuration Example
 +
*** [http://www.pgpool.net/docs/latest/en/html/example-aws.html English] [http://www.pgpool.net/docs/latest/ja/html/example-aws.html Japanese]
 +
 
 +
* '''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: [http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/index.html English (2012/01/31) ]  [http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/index-ja.html Japanese (2012/6/1) ]
 
*** For pgpool-II 3.1 and PostgreSQL 9.1: [http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/index.html English (2012/01/31) ]  [http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/index-ja.html Japanese (2012/6/1) ]
Line 35: Line 100:
 
*** For pgpool-II 3.0 and PostgreSQL 9.0: [http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/index.html English] [http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.0/index-ja.html Japanese]
 
*** For pgpool-II 3.0 and PostgreSQL 9.0: [http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/index.html English] [http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.0/index-ja.html Japanese]
  
* '''Tutorials of pgpool-II 3.3'''
+
* '''Tutorials of pgpool-II 3.3 (Obsolete)'''
 
** Watchdog:
 
** Watchdog:
 
*** master-slave mode: [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html English (2014/04/07)] [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/ja.html Japanese (2014/04/07)]
 
*** master-slave mode: [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html English (2014/04/07)] [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/ja.html Japanese (2014/04/07)]
  
* '''Tutorials of pgpool-II 3.2'''
+
* '''Tutorials of pgpool-II 3.2 (Obsolete)'''
 
** On memory query cache: [http://www.pgpool.net/pgpool-web/contrib_docs/memqcache/en.html English (2012/07/20)] [http://www.pgpool.net/pgpool-web/contrib_docs/memqcache/ja.html Japanese (2012/07/20)]
 
** On memory query cache: [http://www.pgpool.net/pgpool-web/contrib_docs/memqcache/en.html English (2012/07/20)] [http://www.pgpool.net/pgpool-web/contrib_docs/memqcache/ja.html Japanese (2012/07/20)]
 
** Watchdog:
 
** Watchdog:
 
*** Basic: [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog/en.html English (2012/07/20)] [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog/ja.html Japanese (2012/07/20)]
 
*** Basic: [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog/en.html English (2012/07/20)] [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog/ja.html Japanese (2012/07/20)]
 
*** master-slave mode: [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/en.html English (2012/10/22)] [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/ja.html Japanese (2012/10/15)]
 
*** master-slave mode: [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/en.html English (2012/10/22)] [http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/ja.html Japanese (2012/10/15)]
 
+
-->
== Developer's documentation ==
 
* [http://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2012.pdf 3rd Postgres Cluster Hackers Summit, pgCon 2012 "pgpool-II Development Status Updates"] (English, PDF)
 
* [http://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2013.pdf 4th Postgres Cluster Hackers Summit, pgCon 2013 "pgpool-II Development Status Updates"] (English, PDF)
 
* [http://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2014.pdf 5th Postgres Cluster Hackers Summit, pgCon 2014 "pgpool-II Development Status Updates"] (English, PDF)
 
* [http://www.pgpool.net/pgpool-web/contrib_docs/ClusterMeeting2015.pdf 6th Postgres Cluster Hackers Summit, pgCon 2015 "pgpool-II Development Status Updates"] (English, PDF)
 
* [http://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)
 
* [http://pgpool.net/mediawiki/index.php?title=pgpool-II_3.5_features&redirect=no pgpool-II 3.5 new features] (English, Wiki)
 
* [http://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 [http://www.eventdove.com/event/106042 "PostgreSQL Conference China 2015"] (English, PDF)
 
 
 
== Blog posts by pgpool developers ==
 
* [http://pgsqlpgpool.blogspot.jp/2013/06/settinng-up-everything-at-one-time.html Setting up everything at one time]
 
* [http://pgsqlpgpool.blogspot.jp/2013/06/pgpool-ii-33-alpha-1-is-out.html pgpool-II 3.3 alpha1 is out!]
 
* [http://pgsqlpgpool.blogspot.jp/2012/10/pgpool-ii-now.html pgpool-II + now()]
 
* [http://pgsqlpgpool.blogspot.jp/2012/08/pgpool-ii-talk-at-postgresql-conference.html Pgpool-II talk at PostgreSQL Conference Europe 2012]
 

Latest revision as of 09:28, 31 October 2019

Official documentation



Developer's documentation

Blog posts by pgpool developers