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 37e58fe..4786445 100644 --- a/doc/src/sgml/client-auth.sgml +++ b/doc/src/sgml/client-auth.sgml @@ -11,7 +11,7 @@ Since Pgpool-II is a middleware that works between PostgreSQL servers and 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 + 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 clients, with an exceptions of the authentications on PostgreSQL side that depends on the client's IP addresses or hostnames. @@ -20,7 +20,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. --> @@ -123,7 +123,7 @@ Since Pgpool-II does not know anything about users in the PostgreSQL backend server, the database name is simply - compared against the entries in the databaseE field of pool_hba.conf. + compared against the entries in the database field of pool_hba.conf. diff --git a/doc/src/sgml/connection-pooling.sgml b/doc/src/sgml/connection-pooling.sgml index c821078..7a46b57 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 2b4a84f..e2992a2 100644 --- a/doc/src/sgml/connection-settings.sgml +++ b/doc/src/sgml/connection-settings.sgml @@ -614,7 +614,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. + so it never locks the table if it doesn't have the SERIAL columns. diff --git a/doc/src/sgml/examples.sgml b/doc/src/sgml/examples.sgml index f625077..87d6a94 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' @@ -367,7 +367,7 @@ Watchdog Configuration Example - This tutrial explains the simple way to try "Watchdog". + This tutorial explains the simple way to try "Watchdog". What you need is 2 Linux boxes on which Pgpool-II is installed and a PostgreSQL on the same machine or in the other one. It is enough @@ -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,9 +653,9 @@ 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') # (change requires restart) @@ -701,7 +701,7 @@ - <productname>Pgpoo-II</productname> + Watchdog Setup Example + <productname>Pgpool-II</productname> + Watchdog Setup Example This section shows an example of streaming replication configuration using Pgpool-II. In this example, we use 3 Pgpool-II servers to manage PostgreSQL servers to create a robust cluster system and avoid the single point of failure or split brain. @@ -741,7 +741,7 @@ - <productname>Pgpool-II</productname>, <productname>PostgreSQL</productname> version informations and Configuration + <productname>Pgpool-II</productname>, <productname>PostgreSQL</productname> version information and Configuration @@ -863,14 +863,14 @@ - To use the failover and online recovery of Pgpool-II, the settings that allow SSH without passowrd to other servers (osspc16 - osspc20) are necessary. + To use the failover and online recovery of Pgpool-II, the settings that allow SSH without password to other servers (osspc16 - osspc20) are necessary. - 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 600 on both postgreSQL servers osspc19 and osspc20. + 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 permission to 600 on both PostgreSQL servers osspc19 and osspc20. [osspc19]$ cat /var/lib/pgsql/.pgpass @@ -920,7 +920,7 @@ Here are the common settings on osspc16, osspc17 and osspc18. - 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. + 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 replication mode. # cp /etc/pgpool-II/pgpool.conf.sample-stream /etc/pgpool-II/pgpool.conf @@ -950,7 +950,7 @@ health_check_max_retries = 10 - Specify the backend informations with osspc19 and osspc20. + Specify the backend information with osspc19 and osspc20. # - Backend Connection Settings - @@ -972,13 +972,13 @@ Failover configuration - Specify failover_command to execute failover.sh script. The special characters %d %P %H %R in failover_command are replcaed with DB node ID of the detached node, Old primary node ID, Hostname of the new master node, Database cluster directory of the new master node. + Specify failover_command to execute failover.sh script. The special characters %d %P %H %R in failover_command are replaced with DB node ID of the detached node, Old primary node ID, Hostname of the new master node, Database cluster directory of the new master node. failover_command = '/etc/pgpool-II/failover.sh %d %P %H %R' - Create /etc/pgpool-II/failover.sh, and set the file permisson to 755. + Create /etc/pgpool-II/failover.sh, and set the file permission to 755. # vi /etc/pgpool-II/failover.sh @@ -1129,7 +1129,7 @@ ssh -T $remote_host $pghome/bin/pg_ctl -w -D $remote_pgdata start > /dev/null 2> host all postgres 0.0.0.0/0 md5 - To use md5 authentication, we need to register the user name and password in file pool_passwd. Execute command pg_md5 --md5auth --username=<user name> <password> to regist user name and MD5-hashed password in file pool_passwd. If pool_passwd doesn't exist yet, it will be created in the same directory as pgpool.conf. + To use md5 authentication, we need to register the user name and password in file pool_passwd. Execute command pg_md5 --md5auth --username=<user name> <password> to register user name and MD5-hashed password in file pool_passwd. If pool_passwd doesn't exist yet, it will be created in the same directory as pgpool.conf. # pg_md5 --md5auth --username=pgpool <password of pgpool user> @@ -1365,7 +1365,7 @@ ssh -T $remote_host $pghome/bin/pg_ctl -w -D $remote_pgdata start > /dev/null 2> # pcp_recovery_node -h 133.137.174.153 -p 9898 -U postgres -n 1 - After executing pcp_recovery_node command, vertify that osspc20 is started as a PostgreSQL standby server. + After executing pcp_recovery_node command, verify that osspc20 is started as a PostgreSQL standby server. # psql -h 133.137.174.153 -p 9999 -U pgpool postgres @@ -1406,7 +1406,7 @@ ssh -T $remote_host $pghome/bin/pg_ctl -w -D $remote_pgdata start > /dev/null 2> osspc18:9999 Linux osspc18 osspc18 9999 9000 7 STANDBY #osspc18 runs as STANDBY - Start Pgpool-II (osspc16) which we have stopped again, and vertify that osspc16 runs as a standby. + Start Pgpool-II (osspc16) which we have stopped again, and verify that osspc16 runs as a standby. [root@osspc16 ~]# systemctl start pgpool.service @@ -1423,7 +1423,7 @@ ssh -T $remote_host $pghome/bin/pg_ctl -w -D $remote_pgdata start > /dev/null 2> 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 133.137.174.153 -p 9999 -U pgpool postgres @@ -1483,7 +1483,7 @@ ssh -T $remote_host $pghome/bin/pg_ctl -w -D $remote_pgdata start > /dev/null 2> AWS Configuration Example - This tutrial explains the simple way to try "Watchdog" + This tutorial explains the simple way to try "Watchdog" on AWS and using the Elastic IP Address as the Virtual IP for the high availability solution. @@ -1545,7 +1545,7 @@ ssh -T $remote_host $pghome/bin/pg_ctl -w -D $remote_pgdata start > /dev/null 2> 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/failover.sgml b/doc/src/sgml/failover.sgml index b7920f5..41c8f2b 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.
@@ -402,7 +402,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 fdb040c..02f883f 100644 --- a/doc/src/sgml/loadbalance.sgml +++ b/doc/src/sgml/loadbalance.sgml @@ -696,13 +696,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 b28b7cb..0a47063 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. @@ -242,14 +242,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 ca02393..dce07be 100644 --- a/doc/src/sgml/ref/pgpool.sgml +++ b/doc/src/sgml/ref/pgpool.sgml @@ -218,7 +218,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 7e6a39f..c77b0c2 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, and the replication delay (only if in + balance node or not, and the replication delay (only if in streaming replication mode). The possible values in the status column are explained in the reference. If the hostname is something like "/tmp", that means diff --git a/doc/src/sgml/reference.sgml b/doc/src/sgml/reference.sgml index 8da31ba..2df08db 100644 --- a/doc/src/sgml/reference.sgml +++ b/doc/src/sgml/reference.sgml @@ -187,7 +187,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). @@ -212,7 +212,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 ab69788..4b9fc40 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 5d2aa0e..6edaf7e 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 1c07645..0c3c4d7 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/runtime.sgml b/doc/src/sgml/runtime.sgml index 28bfe0a..57436dd 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -128,7 +128,7 @@ replication mode, master slave mode, native 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 + files for each mode are provided. They are located under $prefix/etc. You can copy one of them to $prefix/etc/pgpool.conf. @@ -152,7 +152,7 @@ The master slave mode mode can be used with PostgreSQL servers operating Slony. In this mode, Slony/PostgreSQL is responsible for - synchronizing databases. Since Slony is being obsoletd by streaming + synchronizing databases. Since Slony is being obsoleted by streaming replication, we do not recommend to use this mode unless you have specific reason to use Slony. Load balancing is possible in the Load balancing is possible in the mode. The sample configuration @@ -162,7 +162,7 @@ In the raw mode, Pgpool-II does not care about the database synchronization. It's user's responsibility to make the whole - system does a meaningfull thing. Load balancing + system does a meaningful thing. Load balancing is not possible in the mode. The sample configuration file $prefix/etc/pgpool.conf.sample. 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 d8dfac7..575a6cc 100644 --- a/doc/src/sgml/stream-check.sgml +++ b/doc/src/sgml/stream-check.sgml @@ -128,7 +128,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 542b90c..a6700a2 100644 --- a/doc/src/sgml/watchdog.sgml +++ b/doc/src/sgml/watchdog.sgml @@ -287,7 +287,7 @@ - Behaivor on escalation and de-escalation + Behaviour on escalation and de-escalation Configuration about behavior when Pgpool-II @@ -305,8 +305,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.