diff --git a/doc/src/sgml/advanced.sgml b/doc/src/sgml/advanced.sgml index 8af6fcc..a59701a 100644 --- a/doc/src/sgml/advanced.sgml +++ b/doc/src/sgml/advanced.sgml @@ -12,7 +12,7 @@ availability. Watchdog is used to resolve the single point of failure by coordinating multiple Pgpool-II nodes. The watchdog was first - introduced in pgpool-II + introduced in Pgpool-II V3.2 and is significantly enhanced in Pgpool-II V3.5, to ensure the presence of a quorum at all time. This new addition to @@ -417,7 +417,7 @@ the "NODES LIST DATA" result packet. - The result packet returnd by watchdog for the "GET NODES LIST" + The result packet returned by watchdog for the "GET NODES LIST" will contains the list of all configured watchdog nodes to do health check on in the JSON format. The JSON of the watchdog nodes contains the @@ -523,7 +523,7 @@ status and brings the virtual IP assigned to watchdog down. Thus clients of Pgpool-II cannot connect to Pgpool-II using the - virtual IP any more. This is neccessary to avoid split-brain, + virtual IP any more. This is necessary to avoid split-brain, that is, situations where there are multiple active Pgpool-II. diff --git a/doc/src/sgml/client-auth.sgml b/doc/src/sgml/client-auth.sgml index 815b329..be460ef 100644 --- a/doc/src/sgml/client-auth.sgml +++ b/doc/src/sgml/client-auth.sgml @@ -13,8 +13,8 @@ a PostgreSQL database client, so when a client application connects to the Pgpool-II, Pgpool-II - inturn connects to the PostgreSQL servers - using the same credentials to serve the incomming client + in turn connects to the PostgreSQL servers + using the same credentials to serve the incoming client connection. Thus, all the access privileges and restrictions defined for the user in PostgreSQL gets automatically applied to all Pgpool-II @@ -28,7 +28,7 @@ Pgpool-II server and not that of the actual client. Therefore, for the client host based authentications Pgpool-II has the pool_hba mechanism similar to the pg_hba mechanism for - authenticating the incomming client connections. + authenticating the incoming client connections. diff --git a/doc/src/sgml/connection-pooling.sgml b/doc/src/sgml/connection-pooling.sgml index e7d6263..d88a18f 100644 --- a/doc/src/sgml/connection-pooling.sgml +++ b/doc/src/sgml/connection-pooling.sgml @@ -122,7 +122,7 @@ - But serialization has its own overheads, and it is recomended + But serialization has its own overheads, and it is recommended to be used only with the larger values of . For the small number of , the serialize accept can degrade the performance because of @@ -131,8 +131,8 @@ - It is recomended to do a benchmark before deciding wether to use - serialize_accept or not, because the corelation + It is recommended to do a benchmark before deciding whether to use + serialize_accept or not, because the correlation of and serialize_accept can be different on different environments. diff --git a/doc/src/sgml/connection-settings.sgml b/doc/src/sgml/connection-settings.sgml index 2fe5051..7b65792 100644 --- a/doc/src/sgml/connection-settings.sgml +++ b/doc/src/sgml/connection-settings.sgml @@ -758,7 +758,7 @@ Pgpool-II V2.2 or later, automatically detects whether the table has a SERIAL columns or not, so it never locks the table if it - desn't have the SERIAL columns. + doesn't have the SERIAL columns. diff --git a/doc/src/sgml/example-AWS.sgml b/doc/src/sgml/example-AWS.sgml index 40bc138..daa63c6 100644 --- a/doc/src/sgml/example-AWS.sgml +++ b/doc/src/sgml/example-AWS.sgml @@ -67,7 +67,7 @@ which we will not set in this example instead we will use and to switch the - Elastic IP address to the maste/Active Pgpool-II node. + Elastic IP address to the master/Active Pgpool-II node. diff --git a/doc/src/sgml/example-Aurora.sgml b/doc/src/sgml/example-Aurora.sgml index 44bb043..004e995 100644 --- a/doc/src/sgml/example-Aurora.sgml +++ b/doc/src/sgml/example-Aurora.sgml @@ -29,7 +29,7 @@ Set to 0 to disable streaming replication delay checking. This is because Aurora does - not provide neccessary functions to check the + not provide necessary functions to check the replication delay. @@ -53,7 +53,7 @@ Aurora writer node. Set other for the Aurora reader node. Set - appropreate as + appropriate as usual. You don't need to set diff --git a/doc/src/sgml/example-basic.sgml b/doc/src/sgml/example-basic.sgml index ec6e62a..5cffd49 100644 --- a/doc/src/sgml/example-basic.sgml +++ b/doc/src/sgml/example-basic.sgml @@ -69,7 +69,7 @@ $ cp /usr/local/etc/pgpool.conf.sample /usr/local/etc/pgpool.conf Pgpool-II only accepts connections from the localhost - using port 9999 by the default. If you wish to receive conenctions from other hosts, + using port 9999 by the default. If you wish to receive connections from other hosts, set to '*'. listen_addresses = 'localhost' diff --git a/doc/src/sgml/example-cluster.sgml b/doc/src/sgml/example-cluster.sgml index f14753d..7d7a9a5 100644 --- a/doc/src/sgml/example-cluster.sgml +++ b/doc/src/sgml/example-cluster.sgml @@ -254,7 +254,7 @@ User Name - Passowrd + Password Detail @@ -351,7 +351,7 @@ To allow repl user without specifying password for streaming replication and online recovery, and execute pg_rewind using postgres, we create the .pgpass file - in postgres user's home directory and change the permisson to + in postgres user's home directory and change the permission to 600 on each PostgreSQL server. @@ -390,7 +390,7 @@ When installing Pgpool-II from RPM, all the Pgpool-II configuration files are in /etc/pgpool-II. - In this example, we copy the sample configuration file for streaming replicaton mode. + In this example, we copy the sample configuration file for streaming replication mode. # cp -p /etc/pgpool-II/pgpool.conf.sample-stream /etc/pgpool-II/pgpool.conf @@ -433,7 +433,7 @@ health_check_max_retries = 3 - Specify the PostgreSQL backend informations. + Specify the PostgreSQL backend information. Multiple backends can be specified by adding a number at the end of the parameter name. @@ -1003,7 +1003,7 @@ exit 0 - Execute command pg_enc -m -k /path/to/.pgpoolkey -u username -p to regist user + Execute command pg_enc -m -k /path/to/.pgpoolkey -u username -p to register user name and AES encrypted password in file pool_passwd. If pool_passwd doesn't exist yet, it will be created in the same directory as pgpool.conf. @@ -1411,7 +1411,7 @@ arping_path = '/usr/sbin' After executing pcp_recovery_node command, - vertify that server2 and server3 + verify that server2 and server3 are started as PostgreSQL standby server. @@ -1459,7 +1459,7 @@ arping_path = '/usr/sbin' Start Pgpool-II (server1) which we have stopped again, - and vertify that server1 runs as a standby. + and verify that server1 runs as a standby. [server1]# systemctl start pgpool.service @@ -1478,7 +1478,7 @@ arping_path = '/usr/sbin' Failover First, use psql to connect to PostgreSQL via virtual IP, - and verify the backend informations. + and verify the backend information. # psql -h 192.168.137.150 -p 9999 -U pgpool postgres -c "show pool_nodes" diff --git a/doc/src/sgml/example-watchdog.sgml b/doc/src/sgml/example-watchdog.sgml index 622f632..1021843 100644 --- a/doc/src/sgml/example-watchdog.sgml +++ b/doc/src/sgml/example-watchdog.sgml @@ -158,7 +158,7 @@ [root@osspc20]# {installed_dir}/bin/pgpool -n -f {installed_dir}/etc/pgpool.conf > pgpool.log 2>&1 Log messages will show that Pgpool-II - has joind the watchdog cluster as standby watchdog. + has joined the watchdog cluster as standby watchdog. LOG: watchdog cluster configured with 1 remote nodes LOG: watchdog remote node:0 on Linux_osspc16_9000:9000 diff --git a/doc/src/sgml/failover.sgml b/doc/src/sgml/failover.sgml index 47f56a6..00c54c5 100644 --- a/doc/src/sgml/failover.sgml +++ b/doc/src/sgml/failover.sgml @@ -269,7 +269,7 @@ Specifies a user command to run when a PostgreSQL backend node gets attached to Pgpool-II. Pgpool-II replaces the following special characters with the backend specific information. - before excuting the command. + before executing the command. @@ -665,7 +665,7 @@ When set to on, standby node be automatically failback, if the node status is down but streaming replication works normally. This is useful when - standby node is degenerated by pgpool because of the tempolary network failure. + standby node is degenerated by pgpool because of the temporary network failure. @@ -673,7 +673,7 @@ must be enabled, and PostgreSQL 9.1 or later is required as backend nodes. This feature use pg_stat_replicatoin on primary node, the automatic failback is performed to standby node only. - Note that failback_command will be executed as well if failback_commnad is not empty. + Note that failback_command will be executed as well if failback_command is not empty. If you plan to detach standby node for maintenance, set this parameter to off beforehand. Otherwise it's possible that standby node is reattached against your intention. diff --git a/doc/src/sgml/installation-rpm.sgml b/doc/src/sgml/installation-rpm.sgml index 090fce5..de248f2 100644 --- a/doc/src/sgml/installation-rpm.sgml +++ b/doc/src/sgml/installation-rpm.sgml @@ -4,7 +4,7 @@ Installation from RPM This chapter describes the installation - of Pgpool-II from PRM. If you are + of Pgpool-II from RPM. If you are going to install from the source code, please check . diff --git a/doc/src/sgml/installation.sgml b/doc/src/sgml/installation.sgml index 1167e47..c8c8730 100644 --- a/doc/src/sgml/installation.sgml +++ b/doc/src/sgml/installation.sgml @@ -63,7 +63,7 @@ Although it is possible to use only one Pgpool-II, we recommend to use more than 1 Pgpool-II to avoid whole - database inavailability due to the + database unavailability due to the Pgpool-II being down. Multiple Pgpool-II work together and monitor each other. One of them is called "master" and it has a virtual @@ -76,7 +76,7 @@ Since it is not allowed to have multiple master, watchdog votes to - deicude a new master. If there are even number of + decide a new master. If there are even number of Pgpool-II, it is impossible to decide the new master by voting. Thus we recommend to deploy Pgpool-II in more than 3 odd numbers. @@ -95,7 +95,7 @@ PostgreSQL in streaming replication mode in for those who want to have a production level Pgpool-II - installtion today. + installation today. @@ -358,10 +358,10 @@ Pgpool-II need function of pgpool_recovery, pgpool_remote_start and pgpool_switch_xlog, - when you use the online recovery that discribes latter. + when you use the online recovery that describes latter. Also pgpoolAdmin of management tool, stop, restart or reload a PostgreSQL on the screen by use pgpool_pgctl. - It is enough, if these function installed in template1 fisrt. These + It is enough, if these function installed in template1 first. These function do not needed that install in all databases. diff --git a/doc/src/sgml/loadbalance.sgml b/doc/src/sgml/loadbalance.sgml index ff5c444..07704a2 100644 --- a/doc/src/sgml/loadbalance.sgml +++ b/doc/src/sgml/loadbalance.sgml @@ -181,7 +181,7 @@ - COPY TO STODUT + COPY TO STDOUT @@ -207,7 +207,7 @@ - If writing queires appear, succeeding read queries may not be + If writing queries appear, succeeding read queries may not be load balanced. i.e. sent to primary node (in streaming replication mode) or master node (in other mode) depending on the setting of . @@ -657,7 +657,7 @@ - SQL including table_nama3 + SQL including table_name3 @@ -864,13 +864,13 @@ - JDBC driver postgreSQL-9.3 and earlier versions + JDBC driver PostgreSQL-9.3 and earlier versions does not send the application name in the startup packet even if the application name is specified using the JDBC driver option "ApplicationName" and "assumeMinServerVersion=9.0". So if you want to use the - feature through JDBC, Use postgreSQL-9.4 or later version of the driver. + feature through JDBC, Use PostgreSQL-9.4 or later version of the driver. diff --git a/doc/src/sgml/memcache.sgml b/doc/src/sgml/memcache.sgml index dea6a5d..48edf30 100644 --- a/doc/src/sgml/memcache.sgml +++ b/doc/src/sgml/memcache.sgml @@ -421,7 +421,7 @@ - memqcache_cache_block_size must be set to atleast 512. + memqcache_cache_block_size must be set to at least 512. diff --git a/doc/src/sgml/misc-config.sgml b/doc/src/sgml/misc-config.sgml index 0928d13..2e5a68d 100644 --- a/doc/src/sgml/misc-config.sgml +++ b/doc/src/sgml/misc-config.sgml @@ -17,7 +17,7 @@ Specifies the relation cache expiration time in seconds. The relation cache is used for caching the query result of PostgreSQL system catalogs that is used by Pgpool-II - to get various informations including the table + to get various information including the table structures and to check table types(e.g. To check if the referred table is a temporary table or not). The cache is maintained in the local memory space of Pgpool-II @@ -115,7 +115,7 @@ relcache_query_target (enum) - relache_query_target configuration parameter + relcache_query_target configuration parameter @@ -136,7 +136,7 @@ standby because it's much geographically closer. In this case you can set backend_weight0 (this represents primary) to 0, backend_weight1 to 1 (this represents standby) and set - relache_query_target + relcache_query_target to load_balance_node. @@ -188,7 +188,7 @@ - For a backward compatibily sake for 4.0 or + For a backward compatibility sake for 4.0 or before, Pgpool-II accepts on, which is same as catalog and off, diff --git a/doc/src/sgml/online-recovery.sgml b/doc/src/sgml/online-recovery.sgml index 9a713e4..9cd2471 100644 --- a/doc/src/sgml/online-recovery.sgml +++ b/doc/src/sgml/online-recovery.sgml @@ -64,7 +64,7 @@ . - Connections from cliens are not allowed only in the second stage + Connections from clients are not allowed only in the second stage while the data can be updated or retrieved during the first stage. @@ -313,7 +313,7 @@ database cluster directory for security reasons. For example, if recovery_2nd_stage_command = 'sync-command', then Pgpool-II will - look for the command scrit in $PGDATA directory and will + look for the command script in $PGDATA directory and will try to execute $PGDATA/sync-command. diff --git a/doc/src/sgml/performance.sgml b/doc/src/sgml/performance.sgml index 09a93ef..3f7594e 100644 --- a/doc/src/sgml/performance.sgml +++ b/doc/src/sgml/performance.sgml @@ -32,7 +32,7 @@ in Pgpool-II: shared memory and process private memory. The former is allocated at the startup of Pgpool-II main server process - and will not be freeed until + and will not be freed until whole Pgpool-II servers shut down. The latter is allocated within each Pgpool-II child process and @@ -43,7 +43,7 @@ Shared Memory Requirement - Here is a fomula to calculate the shared memory requirement. + Here is a formula to calculate the shared memory requirement. Shared memory requirement (in bytes) = * * 17408 @@ -67,7 +67,7 @@ Process Memory Requirement - Here is a fomula to calculate the process memory requirement. + Here is a formula to calculate the process memory requirement. Process memory requirement in total (in mega bytes) = * 5 @@ -105,8 +105,8 @@ limit. There are several ways to deal with this problem. - - Controling num_init_children + + Controlling num_init_children The obvious way to deal with the problem is increasing the number of child process. This can be done by @@ -130,8 +130,8 @@ - - Controling listen_backlog_multiplier + + Controlling listen_backlog_multiplier Another solution would be increasing the connection request queue. This could be done by @@ -194,7 +194,7 @@ the ratio specified by 0 and 1. If those two values are - eqaul, the chance each node is chosen will be even. + equal, the chance each node is chosen will be even. @@ -266,9 +266,9 @@ or is set to off, sometimes Pgpool-II needs to ask PostgreSQL to get meta - information, such as whether a table is a temporay one or + information, such as whether a table is a temporary one or not. To get those - information, Pgpool-II sends queires + information, Pgpool-II sends queries primary PostgreSQL which could be up to as many as 10 queries (in 4.1 or after, the number of queries has been decreased, it is not zero, however). To reduce the diff --git a/doc/src/sgml/ref/pcp_detach_node.sgml b/doc/src/sgml/ref/pcp_detach_node.sgml index e67563e..cf269db 100644 --- a/doc/src/sgml/ref/pcp_detach_node.sgml +++ b/doc/src/sgml/ref/pcp_detach_node.sgml @@ -17,7 +17,7 @@ Pgpool-II documentation pcp_detach_node - detaches the given node from Pgpool-II. Exisiting connections to Pgpool-II are forced to be disconnected. + detaches the given node from Pgpool-II. Existing connections to Pgpool-II are forced to be disconnected. @@ -33,7 +33,7 @@ Pgpool-II documentation Description pcp_detach_node - detaches the given node from Pgpool-II. Exisiting connections to Pgpool-II are forced to be disconnected. + detaches the given node from Pgpool-II. Existing connections to Pgpool-II are forced to be disconnected. diff --git a/doc/src/sgml/ref/pcp_watchdog_info.sgml b/doc/src/sgml/ref/pcp_watchdog_info.sgml index b4d42e5..088a9df 100644 --- a/doc/src/sgml/ref/pcp_watchdog_info.sgml +++ b/doc/src/sgml/ref/pcp_watchdog_info.sgml @@ -52,7 +52,7 @@ Pgpool-II documentation Index 0 gets one's self watchdog information. - If ommitted then gets information of all watchdog nodes. + If omitted then gets information of all watchdog nodes. diff --git a/doc/src/sgml/ref/pgpool.sgml b/doc/src/sgml/ref/pgpool.sgml index 978dab8..1665303 100644 --- a/doc/src/sgml/ref/pgpool.sgml +++ b/doc/src/sgml/ref/pgpool.sgml @@ -100,7 +100,7 @@ Pgpool-II documentation Set the path to the .pgpoolkey file. - Mandatory if you use AES256 encrypted password and the file is placed other than the standard locatiaon and used. + Mandatory if you use AES256 encrypted password and the file is placed other than the standard location and used. @@ -229,7 +229,7 @@ Pgpool-II documentation Reload configuration file of Pgpool-II. No specific options - exist for realod mode. Common options are applicable. + exist for reload mode. Common options are applicable. diff --git a/doc/src/sgml/ref/show_pool_nodes.sgml b/doc/src/sgml/ref/show_pool_nodes.sgml index 10b6107..2b1891a 100644 --- a/doc/src/sgml/ref/show_pool_nodes.sgml +++ b/doc/src/sgml/ref/show_pool_nodes.sgml @@ -35,9 +35,9 @@ hostname, the port, the status, the weight (only meaningful if you use the load balancing mode), the role, the SELECT query counts issued to each backend, whether each node is the load - bakance node or not, the replication delay (only if in streaming + balance node or not, the replication delay (only if in streaming replication mode) and last status change time. In addition to - this replicatin state and sync state are shown for standby nodes + this replication state and sync state are shown for standby nodes in Pgpool-II 4.1 or after. The possible values in the status column are explained in the reference. If the hostname is diff --git a/doc/src/sgml/reference.sgml b/doc/src/sgml/reference.sgml index c8b4be2..0ceaec1 100644 --- a/doc/src/sgml/reference.sgml +++ b/doc/src/sgml/reference.sgml @@ -189,7 +189,7 @@ to PostgreSQL with the result (3). PostgreSQL returns the result to Pgpool-II (5) - and Pgpool-II fowards the data to + and Pgpool-II forwards the data to the user (6). @@ -214,7 +214,7 @@ of PostgreSQL. The pcp port number is hard coded as 9898, the pcp user name is assumes to be same as caller's PostgreSQL user name. - password is extraced from $HOME/.pcppass. + password is extracted from $HOME/.pcppass. diff --git a/doc/src/sgml/release-3.2.sgml b/doc/src/sgml/release-3.2.sgml index ecb5816..4b446f3 100644 --- a/doc/src/sgml/release-3.2.sgml +++ b/doc/src/sgml/release-3.2.sgml @@ -216,7 +216,7 @@ - This status mismatch should be fixe by pcp_promote_node, but when the node + This status mismatch should be fixed by pcp_promote_node, but when the node is the master node (the first alive node), it fails as mentioned above. @@ -299,7 +299,7 @@ 2016-12-28 [afebadf] --> - Fix authentication timeout that can occur right after client connecttions. (Yugo Nagata) + Fix authentication timeout that can occur right after client connections. (Yugo Nagata) diff --git a/doc/src/sgml/release-3.3.sgml b/doc/src/sgml/release-3.3.sgml index cb3342c..38a376a 100644 --- a/doc/src/sgml/release-3.3.sgml +++ b/doc/src/sgml/release-3.3.sgml @@ -133,7 +133,7 @@ Change the pgpool.service and sysconfig files to output Pgpool-II log. (Bo Peng) - Removeing "Type=forking" and add OPTS=" -n" to + Removing "Type=forking" and add OPTS=" -n" to run Pgpool-II with non-daemon mode, because we need to redirect logs. Using "journalctl" command to see Pgpool-II systemd log. @@ -167,7 +167,7 @@ frontend. In most cases this is good. However if other than primary node or master node returns an error state (this could happen if load balance node is other than primary or master node and the query is an - errornous SELECT), this should be returned to frontend, because the + erroneous SELECT), this should be returned to frontend, because the frontend already received an error. @@ -208,7 +208,7 @@ Fix bug mistakenly overriding global backend status right after failover. (Tatsuo Ishii) - See [pgpool-general: 5728] for mor details. + See [pgpool-general: 5728] for more details. @@ -416,7 +416,7 @@ 2017-03-24 [dab2ff0] --> - Fix for 0000296: PGPool v3.6.2 terminated by systemd because the service Type has been set to 'forking'. + Fix for 0000296: Pgpool v3.6.2 terminated by systemd because the service Type has been set to 'forking'. (Bug 296) (Muhammad Usama) @@ -476,7 +476,7 @@ - This status mismatch should be fixe by pcp_promote_node, but when the node + This status mismatch should be fixed by pcp_promote_node, but when the node is the master node (the first alive node), it fails as mentioned above. @@ -589,7 +589,7 @@ 2016-12-28 [afebadf] --> - Fix authentication timeout that can occur right after client connecttions. (Yugo Nagata) + Fix authentication timeout that can occur right after client connections. (Yugo Nagata) diff --git a/doc/src/sgml/release-3.4.sgml b/doc/src/sgml/release-3.4.sgml index 82dc781..938534a 100644 --- a/doc/src/sgml/release-3.4.sgml +++ b/doc/src/sgml/release-3.4.sgml @@ -239,7 +239,7 @@ (bug 487) (Bo Peng) - When all backend nodes are down, Pgpool-II throws an uncorrect + When all backend nodes are down, Pgpool-II throws an incorrect error message "ERROR: connection cache is full". Change the error message to "all backend nodes are down, pgpool requires at least one valid node". @@ -474,7 +474,7 @@ If order of startup packet's parameters differ between cached connection - pools and connection request, did't use connection pool ,and created new + pools and connection request, didn't use connection pool ,and created new connection pool. @@ -635,7 +635,7 @@ In a explicit transaction, the SELECT results are cached in temporary buffer. - If a write SQL is sent which modifies the table, the temporary buffe should be reset. + If a write SQL is sent which modifies the table, the temporary buffer should be reset. @@ -979,7 +979,7 @@ Change the pgpool.service and sysconfig files to output Pgpool-II log. (Bo Peng) - Removeing "Type=forking" and add OPTS=" -n" to + Removing "Type=forking" and add OPTS=" -n" to run Pgpool-II with non-daemon mode, because we need to redirect logs. Using "journalctl" command to see Pgpool-II systemd log. @@ -1013,7 +1013,7 @@ frontend. In most cases this is good. However if other than primary node or master node returns an error state (this could happen if load balance node is other than primary or master node and the query is an - errornous SELECT), this should be returned to frontend, because the + erroneous SELECT), this should be returned to frontend, because the frontend already received an error. @@ -1072,7 +1072,7 @@ Fix bug mistakenly overriding global backend status right after failover. (Tatsuo Ishii) - See [pgpool-general: 5728] for mor details. + See [pgpool-general: 5728] for more details. @@ -1326,7 +1326,7 @@ 2017-03-24 [1172e6c] --> - Fix for 0000296: PGPool v3.6.2 terminated by systemd because the service Type has been set to 'forking'. + Fix for 0000296: Pgpool v3.6.2 terminated by systemd because the service Type has been set to 'forking'. (Bug 296) (Muhammad Usama) @@ -1385,7 +1385,7 @@ - This status mismatch should be fixe by pcp_promote_node, but when the node + This status mismatch should be fixed by pcp_promote_node, but when the node is the master node (the first alive node), it fails as mentioned above. @@ -1572,7 +1572,7 @@ 2016-12-28 [afebadf] --> - Fix authentication timeout that can occur right after client connecttions. (Yugo Nagata) + Fix authentication timeout that can occur right after client connections. (Yugo Nagata) diff --git a/doc/src/sgml/release-3.5.sgml b/doc/src/sgml/release-3.5.sgml index cb4eec9..d8bad63 100644 --- a/doc/src/sgml/release-3.5.sgml +++ b/doc/src/sgml/release-3.5.sgml @@ -16,7 +16,7 @@ 2020-01-28 [d60e6b7] --> - Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failire. (Bo Peng) + Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failure. (Bo Peng) @@ -262,7 +262,7 @@ 2019-07-03 [380d8a5] --> - Fix sefault when query cache is enabled. (bug 525) (Tatsuo Ishii) + Fix segfault when query cache is enabled. (bug 525) (Tatsuo Ishii) @@ -376,7 +376,7 @@ (bug 487) (Bo Peng) - When all backend nodes are down, Pgpool-II throws an uncorrect + When all backend nodes are down, Pgpool-II throws an incorrect error message "ERROR: connection cache is full". Change the error message to "all backend nodes are down, pgpool requires at least one valid node". @@ -654,7 +654,7 @@ If order of startup packet's parameters differ between cached connection - pools and connection request, did't use connection pool ,and created new + pools and connection request, didn't use connection pool ,and created new connection pool. @@ -859,7 +859,7 @@ In a explicit transaction, the SELECT results are cached in temporary buffer. - If a write SQL is sent which modifies the table, the temporary buffe should be reset. + If a write SQL is sent which modifies the table, the temporary buffer should be reset. @@ -1298,7 +1298,7 @@ Change the pgpool.service and sysconfig files to output Pgpool-II log. (Bo Peng) - Removeing "Type=forking" and add OPTS=" -n" to + Removing "Type=forking" and add OPTS=" -n" to run Pgpool-II with non-daemon mode, because we need to redirect logs. Using "journalctl" command to see Pgpool-II systemd log. @@ -1384,7 +1384,7 @@ frontend. In most cases this is good. However if other than primary node or master node returns an error state (this could happen if load balance node is other than primary or master node and the query is an - errornous SELECT), this should be returned to frontend, because the + erroneous SELECT), this should be returned to frontend, because the frontend already received an error. @@ -1497,7 +1497,7 @@ Fix bug mistakenly overriding global backend status right after failover. (Tatsuo Ishii) - See [pgpool-general: 5728] for mor details. + See [pgpool-general: 5728] for more details. @@ -1558,7 +1558,7 @@ 2017-09-01 [ad90886] --> - Fix wd_authkey bug in that a request to add new node to the clusetr is rejected by master. (Yugo Nagata) + Fix wd_authkey bug in that a request to add new node to the cluster is rejected by master. (Yugo Nagata) This is a bug due to the implementation of 3.5.6 and 3.6.3. @@ -1850,10 +1850,10 @@ 2017-06-09 [b86e7b7] --> - Fix a posible hang with streaming replication and extended protocol (Yugo Nagata) + Fix a possible hang with streaming replication and extended protocol (Yugo Nagata) - This hang occured under a certain condition. The following is an example. + This hang occurred under a certain condition. The following is an example. @@ -1864,7 +1864,7 @@ - Without using JDBC, we can reproduce the problem by pgproto with the followeing messages. + Without using JDBC, we can reproduce the problem by pgproto with the following messages. @@ -2271,7 +2271,7 @@ 2017-03-24 [d726c3a] --> - Fix for 0000296: PGPool v3.6.2 terminated by systemd because the service Type has been set to 'forking'. + Fix for 0000296: Pgpool v3.6.2 terminated by systemd because the service Type has been set to 'forking'. (Bug 296) (Muhammad Usama) @@ -2330,7 +2330,7 @@ - This status mismatch should be fixe by pcp_promote_node, but when the node + This status mismatch should be fixed by pcp_promote_node, but when the node is the master node (the first alive node), it fails as mentioned above. @@ -2584,7 +2584,7 @@ 2016-12-28 [afebadf] --> - Fix authentication timeout that can occur right after client connecttions. (Yugo Nagata) + Fix authentication timeout that can occur right after client connections. (Yugo Nagata) @@ -2689,7 +2689,7 @@ - Pgool-II forward it to backend 1 + Pgpool-II forward it to backend 1 @@ -2699,7 +2699,7 @@ - Pgool-II forward it to backend 0 & 1 + Pgpool-II forward it to backend 0 & 1 @@ -2709,7 +2709,7 @@ - Pgool-II forward it to backend 0 & 1 + Pgpool-II forward it to backend 0 & 1 diff --git a/doc/src/sgml/release-3.6.sgml b/doc/src/sgml/release-3.6.sgml index 4633c27..a3c8b37 100644 --- a/doc/src/sgml/release-3.6.sgml +++ b/doc/src/sgml/release-3.6.sgml @@ -16,7 +16,7 @@ 2020-01-28 [d60e6b7] --> - Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failire. (Bo Peng) + Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failure. (Bo Peng) @@ -337,7 +337,7 @@ 2019-07-03 [380d8a5] --> - Fix sefault when query cache is enabled. (bug 525) (Tatsuo Ishii) + Fix segfault when query cache is enabled. (bug 525) (Tatsuo Ishii) @@ -490,7 +490,7 @@ (bug 487) (Bo Peng) - When all backend nodes are down, Pgpool-II throws an uncorrect + When all backend nodes are down, Pgpool-II throws an incorrect error message "ERROR: connection cache is full". Change the error message to "all backend nodes are down, pgpool requires at least one valid node". @@ -828,7 +828,7 @@ If order of startup packet's parameters differ between cached connection - pools and connection request, did't use connection pool ,and created new + pools and connection request, didn't use connection pool ,and created new connection pool. @@ -1070,7 +1070,7 @@ In a explicit transaction, the SELECT results are cached in temporary buffer. - If a write SQL is sent which modifies the table, the temporary buffe should be reset. + If a write SQL is sent which modifies the table, the temporary buffer should be reset. @@ -1675,7 +1675,7 @@ Change the pgpool.service and sysconfig files to output Pgpool-II log. (Bo Peng) - Removeing "Type=forking" and add OPTS=" -n" to + Removing "Type=forking" and add OPTS=" -n" to run Pgpool-II with non-daemon mode, because we need to redirect logs. Using "journalctl" command to see Pgpool-II systemd log. @@ -1785,7 +1785,7 @@ frontend. In most cases this is good. However if other than primary node or master node returns an error state (this could happen if load balance node is other than primary or master node and the query is an - errornous SELECT), this should be returned to frontend, because the + erroneous SELECT), this should be returned to frontend, because the frontend already received an error. @@ -1907,7 +1907,7 @@ Fix bug mistakenly overriding global backend status right after failover. (Tatsuo Ishii) - See [pgpool-general: 5728] for mor details. + See [pgpool-general: 5728] for more details. @@ -1977,7 +1977,7 @@ 2017-09-01 [b661a8b] --> - Fix wd_authkey bug in that a request to add new node to the clusetr is rejected by master. (Yugo Nagata) + Fix wd_authkey bug in that a request to add new node to the cluster is rejected by master. (Yugo Nagata) This is a bug due to the implementation of 3.5.6 and 3.6.3. @@ -2203,7 +2203,7 @@ 2017-08-21 [1812a84] --> - Doc: Add new English and Japanese documents of Pgpoo-II + Watchdog Setup Example. (Bo Peng) + Doc: Add new English and Japanese documents of Pgpool-II + Watchdog Setup Example. (Bo Peng) @@ -2289,11 +2289,11 @@ 2017-06-09 [d9b0b83] --> - Fix a posible hang with streaming replication and extended protocol. (Yugo Nagata) + Fix a possible hang with streaming replication and extended protocol. (Yugo Nagata) - This hang occured under a certain condition. The following is an example. + This hang occurred under a certain condition. The following is an example. @@ -2304,7 +2304,7 @@ - Without using JDBC, we can reproduce the problem by pgproto with the followeing messages. + Without using JDBC, we can reproduce the problem by pgproto with the following messages. @@ -2587,7 +2587,7 @@ 2017-04-14 [50fb9a4] --> - Removing the function defined but not used warnings from pool_config_vatiable.c (Muhammad Usama) + Removing the function defined but not used warnings from pool_config_variable.c (Muhammad Usama) @@ -2843,7 +2843,7 @@ 2017-03-24 [c2a0cc5] --> - Fix for 0000296: PGPool v3.6.2 terminated by systemd because the service Type has been set to 'forking'. + Fix for 0000296: Pgpool v3.6.2 terminated by systemd because the service Type has been set to 'forking'. (Bug 296) (Muhammad Usama) @@ -2903,7 +2903,7 @@ - This status mismatch should be fixe by pcp_promote_node, but when the node + This status mismatch should be fixed by pcp_promote_node, but when the node is the master node (the first alive node), it fails as mentioned above. @@ -3158,7 +3158,7 @@ 2016-12-28 [afebadf] --> - Fix authentication timeout that can occur right after client connecttions. (Yugo Nagata) + Fix authentication timeout that can occur right after client connections. (Yugo Nagata) @@ -3261,7 +3261,7 @@ - Pgool-II forward it to backend 1 + Pgpool-II forward it to backend 1 @@ -3271,7 +3271,7 @@ - Pgool-II forward it to backend 0 & 1 + Pgpool-II forward it to backend 0 & 1 @@ -3281,7 +3281,7 @@ - Pgool-II forward it to backend 0 & 1 + Pgpool-II forward it to backend 0 & 1 @@ -3557,7 +3557,7 @@ restart. Watchdog not syncing status. --> - Sync inconsitent status + Sync inconsistent status of PostgreSQL nodes in Pgpool-II instances after restart. (bug 218) (Muhammad Usama) @@ -3691,7 +3691,7 @@ 2016-08-18 [d3211dc] Let watchdog_setup to be installed. --> - Add new script called "watchdog_setup". (Tatstuo Ishii) + Add new script called "watchdog_setup". (Tatsuo Ishii) is a command to create a @@ -3742,7 +3742,7 @@ Do not update status file if all backend nodes are in down status. (Chris Pacejo, Tatsuo Ishii) - This commit tries to remove the data inconsitency in + This commit tries to remove the data inconsistency in replication mode found in [pgpool-general: 3918] by not recording the status file when all @@ -3839,7 +3839,7 @@ --> Change the default value of - from 10 to 300. (Tatstuo Ishii) + from 10 to 300. (Tatsuo Ishii) Prior default value 10 seconds is sometimes too short for a standby to @@ -4081,10 +4081,10 @@ - Fix Pgpool-II doesn't escalate ip in case of another node inavailability. (bug 215) (Muhammad Usama) + Fix Pgpool-II doesn't escalate ip in case of another node unavailability. (bug 215) (Muhammad Usama) The heartbeat receiver fails to identify the heartbeat sender watchdog node when @@ -4260,16 +4260,16 @@ - Fix a posible hang during health checking. (bug 204) (Yugo Nagata) + Fix a possible hang during health checking. (bug 204) (Yugo Nagata) - Helath checking was hang when any data wasn't sent + Health checking was hang when any data wasn't sent from backend after connect(2) succeeded. To fix this, pool_check_fd() returns 1 when select(2) exits with - EINTR due to SIGALRM while health checkking is performed. + EINTR due to SIGALRM while health checking is performed. @@ -4348,13 +4348,13 @@ - Fix Japanese and Chinese documetation bug about raw mode. (Yugo Nagata, Bo Peng) + Fix Japanese and Chinese documentation bug about raw mode. (Yugo Nagata, Bo Peng) - Connection pool is avalilable in raw mode. + Connection pool is available in raw mode. @@ -4464,7 +4464,7 @@ Fix pgpool hung after receiving error state from backend. (bug #169) (Tatsuo Ishii) - This could happend if we execute an extended protocol query and it + This could happen if we execute an extended protocol query and it fails. @@ -4473,7 +4473,7 @@ 2016-03-03 [bb295a2] Fix query stack problems in extended protocol case. --> - Fix query stack problems in extended protocol case. (bug 167, 168) (Tatstuo Ishii) + Fix query stack problems in extended protocol case. (bug 167, 168) (Tatsuo Ishii) @@ -4520,10 +4520,10 @@ - Fix compile issue on freebsd. (Muhammad Usama) + Fix compile issue on FreeBSD. (Muhammad Usama) Add missing include files. The patch is contributed by @@ -4547,7 +4547,7 @@ Sometimes calculation fails for some reason other than - authkey mismatch. The additional messages make these distingushable + authkey mismatch. The additional messages make these distinguishable for each other. diff --git a/doc/src/sgml/release-3.7.sgml b/doc/src/sgml/release-3.7.sgml index deebc88..452d62c 100644 --- a/doc/src/sgml/release-3.7.sgml +++ b/doc/src/sgml/release-3.7.sgml @@ -35,7 +35,7 @@ 2020-01-28 [abbba81] --> - Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failire. (Bo Peng) + Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failure. (Bo Peng) @@ -262,7 +262,7 @@ 2019-09-04 [3ba4e73] --> - Doc: mention that VIP will not be brougt up if quorum does not exist. (Tatsuo Ishii) + Doc: mention that VIP will not be brought up if quorum does not exist. (Tatsuo Ishii) @@ -467,7 +467,7 @@ 2019-07-03 [380d8a5] --> - Fix sefault when query cache is enabled. (bug 525) (Tatsuo Ishii) + Fix segfault when query cache is enabled. (bug 525) (Tatsuo Ishii) @@ -631,7 +631,7 @@ (bug 487) (Bo Peng) - When all backend nodes are down, Pgpool-II throws an uncorrect + When all backend nodes are down, Pgpool-II throws an incorrect error message "ERROR: connection cache is full". Change the error message to "all backend nodes are down, pgpool requires at least one valid node". @@ -996,7 +996,7 @@ If order of startup packet's parameters differ between cached connection - pools and connection request, did't use connection pool ,and created new + pools and connection request, didn't use connection pool ,and created new connection pool. @@ -1237,7 +1237,7 @@ In a explicit transaction, the SELECT results are cached in temporary buffer. - If a write SQL is sent which modifies the table, the temporary buffe should be reset. + If a write SQL is sent which modifies the table, the temporary buffer should be reset. @@ -2085,7 +2085,7 @@ Change the pgpool.service and sysconfig files to output Pgpool-II log. (Bo Peng) - Removeing "Type=forking" and add OPTS=" -n" to + Removing "Type=forking" and add OPTS=" -n" to run Pgpool-II with non-daemon mode, because we need to redirect logs. Using "journalctl" command to see Pgpool-II systemd log. @@ -2225,7 +2225,7 @@ frontend. In most cases this is good. However if other than primary node or master node returns an error state (this could happen if load balance node is other than primary or master node and the query is an - errornous SELECT), this should be returned to frontend, because the + erroneous SELECT), this should be returned to frontend, because the frontend already received an error. @@ -2587,7 +2587,7 @@ 2017-09-19 [34922b5] --> - Test: Add new test 011.watchdoc_quorum_failover. (Tatsuo Ishii) + Test: Add new test 011.watchdog_quorum_failover. (Tatsuo Ishii) diff --git a/doc/src/sgml/release-4.0.sgml b/doc/src/sgml/release-4.0.sgml index a92285b..818ec8a 100644 --- a/doc/src/sgml/release-4.0.sgml +++ b/doc/src/sgml/release-4.0.sgml @@ -35,7 +35,7 @@ 2020-01-28 [304e091] --> - Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failire. (Bo Peng) + Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failure. (Bo Peng) @@ -93,7 +93,7 @@ 2020-01-28 [f8bbd91] --> - Doc: Change the sample follow_master_command script %M %H paramater's order. (Bo Peng) + Doc: Change the sample follow_master_command script %M %H parameter's order. (Bo Peng) @@ -303,7 +303,7 @@ 2019-09-04 [3ba4e73] --> - Doc: mention that VIP will not be brougt up if quorum does not exist. (Tatsuo Ishii) + Doc: mention that VIP will not be brought up if quorum does not exist. (Tatsuo Ishii) @@ -550,7 +550,7 @@ 2019-07-03 [5d042e4] --> - Fix sefault when query cache is enabled. (bug 525) (Tatsuo Ishii) + Fix segfault when query cache is enabled. (bug 525) (Tatsuo Ishii) @@ -1337,7 +1337,7 @@ Overview - This version addes support for SCRAM and CERT authentication, + This version adds support for SCRAM and CERT authentication, improves load balancing control and import PostgreSQL 11 new SQL parser. diff --git a/doc/src/sgml/release-4.1.sgml b/doc/src/sgml/release-4.1.sgml index 20c735b..54c5256 100644 --- a/doc/src/sgml/release-4.1.sgml +++ b/doc/src/sgml/release-4.1.sgml @@ -35,7 +35,7 @@ 2020-01-28 [b0b52ef] --> - Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failire. (Bo Peng) + Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failure. (Bo Peng) @@ -114,7 +114,7 @@ 2020-01-10 [d0252d8] --> - Doc: Change the sample follow_master_command script %M %H paramater's order. (Bo Peng) + Doc: Change the sample follow_master_command script %M %H parameter's order. (Bo Peng) @@ -301,7 +301,7 @@ Add parameter to configure - majority rule calculations. (Muhammd Usama, Tatsuo Ishii) + majority rule calculations. (Muhammad Usama, Tatsuo Ishii) This changes the behavior of the decision of quorum existence and @@ -310,7 +310,7 @@ affected. When this parameter is off (the default), a 2 node watchdog cluster needs to have both 2 nodes are alive to have a quorum. If the quorum does not exist and 1 node goes down, then - 1) VIP will be lost, 2) failover srcript is not executed and 3) + 1) VIP will be lost, 2) failover script is not executed and 3) no watchdog master exists. Especially #2 could be troublesome because no new primary PostgreSQL exists if existing primary goes down. Probably 2 node watchdog @@ -486,7 +486,7 @@ --> Performance enhancements for the large INSERT and UPDATE - statements. (Muhammd Usama) + statements. (Muhammad Usama) Pgpool-II only needs very little @@ -529,7 +529,7 @@ Import PostgreSQL 12 beta2 new parser. (Bo Peng) - Major chanegs of PostgreSQL 12 parser include: + Major changes of PostgreSQL 12 parser include: @@ -607,7 +607,7 @@ we set = transaction, when a write query is issued inside an explicit truncation, subsequent queries should be - sent to primary only until the end of this transactionin in + sent to primary only until the end of this transaction in order to avoid the replication delay. However, the SELECTs having write functions specified in or not specified @@ -810,7 +810,7 @@ --> Resign the master watchdog node from master responsibilities if - the primary backend node gets into quarantine state on that. (Muhammd Usama) + the primary backend node gets into quarantine state on that. (Muhammad Usama) By doing this, we could avoid the situation on which there's no @@ -841,7 +841,7 @@ Add parameter to configure - majority rule calculations. (Muhammd Usama, Tatsuo Ishii) + majority rule calculations. (Muhammad Usama, Tatsuo Ishii) Pgpool-II takes the decision of quorum @@ -939,8 +939,7 @@ Mention that schema qualifications cannot be used in - Add performance chapterwhite/black_function_list. (tatsuo - Ishii) + white/black_function_list. (tatsuo Ishii) diff --git a/doc/src/sgml/ssl.sgml b/doc/src/sgml/ssl.sgml index c7a2693..0800d15 100644 --- a/doc/src/sgml/ssl.sgml +++ b/doc/src/sgml/ssl.sgml @@ -1,7 +1,7 @@ - Secure Sockect Layer (SSL) + Secure Socket Layer (SSL) @@ -208,7 +208,7 @@ Specifies the name of the file containing Diffie-Hellman parameters - used for so-called ephemeral DH family of SSl ciphers. The default is + used for so-called ephemeral DH family of SSL ciphers. The default is empty. In which case compiled-in default DH parameters used. Using Custom DH parameters reduces the exposure if an attacker manages to crack the well-known compiled-in DH parameters. You can create your own diff --git a/doc/src/sgml/start.sgml b/doc/src/sgml/start.sgml index 7e6a595..9ca51ba 100644 --- a/doc/src/sgml/start.sgml +++ b/doc/src/sgml/start.sgml @@ -30,7 +30,7 @@ Before going further, you should properly set up pgpool.conf with streaming replication - mode. Sample configulations are provided with + mode. Sample configurations are provided with Pgpool-II, there configuration file are located at /usr/local/etc with default installation from source code. you can copy @@ -335,7 +335,7 @@ installation. The argument -p is to specify the port number assigned to the command, which is 11001 set by pgpool_setup. The argument -n is to - specify the node id to be receovered. After executing the command, + specify the node id to be recovered. After executing the command, node 0 returned to "up" status. @@ -435,7 +435,7 @@
- Process architecure of <productname>Pgpool-II</productname> + Process architecture of <productname>Pgpool-II</productname> diff --git a/doc/src/sgml/stream-check.sgml b/doc/src/sgml/stream-check.sgml index 9bbd9b1..5eaf45d 100644 --- a/doc/src/sgml/stream-check.sgml +++ b/doc/src/sgml/stream-check.sgml @@ -193,7 +193,7 @@ - This parameter can be changed by reloading the Pgpool-II configurations. + This parameter can be changed by reloading the Pgpool-IIconfigurations. diff --git a/doc/src/sgml/watchdog.sgml b/doc/src/sgml/watchdog.sgml index f46e73d..b7da5e8 100644 --- a/doc/src/sgml/watchdog.sgml +++ b/doc/src/sgml/watchdog.sgml @@ -309,7 +309,7 @@ - Behaivor on escalation and de-escalation + Behaviour on escalation and de-escalation Configuration about behavior when Pgpool-II @@ -327,8 +327,8 @@ When set to on, watchdog clears all the query cache in the shared memory - when pgpool-II escaltes to active. This prevents the new active Pgpool-II - from using old query caches inconsistence to the old active. + when pgpool-II escalates to active. This prevents the new active Pgpool-II + from using old query caches inconsistent to the old active. Default is on. @@ -488,7 +488,7 @@ automatically re-attached. - From Pgpool-II V4.1 onwards, if the watchdog-master node + From Pgpool-II V4.1 onward, if the watchdog-master node fails to build the consensus for primary backend node failover and the primary backend node gets into a quarantine state, then it resigns from its master/coordinator responsibilities and lowers its wd_priority for next leader election and let the cluster elect some different new leader.