pgpool2.git
9 years agofix typo in release note
pengbo [Wed, 2 Nov 2016 01:39:40 +0000 (10:39 +0900)]
fix typo in release note

9 years agoTranslate SGML into Japanese
Yugo Nagata [Wed, 2 Nov 2016 01:36:59 +0000 (10:36 +0900)]
Translate SGML into Japanese

- failover.sgml
- memcache.sgml
- misc-config.sgml
- online-recovery.sgml
- ssl.sgml
- stream-check.sgml
- watchdog.sgml

9 years agoFix typos in Japanese translation of release-3.6.sgml.
Tatsuo Ishii [Wed, 2 Nov 2016 01:06:10 +0000 (10:06 +0900)]
Fix typos in Japanese translation of release-3.6.sgml.

So far, up to "Fix for avoiding downtime when
<productname>Pgpool-II</productname> changes require a
restart. (Muhammad Usama)" had been checked.

9 years agoMerge branch 'master' of ssh://git.postgresql.org/pgpool2
pengbo [Tue, 1 Nov 2016 12:54:04 +0000 (21:54 +0900)]
Merge branch 'master' of ssh://git.postgresql.org/pgpool2

9 years agoadd Japanese 3.6 releasenote
pengbo [Tue, 1 Nov 2016 12:53:04 +0000 (21:53 +0900)]
add Japanese 3.6 releasenote

9 years agoTranslate healthcheck.sgml into Japanese
Yugo Nagata [Tue, 1 Nov 2016 11:01:09 +0000 (20:01 +0900)]
Translate healthcheck.sgml into Japanese

9 years agoFix a error of commenting-out
Yugo Nagata [Tue, 1 Nov 2016 08:51:48 +0000 (17:51 +0900)]
Fix a error of commenting-out

9 years agoAdd missing translation into loadbalance.sgml
Yugo Nagata [Tue, 1 Nov 2016 08:42:08 +0000 (17:42 +0900)]
Add missing translation into loadbalance.sgml

9 years agoTranslate loadbalance.sgml into Japanese
Yugo Nagata [Tue, 1 Nov 2016 08:29:37 +0000 (17:29 +0900)]
Translate loadbalance.sgml into Japanese

9 years agoTranslate connection-pooling.sgml into Japanese
Yugo Nagata [Tue, 1 Nov 2016 08:29:14 +0000 (17:29 +0900)]
Translate connection-pooling.sgml into Japanese

9 years agoFix a paramete type
Yugo Nagata [Tue, 1 Nov 2016 08:28:43 +0000 (17:28 +0900)]
Fix a paramete type

9 years agoRemove white space at end of line
Yugo Nagata [Tue, 1 Nov 2016 08:25:46 +0000 (17:25 +0900)]
Remove white space at end of line

9 years agoTranslate connection-setting.sgml into Japanes
Yugo Nagata [Mon, 31 Oct 2016 00:15:50 +0000 (09:15 +0900)]
Translate connection-setting.sgml into Japanes

9 years agoadd Japanese docs for reference
pengbo [Mon, 31 Oct 2016 05:16:58 +0000 (14:16 +0900)]
add Japanese docs for reference

9 years agoTranslate connection-setting.sgml into Japanese
Yugo Nagata [Thu, 27 Oct 2016 11:14:23 +0000 (20:14 +0900)]
Translate connection-setting.sgml into Japanese

Some types fixes and elaboration are also done.

9 years agoAdopt the incompatibility with psql of PostgreSQL 9.6.
Tatsuo Ishii [Thu, 27 Oct 2016 08:36:28 +0000 (17:36 +0900)]
Adopt the incompatibility with psql of PostgreSQL 9.6.

Since -c option does not imply -X anymore in 9.6, regression fails if
.psqlrc is set, for example "\pset pager" is set.

9 years agoDo not cancel a query when the query resulted in an error other than in native replic...
Tatsuo Ishii [Thu, 27 Oct 2016 08:04:46 +0000 (17:04 +0900)]
Do not cancel a query when the query resulted in an error other than in native replication mode.

It was intended to keep the consistency, but there's no point in other
than native replication mode.

9 years agoRemove obsoleted option "-c".
Tatsuo Ishii [Thu, 27 Oct 2016 04:24:56 +0000 (13:24 +0900)]
Remove obsoleted option "-c".

Also fix typo in the help message.

9 years agoMinor enhancement on ref/pgpool.sgml.
Tatsuo Ishii [Thu, 27 Oct 2016 02:19:12 +0000 (11:19 +0900)]
Minor enhancement on ref/pgpool.sgml.

9 years agoTranslate ref/pgpool.sgml into Japanese.
Tatsuo Ishii [Thu, 27 Oct 2016 01:59:02 +0000 (10:59 +0900)]
Translate ref/pgpool.sgml into Japanese.

Also change document id to "Pgpool-II" to not conflict with the id in
ref/pgpool.sgml.

9 years agoAdd pgpool command reference manual.
Tatsuo Ishii [Thu, 27 Oct 2016 01:26:56 +0000 (10:26 +0900)]
Add pgpool command reference manual.

To my surprise, there was no such a manual in the old HTML docs.

9 years agoTranslate config.sgml into Japanese
Yugo Nagata [Wed, 26 Oct 2016 10:00:29 +0000 (19:00 +0900)]
Translate config.sgml into Japanese

9 years agoAdd description about supported platform to intro.sgml.
Tatsuo Ishii [Wed, 26 Oct 2016 08:10:24 +0000 (17:10 +0900)]
Add description about supported platform to intro.sgml.

9 years agoUpdate Japanese translation according to the updating of English doc.
Tatsuo Ishii [Tue, 25 Oct 2016 22:53:12 +0000 (07:53 +0900)]
Update Japanese translation according to the updating of English doc.

9 years agoRephrasing a section about start/stop watchdog in advanced.sgml
Muhammad Usama [Tue, 25 Oct 2016 10:11:42 +0000 (15:11 +0500)]
Rephrasing a section about start/stop watchdog in advanced.sgml

9 years agotranslate some reference docs into Japanese
pengbo [Tue, 25 Oct 2016 09:10:46 +0000 (18:10 +0900)]
translate some reference docs into Japanese

9 years agoTranslate advanced.sgml into Japanese.
Tatsuo Ishii [Tue, 25 Oct 2016 01:13:27 +0000 (10:13 +0900)]
Translate advanced.sgml into Japanese.

Also fix typos in the English doc.

9 years agoTranslate runtime.sgml into Japanese
Yugo Nagata [Mon, 24 Oct 2016 11:47:06 +0000 (20:47 +0900)]
Translate runtime.sgml into Japanese

9 years agoTranslate installation.sgml into Japanese
Yugo Nagata [Mon, 24 Oct 2016 08:06:55 +0000 (17:06 +0900)]
Translate installation.sgml into Japanese

9 years agoTranslate watchdog.sgml into Japanese.
Tatsuo Ishii [Mon, 24 Oct 2016 04:45:33 +0000 (13:45 +0900)]
Translate watchdog.sgml into Japanese.

9 years agoTranslate figure title.
Tatsuo Ishii [Mon, 24 Oct 2016 01:07:25 +0000 (10:07 +0900)]
Translate figure title.

9 years agoFix typos and add some tags
Yugo Nagata [Fri, 21 Oct 2016 08:30:27 +0000 (17:30 +0900)]
Fix typos and add some tags

9 years agoTranslate start.sgml into japanese.
Tatsuo Ishii [Fri, 21 Oct 2016 08:19:57 +0000 (17:19 +0900)]
Translate start.sgml into japanese.

9 years agoOriginal document in english was updated
Yugo Nagata [Fri, 21 Oct 2016 07:20:18 +0000 (16:20 +0900)]
Original document in english was updated

9 years agoReplace pgpool-II into Pgpool-II and add some tags
Yugo Nagata [Fri, 21 Oct 2016 07:19:10 +0000 (16:19 +0900)]
Replace pgpool-II into Pgpool-II and add some tags

9 years agoRemove description about bzip2 from installation.sgml
Yugo Nagata [Fri, 21 Oct 2016 06:45:46 +0000 (15:45 +0900)]
Remove description about bzip2 from installation.sgml

We don't provide .tar.bz2 packages

9 years agoFix a type of installation.sgml
Yugo Nagata [Fri, 21 Oct 2016 06:44:46 +0000 (15:44 +0900)]
Fix a type of installation.sgml

This was explanation about PostgreSQL not Pgpool-II

9 years agoFix a type of installation.sgml
Yugo Nagata [Fri, 21 Oct 2016 06:34:42 +0000 (15:34 +0900)]
Fix a type of installation.sgml

This was explanation about PostgreSQL not Pgpool-II

9 years agoRevert "Fix typo"
Yugo Nagata [Fri, 21 Oct 2016 06:30:27 +0000 (15:30 +0900)]
Revert "Fix typo"

Unnecessary html files were commited by mistake.

This reverts commit 8e86363d08fa67492491b86c489da5d992d62bfe.

9 years agoFix typo
Yugo Nagata [Fri, 21 Oct 2016 06:23:40 +0000 (15:23 +0900)]
Fix typo

This was explanation about PostgreSQL not Pgpool-II

9 years agoFix small typos and translate tutorial section.
Tatsuo Ishii [Fri, 21 Oct 2016 05:27:13 +0000 (14:27 +0900)]
Fix small typos and translate tutorial section.

9 years agoTranslate problems.sgml into Japanese.
Tatsuo Ishii [Fri, 21 Oct 2016 05:18:00 +0000 (14:18 +0900)]
Translate problems.sgml into Japanese.

9 years agoTranslate restrictions.sgml into Japanese.
Tatsuo Ishii [Fri, 21 Oct 2016 03:32:45 +0000 (12:32 +0900)]
Translate restrictions.sgml into Japanese.

Fix errors in restrictions.sgml (English).

9 years agoTranslate info.sgml into Japanese.
Tatsuo Ishii [Fri, 21 Oct 2016 01:16:30 +0000 (10:16 +0900)]
Translate info.sgml into Japanese.

9 years agoTranslate notation.sgml into Japanese.
Tatsuo Ishii [Fri, 21 Oct 2016 00:59:28 +0000 (09:59 +0900)]
Translate notation.sgml into Japanese.

9 years agoTranslate history.sgml into Japanese.
Tatsuo Ishii [Fri, 21 Oct 2016 00:48:39 +0000 (09:48 +0900)]
Translate history.sgml into Japanese.

9 years agoAdd "lang=ja" so that Japanese navigation links are generated.
Tatsuo Ishii [Thu, 20 Oct 2016 23:32:12 +0000 (08:32 +0900)]
Add "lang=ja" so that Japanese navigation links are generated.

9 years agoTranslate pgpool.sgml to Japanese about Server Administration
Yugo Nagata [Thu, 20 Oct 2016 05:50:59 +0000 (14:50 +0900)]
Translate pgpool.sgml to Japanese about Server Administration

9 years agoTranslate intro.sgml into Japanese.
Tatsuo Ishii [Wed, 19 Oct 2016 08:49:05 +0000 (17:49 +0900)]
Translate intro.sgml into Japanese.

Fix typo in English intro.sgml.

9 years agoFix for [pgpool-hackers: 1850] PGPOOL SET/RESET SGML manual
Muhammad Usama [Wed, 19 Oct 2016 07:19:26 +0000 (12:19 +0500)]
Fix for [pgpool-hackers: 1850] PGPOOL SET/RESET SGML manual

9 years agoAdd missing files etc. in the previous commit.
Tatsuo Ishii [Wed, 19 Oct 2016 04:51:00 +0000 (13:51 +0900)]
Add missing files etc. in the previous commit.

9 years agoThis is the starting point of Japanese doc translation work.
Tatsuo Ishii [Wed, 19 Oct 2016 04:41:34 +0000 (13:41 +0900)]
This is the starting point of Japanese doc translation work.

9 years agoPrepare 3.6 alpha1 V3_6_0_ALPHA1
pengbo [Wed, 19 Oct 2016 03:15:31 +0000 (12:15 +0900)]
Prepare 3.6 alpha1

9 years agofix some mistakes in sgml release note
pengbo [Wed, 19 Oct 2016 03:08:16 +0000 (12:08 +0900)]
fix some mistakes in sgml release note

9 years agoFix for 0000252: authentication failed error when PCP command is cancelled...
Muhammad Usama [Tue, 18 Oct 2016 10:46:15 +0000 (15:46 +0500)]
Fix for 0000252: authentication failed error when PCP command is cancelled...

Fixed by adding the volatile modifier to authenticated flag, to make sure we
always get the updated value after the long jump.

9 years agoAdd a process diagram to "Architectural Fundamentals"
Tatsuo Ishii [Tue, 18 Oct 2016 08:19:32 +0000 (17:19 +0900)]
Add a process diagram to "Architectural Fundamentals"

9 years agoadd Pgpool-3.6 release-note (part of changes and bug fix)
pengbo [Tue, 18 Oct 2016 07:36:03 +0000 (16:36 +0900)]
add Pgpool-3.6 release-note (part of changes and bug fix)

9 years agoAdd more explanation about load balancing.
Tatsuo Ishii [Tue, 18 Oct 2016 07:07:35 +0000 (16:07 +0900)]
Add more explanation about load balancing.

9 years agoFix typo.
Tatsuo Ishii [Tue, 18 Oct 2016 06:57:20 +0000 (15:57 +0900)]
Fix typo.

9 years agoAdd link to restriction section.
Tatsuo Ishii [Tue, 18 Oct 2016 01:17:32 +0000 (10:17 +0900)]
Add link to restriction section.

9 years agoAdd remaining pseudo SQL command manuals.
Tatsuo Ishii [Mon, 17 Oct 2016 06:15:52 +0000 (15:15 +0900)]
Add remaining pseudo SQL command manuals.

9 years agoAdd show pool_nodes, show pool_processes and show pool_status
Tatsuo Ishii [Mon, 17 Oct 2016 04:45:05 +0000 (13:45 +0900)]
Add show pool_nodes, show pool_processes and show pool_status
reference manuals.

9 years agoEnhancements part of Pgpool-II 3.6 release note.
Tatsuo Ishii [Mon, 17 Oct 2016 03:50:58 +0000 (12:50 +0900)]
Enhancements part of Pgpool-II 3.6 release note.

9 years agoAdding SGML docs for PGPOOL SET/RESET/SHOW commands and Writing the setting parameter...
Muhammad Usama [Fri, 14 Oct 2016 21:14:25 +0000 (02:14 +0500)]
Adding SGML docs for PGPOOL SET/RESET/SHOW commands and Writing the setting parameters section

9 years agoAdding watchdog example to SGML doc
Muhammad Usama [Fri, 14 Oct 2016 13:14:20 +0000 (18:14 +0500)]
Adding watchdog example to SGML doc

9 years agoRelease note for 3.6 in progress.
Tatsuo Ishii [Fri, 14 Oct 2016 06:09:50 +0000 (15:09 +0900)]
Release note for 3.6 in progress.

9 years agoFix typo.
Tatsuo Ishii [Fri, 14 Oct 2016 02:52:19 +0000 (11:52 +0900)]
Fix typo.

9 years agoFix misc typos.
Tatsuo Ishii [Fri, 14 Oct 2016 02:47:22 +0000 (11:47 +0900)]
Fix misc typos.

9 years agoSGML Doc for Basic Configuration Example
Muhammad Usama [Thu, 13 Oct 2016 19:13:06 +0000 (00:13 +0500)]
SGML Doc for Basic Configuration Example

9 years agoSome more SGML docs
Muhammad Usama [Thu, 13 Oct 2016 14:51:55 +0000 (19:51 +0500)]
Some more SGML docs

9 years agoWriting the misc config parameters section of SGML docs
Muhammad Usama [Tue, 11 Oct 2016 12:23:10 +0000 (17:23 +0500)]
Writing the misc config parameters section of SGML docs

9 years agoAdd release notes.
Tatsuo Ishii [Tue, 11 Oct 2016 05:20:04 +0000 (14:20 +0900)]
Add release notes.

9 years agoUpdate Appendix A. Release Notes.
Tatsuo Ishii [Tue, 11 Oct 2016 04:17:17 +0000 (13:17 +0900)]
Update Appendix A. Release Notes.

Actual release note contents are not written yet.

9 years agoRemove Bibliography chapter.
Tatsuo Ishii [Tue, 11 Oct 2016 04:06:31 +0000 (13:06 +0900)]
Remove Bibliography chapter.

This was copied from PostgreSQL and Pgpool-II does not need it.x

9 years agoAdd "Architectural Functionality" section to Tutorial.
Tatsuo Ishii [Mon, 10 Oct 2016 22:58:55 +0000 (07:58 +0900)]
Add "Architectural Functionality" section to Tutorial.

9 years agoSGML docs for in memory query cache
Muhammad Usama [Mon, 10 Oct 2016 19:38:44 +0000 (00:38 +0500)]
SGML docs for in memory query cache

9 years agoWriting SGML docs for server administration
Muhammad Usama [Sun, 9 Oct 2016 19:14:42 +0000 (00:14 +0500)]
Writing SGML docs for server administration

9 years agoWrite tutorial.
Tatsuo Ishii [Fri, 7 Oct 2016 09:26:51 +0000 (18:26 +0900)]
Write tutorial.

9 years agoFix SGML compile errors.
Tatsuo Ishii [Thu, 6 Oct 2016 21:58:03 +0000 (06:58 +0900)]
Fix SGML compile errors.

openjade  -wall -wno-unused-param -wno-empty -wfully-tagged   -d stylesheet.dsl -t sgml -i output-html  -i include-index pgpool.sgml
openjade:loadbalance.sgml:28:31:E: character "_" is not allowed in the value of attribute "ID"
openjade:healthcheck.sgml:62:31:E: character "_" is not allowed in the value of attribute "ID"
openjade:healthcheck.sgml:89:33:E: character "_" is not allowed in the value of attribute "LINKEND"
openjade:failover.sgml:191:25:E: character "_" is not allowed in the value of attribute "ID"

9 years agoWriting SGML docs for SSL config
Muhammad Usama [Thu, 6 Oct 2016 19:39:02 +0000 (00:39 +0500)]
Writing SGML docs for SSL config

9 years agoWriting some more SGML docs
Muhammad Usama [Thu, 6 Oct 2016 16:32:50 +0000 (21:32 +0500)]
Writing some more SGML docs

9 years agoAdd SGML docs for load balancing config
Muhammad Usama [Thu, 6 Oct 2016 15:23:01 +0000 (20:23 +0500)]
Add SGML docs for load balancing config

9 years agoAdd SGML docs for watchdog architecture
Muhammad Usama [Thu, 6 Oct 2016 09:53:18 +0000 (14:53 +0500)]
Add SGML docs for watchdog architecture

9 years agoWrite some watchdog SGML documents.
Muhammad Usama [Wed, 5 Oct 2016 12:38:28 +0000 (17:38 +0500)]
Write some watchdog SGML documents.

9 years agoadd SGML docs about authentication
Muhammad Usama [Tue, 4 Oct 2016 14:53:22 +0000 (19:53 +0500)]
add SGML docs about authentication

9 years agoadd SGML docs about health check
Muhammad Usama [Tue, 4 Oct 2016 13:27:18 +0000 (18:27 +0500)]
add SGML docs about health check

9 years agoadd SGML docs of watchdog tutorial
Muhammad Usama [Tue, 4 Oct 2016 12:59:02 +0000 (17:59 +0500)]
add SGML docs of watchdog tutorial

9 years agoadd sgml docs
pengbo [Thu, 29 Sep 2016 08:28:41 +0000 (17:28 +0900)]
add sgml docs

9 years agoadd SGML docs of pg_md5
pengbo [Thu, 29 Sep 2016 07:58:49 +0000 (16:58 +0900)]
add SGML docs of pg_md5

9 years agoAdd "Setting up pgpool.conf" section to installation.sgml
Tatsuo Ishii [Wed, 28 Sep 2016 09:00:27 +0000 (18:00 +0900)]
Add  "Setting up pgpool.conf" section to installation.sgml

Still need more work in this section...

9 years agoAdd restrictions section.
Tatsuo Ishii [Wed, 28 Sep 2016 06:40:38 +0000 (15:40 +0900)]
Add restrictions section.

9 years agoFix resource leak.
Muhammad Usama [Tue, 27 Sep 2016 15:30:49 +0000 (20:30 +0500)]
Fix resource leak.

Per coverity CID 1355044.

9 years agoadd SGML doc of pcp command
pengbo [Tue, 27 Sep 2016 08:49:19 +0000 (17:49 +0900)]
add SGML doc of pcp command

9 years agoChange the default value of search_primary_node_timeout from 10 to 300.
Tatsuo Ishii [Sat, 24 Sep 2016 01:42:12 +0000 (10:42 +0900)]
Change the default value of search_primary_node_timeout from 10 to 300.

Prior default value 10 seconds is sometimes too short for a standby to
be promoted.

Per [pgpool-general: 5026].

9 years agoFix the case when all backends are down then 1 node attached.
Tatsuo Ishii [Wed, 21 Sep 2016 00:26:46 +0000 (09:26 +0900)]
Fix the case when all backends are down then 1 node attached.

When all backends are down, no connection is accepted. Then 1
PostgreSQL becomes up, and attach the node using pcp_attach_node. It
successfully finishes. However, when a new connection arrives, still
the connection is refused because pgpool child process looks into the
cached status, in which the recovered node is still in down status if
mode is streaming replication mode (native replication and other modes
are fine). Solution is, if all nodes are down, force to restart all
pgpool child.

Per bug 248.

9 years agoFix for: [pgpool-general: 4997] Avoiding downtime when pgpool changes require a restart
Muhammad Usama [Mon, 19 Sep 2016 20:22:49 +0000 (01:22 +0500)]
Fix for: [pgpool-general: 4997] Avoiding downtime when pgpool changes require a restart

To fix this, The verification mechanism of configuration parameter values is
reversed, previously the standby nodes used to verify their parameter values
against the respective values on the master pgpool-II node and when the
inconsistency was found the FATAL error was thrown, now with this commit the
verification responsibility is delegated to the master pgpool-II node.
Now the master node will verify the configuration parameter values of each
joining standby node against its local values and will produce
a WARNING message instead of an error in case of a difference.
This way the nodes having the different configurations will also be allowed to
join the watchdog cluster and the user has to manually look out for the
configuration inconsistency warnings in the master pgpool-II log to avoid the
surprises at the time of pgpool-II master switch over.

9 years agoFixing a problem with the watchdog failover_command locking mechanism
Muhammad Usama [Mon, 19 Sep 2016 19:38:49 +0000 (00:38 +0500)]
Fixing a problem with the watchdog failover_command locking mechanism

From pgpool-II 3.5 watchdog was using the separate individual locks for each
node-failover command(failover, failback and follow-master) and the lock was
acquired just before executing the respective failover script and was released
as soon as the script execution finishes. This technique although was very
efficient but also had a problem. If the failover command takes a very little
time and gets finished before the lock request from other pgpool-II node
arrives, the other node is also granted a lock, since the lock was already
released by the first node at that time. Consequently, both nodes ends up
executing the failover script.
So to fix this we are reverting back to the tested failover interlocking design
used prior to pgpool-II 3.5 where all the commands gets locked at the failover
start by the node that becomes a lock-holder and each command lock is released
after its execution finishes. And only the lock-holder node is allowed to
acquire/release the individual command lock. That way the lock-holder node
keeps the lock-holder status throughout the span of the failover execution and
the system becomes less time sensitive.

The issue was identified by Yugo<nagata@sraoss.co.jp>

9 years agoadd SGML doc [pcp_node_info]
pengbo [Fri, 16 Sep 2016 06:45:07 +0000 (15:45 +0900)]
add SGML doc [pcp_node_info]

9 years agofix some mistakes by importing 9.6 parser
pengbo [Fri, 16 Sep 2016 01:23:24 +0000 (10:23 +0900)]
fix some mistakes by importing 9.6 parser

9 years agoWrite some SGML documents.
Tatsuo Ishii [Tue, 13 Sep 2016 09:01:30 +0000 (18:01 +0900)]
Write some SGML documents.