A.78. Release 4.2.10

Add ssh options to restore_command in sample scripts. (Bo Peng)

Patch is created by Jon SCHEWE and updated by Bo Peng.

Update sample scripts. (Bo Peng)

• Update PSQL connection information to use postgres database when creating or dropping replication slots.

• Allow setting ssh login user and ssh key file using variables.

When CloseComplete is received, forward to frontend without buffering. (Tatsuo Ishii)

It seems this caused occasional timeout error in 074.bug700_memqcache_segfault.

Fix bug in query cache. (Tatsuo Ishii)

Pgpool-II did not cache the query like "Select '2022-02-18 07:00:00.006547'::timestamp". SELECTs include TIMESTAMP, TIME and DATE are cached, and SELECTs include TIMESTAMPZ and TIMEZ are not cached because the result can be changed by SET TIME ZONE command etc. Furthermore, SELECTs having functions with return types are timestamptz or timetz are not cached too as same reason. Discussion: [pgpool-general: 8285]

Fix internal transaction handling bug in snapshot isolation mode. (Tatsuo Ishii)

Doc: mention that certain SELECTs are not cached. (Tatsuo Ishii)

certain SELECTs are follows.

• SELECTs including TIMESTAMP WITH TIMEZONE or TIME WITH TIMEZONE

• SELECTs including CAST to TIMESTAMP WITH TIMEZONE or TIME WITH TIMEZONE

• SELECTs including SQLValueFunction (CURRENT_TIME, CURRENT_USER etc.)

Doc: fix description about using PCP password file when connect to Unix domain socket (Masaya Kawamoto)

The localhost entry in pcppass matches only for the default PCP socket directory path, not all Unix socket connections. This behavior is the same as pgpass.

Doc: enhance and fix memory requirement section. (Tatsuo Ishii)

• Add explanation about memory usage while pgpool child process is running.

• Enhance the formula to calculate shared memory requirement so that it computes more accurate result.

• Fix shared memory requirement for shared rel cache. The old value 64MB was simply wrong.

• Fix process memory requirement. Previously the formula was based on RSS. However PSS should be used because RSS includes shared memory such as the memory used for libraries. This results in lot smaller memory requirement than before.

Doc: fix wrong explanation on memqcache_maxcache, memqcache_expire. (Tatsuo Ishii)

Those parameters cannot be changed by reloading config file. Restarting pgpool is required. Discussion: [pgpool-general: 8195]

Allow to run pgpool_setup on PostgreSQL 15. (Tatsuo Ishii)

Per ticket 757

Allow pgpool_setup to test sample scripts and sample config files contained in RPMs. (Bo Peng)

Test: print Pgpool-II version in the regression test. (Tatsuo Ishii)

Test: Fix regression test script to look for pgpool.conf in the proper install directory. (Tatsuo Ishii)