A.87. Release 3.7.6

Allow PCP[attach/detach/promote] commands during failover. (Muhammad Usama)

Change pgpool.spec file to install extension to DB server which supports LLVM JIT. (Bo Peng)

Doc: Add note to online recovery doc. (Tatsuo Ishii)

This warns that client_idle_limit_in_recovery must be smaller than recovery_timeout.

Test: Add regression test for SSL connection. (Tatsuo Ishii)

Doc: Add notes regarding failover script. (Tatsuo Ishii)

It's not recommended to access against Pgpool-II itself from failover/failback scripts.

Doc: Improve pg_md5 docs and error message. (Bo Peng)

Patch provided by Jesper Pedersen and modified by me.

Test: Add definition of PGLIB in regress.sh. (Bo Peng)

Patch provided by Jesper Pedersen.

Fix typo in child_max_connections description of SHOW POOL_STATUS output. (Tatsuo Ishii)

Patch provided by Phil Ramirez.

Fix segmentation fault when error query and Sync message are sent in native replication mode. (bug 434) (Takuma Hoshiai)

In native replication mode, segmentation fault occurs when Sync messages is sent just after a query error.

Fix syntax error when queries including time functions and IN (SELECT ...) in WHERE clause in native replication mode. (bug 433) (Bo Peng)

In native replication mode, queries including time functions (e.g. now(), CURRENT_TIMESTAMP etc.) are rewritten to a timestamp constant value. However, Pgpool-II doesn't support queries including time functions and IN (SELECT ...) in WHERE clause.

Fix occasional less data returned to frontend with extended protocol. (bug432) (Tatsuo Ishii)

The idea for fix is, use pending message data list. It records messages from frontend, and it is expected that we will receive same number of messages.

Initial patch is created by Yugo Nagata and fixed by Tatsuo Ishii.

Fix memory leak when query cache enabled in streaming replication mode + extended query case. (Tatsuo Ishii)

Fix memory leak in trigger_failover_command(). (Tatsuo Ishii)

Fix memory leak when memory_cache_enabled = on and write SQLs are sent. (Bo Peng)

In a explicit transaction, the SELECT results are cached in temporary buffer. If a write SQL is sent which modifies the table, the temporary buffer should be reset.

Test: Fix occasional failure in regression 065.bug152. (Tatsuo Ishii)

Test: Add EXECUTE/DEALLOCATE regression test. (Takuma Hoshiai)

Add missing pgpool_recovery--1.0--1.1.sql file to update pgpool_recovery() function version to 1.1. (Bo Peng)

Fix kind mismatch error when DEALLOCATE statement is issued. (Bo Peng)

PREPARE should be add to pool_add_sent_message, so that EXECUTE and DEALLOCATE can be sent to the same node as PREPARE.

See [pgpool-general: 6226] for more details.

Do not update pool_passwd if the password length is incorrect. (bug 419) (Takuma Hoshiai, Tatsuo Ishii)

For Pgpool-II 3.7 or before, the password stored in pool_passwd is MD5 password only. So check the correctness of pool_passwd by scanning entire file.

Doc: Change follow_primary_command description "new master" to "new primary". (Bo Peng)

Fix newer version of gcc warnings. (Tatsuo Ishii)

Test: Update clean.sh which clean up regression test results. (Bo Peng)

Patch provided by Jesper Pedersen.

Add .gitignore files. (Bo Peng)

Patch provided by Jesper Pedersen.

Fix segfault when node 0 is in down status in case of both health check and failover_on_backend_error are disabled. (Tatsuo Ishii)

Doc: Fix typos in documents and scripts. (Tatsuo Ishii)

Patch contributed by Jesper Pedersen.

Doc: Fix document mistakes of recovery_1st_stage_command and recovery_2nd_stage_command. (Bo Peng)