A.31. Release 3.6.22

Doc: mention that ssl_ciphers only affects to TLS 1.2 and lower. (Tatsuo Ishii)

Doc: Improve the description of wd_priority. (Bo Peng)

Patch is provided by Kenichiro Tanaka.

Add mention about hostssl/hostnossl to pool_hba.conf sample file. (Tatsuo Ishii)

Doc: documentation improvements. (Tatsuo Ishii)

At pgpool startup, if pid file exists, truncate pid file to zero length before writing. (Bo Peng)

Patch is created by maliangzhu.

Doc: fix error in failback_command parameter description. (Bo Peng)

Fix connection_life_time does not work if primary node is not 0 in streaming replication mode. (Tatsuo Ishii)

Fix pgpool_setup problem with -r option and PostgreSQL 12. (Tatsuo Ishii)

Change PCP UNIX_DOMAIN_PATH of RPM package to /var/run/postgresql. (Bo Peng)

Fix query cache bugs. (Tatsuo Ishii)

If query cache is enable, when a table is updated, Pgpool-II should delete all the caches related to the table. However, EXPLAIN ANALYZE and CTE with data-modifying SQLs were mistakenly treated as normal read only query so that the query caches were not deleted.

Patch is created by Hou, Zhijie and modified by Tatsuo Ishii.

Fix Pgpool-II hang in a corner case. (Tatsuo Ishii)

If there are parameters other than "user", "database" and "application_name", reading startup packet failed. (Tatsuo Ishii)

Fix miscount of connections when pg_terminate_backend() is executed. (Takuma Hoshiai)

Fix segmentation fault when application name is included in log_line_prefix. (bug 615) (Tatsuo Ishii)

Fix incorrectly performing failover when pg_terminate_backend() is executed in native replication mode. (Takuma Hoshiai)