diff --git a/doc/src/sgml/advanced.sgml b/doc/src/sgml/advanced.sgml index 1bbc16e..35c3b0b 100644 --- a/doc/src/sgml/advanced.sgml +++ b/doc/src/sgml/advanced.sgml @@ -9,14 +9,14 @@ Watchdog is a sub process of Pgpool-II to add high 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 + point of failure by coordinating multiple Pgpool-II + nodes. The watchdog was first introduced in Pgpool-II V3.2 and is significantly enhanced in - pgpool-II V3.5, to ensure the presence of a + Pgpool-II V3.5, to ensure the presence of a quorum at all time. This new addition to watchdog makes it more fault tolerant and robust in handling and guarding against the split-brain syndrome and network partitioning. However to ensure the quorum mechanism properly - works, the number of pgpool-II nodes must be odd in number and greater than or + works, the number of Pgpool-II nodes must be odd in number and greater than or equal to 3. @@ -410,7 +410,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 @@ -516,7 +516,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 0d30821..8d633b1 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 eccb9dc..4233ac2 100644 --- a/doc/src/sgml/connection-pooling.sgml +++ b/doc/src/sgml/connection-pooling.sgml @@ -121,7 +121,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 @@ -130,8 +130,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 7699700..6f2f411 100644 --- a/doc/src/sgml/connection-settings.sgml +++ b/doc/src/sgml/connection-settings.sgml @@ -710,7 +710,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/examples.sgml b/doc/src/sgml/examples.sgml index e4c1cd7..0da47d2 100644 --- a/doc/src/sgml/examples.sgml +++ b/doc/src/sgml/examples.sgml @@ -83,7 +83,7 @@ $ cp /usr/local/etc/pgpool.conf.sample /usr/local/etc/pgpool.conf Pgpool-II only accepts connections from the localhost - using port 9999. If you wish to receive conenctions from other hosts, + using port 9999. If you wish to receive connections from other hosts, set to '*'. listen_addresses = 'localhost' @@ -523,7 +523,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 @@ -653,8 +653,8 @@ There are the parameters about watchdog's monitoring. Specify the interval to check , the count to retry , - the qyery to check and - finaly the type of lifecheck . + the query to check and + finally the type of lifecheck . wd_lifecheck_method = 'query' # Method of watchdog lifecheck ('heartbeat' or 'query' or 'external') @@ -982,7 +982,7 @@ User Name - Passowrd + Password Detail @@ -1046,7 +1046,7 @@ To allow repl user without specifying password for streaming replication and online recovery, 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. @@ -1071,7 +1071,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 /etc/pgpool-II/pgpool.conf.sample-stream /etc/pgpool-II/pgpool.conf @@ -1113,7 +1113,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. @@ -1573,7 +1573,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. @@ -1912,7 +1912,7 @@ exit 0 After executing pcp_recovery_node command, - vertify that server2 and server3 + verify that server2 and server3 are started as PostgreSQL standby server. @@ -1957,7 +1957,7 @@ exit 0 server3:9999 Linux server3 server3 9999 9000 7 STANDBY #server3 runs as STANDBY - Start Pgpool-II (server1) which we have stopped again, and vertify that server1 runs as a standby. + Start Pgpool-II (server1) which we have stopped again, and verify that server1 runs as a standby. [server1]# systemctl start pgpool.service @@ -1975,7 +1975,7 @@ exit 0 Failover - First, use psql to connect to PostgreSQL via virtual IP, and verify the backend informations. + First, use psql to connect to PostgreSQL via virtual IP, and verify the backend information. # psql -h 192.168.137.150 -p 9999 -U pgpool postgres -c "show pool_nodes" @@ -2141,7 +2141,7 @@ exit 0 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. @@ -2407,7 +2407,7 @@ exit 0 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. @@ -2431,7 +2431,7 @@ exit 0 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/failover.sgml b/doc/src/sgml/failover.sgml index 6765bcf..c95a067 100644 --- a/doc/src/sgml/failover.sgml +++ b/doc/src/sgml/failover.sgml @@ -141,7 +141,7 @@ %m - New master node ID + New master node ID %H @@ -149,7 +149,7 @@ %P - Old primary node ID + Old primary node ID %r @@ -241,7 +241,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. @@ -433,7 +433,7 @@ If follow_master_command is not empty, then after failover on the primary node gets completed in Master Slave mode with streaming replication, - Pgpool-II degenerates all nodes excepted the new primary + Pgpool-II degenerates all nodes except the new primary and starts new child processes to be ready again to accept connections from the clients. After this, Pgpool-II executes the command configured in the follow_master_command for each degenerated backend nodes. diff --git a/doc/src/sgml/installation-rpm.sgml b/doc/src/sgml/installation-rpm.sgml index 8d6fbd6..e82afb8 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/loadbalance.sgml b/doc/src/sgml/loadbalance.sgml index d59f336..5b6871a 100644 --- a/doc/src/sgml/loadbalance.sgml +++ b/doc/src/sgml/loadbalance.sgml @@ -180,7 +180,7 @@ - COPY TO STODUT + COPY TO STDOUT @@ -206,7 +206,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 . @@ -656,7 +656,7 @@ - SQL including table_nama3 + SQL including table_name3 @@ -863,13 +863,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 01fbdd2..ac9ebcc 100644 --- a/doc/src/sgml/memcache.sgml +++ b/doc/src/sgml/memcache.sgml @@ -412,7 +412,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 488f2a8..3c242d4 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 diff --git a/doc/src/sgml/online-recovery.sgml b/doc/src/sgml/online-recovery.sgml index 74f9011..4ccb26f 100644 --- a/doc/src/sgml/online-recovery.sgml +++ b/doc/src/sgml/online-recovery.sgml @@ -62,7 +62,7 @@ safely leave it as an empty string. - 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. @@ -278,14 +278,14 @@ Specifies a command to be run by master node at the second - stage of online recovery. This parameter only neccessary for + stage of online recovery. This parameter only necessary for . The command file must be placed in the 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 + command script in $PGDATA directory and will try to execute $PGDATA/sync-command. 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 1bbacb1..cf2c428 100644 --- a/doc/src/sgml/ref/show_pool_nodes.sgml +++ b/doc/src/sgml/ref/show_pool_nodes.sgml @@ -35,7 +35,7 @@ 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. 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 99f78d9..de7f643 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 7557bd8..f1a7144 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 32bbad6..7c4e1a1 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 2c653d2..fbd4e26 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 408e966..6b75f7c 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/runtime.sgml b/doc/src/sgml/runtime.sgml index 70f3509..dc2fd39 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -134,7 +134,7 @@ replication mode and raw mode. In any mode, Pgpool-II provides connection pooling, automatic fail over and online recovery. The sample - configuration files for each mode are provied. They are located + configuration files for each mode are provided. They are located under $prefix/etc. You can copy one of them to $prefix/etc/pgpool.conf. diff --git a/doc/src/sgml/ssl.sgml b/doc/src/sgml/ssl.sgml index f106009..5b95140 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) diff --git a/doc/src/sgml/start.sgml b/doc/src/sgml/start.sgml index 8f321ad..ca1415a 100644 --- a/doc/src/sgml/start.sgml +++ b/doc/src/sgml/start.sgml @@ -422,7 +422,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 2750a7e..86a98d4 100644 --- a/doc/src/sgml/stream-check.sgml +++ b/doc/src/sgml/stream-check.sgml @@ -158,7 +158,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 61ba814..b037b58 100644 --- a/doc/src/sgml/watchdog.sgml +++ b/doc/src/sgml/watchdog.sgml @@ -288,7 +288,7 @@ - Behaivor on escalation and de-escalation + Behaviour on escalation and de-escalation Configuration about behavior when Pgpool-II @@ -306,8 +306,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. @@ -410,7 +410,7 @@ and silently detaches the problematic node, So in the case when the master backend node is quarantined, the Pgpool-II will not promote the standby to take over the master responsibilities and until the master node is quarantined the Pgpool-II will not have - any useable master backend node. + any usable master backend node. Default is on.