A.39. Release 4.2.23

Fix watchdog to print inappropriate NOTICE message. (Tatsuo Ishii)

read_ipc_socket_and_process() printed a notice message every time when it wrote commands to IPC socket even if it was successful. Fix this to print the notice message only when the write failed. The reason why this bug was not recognized is, the message appears only when log_min_messages is set to notice or higher.

Discussion: pgpool IPC socket connection issue

Fix resource leak while reading startup packet. (Tatsuo Ishii)

Fix resource leak in pool_push_pending_data.

Fix broken scram-sha-256 authentication on big-endian machines. (Tatsuo Ishii)

When scram-sha-256 authentication is performed, a hash function pg_sha_256_final is used. It was imported from PostgreSQL and it uses preprocessor define WORDS_BIGENDIAN to judge host machine's endianness. Although WORDS_BIGENDIAN should be defined while configure, this part was missed when pg_sha_256_final (and others) was imported from PostgreSQL. As a result, scram-sha-256 worked only in little endian machines. Fixed the issue by adding AC_C_BIGENDIAN macro to configure.ac.

Problem reported by Christoph Berg and analyzed by pranavkaruvally.

Discussion: 4.6.1 fails on big-endian s390x: backend response with kind 'E' when expecting 'R'

Fix source code typos. (Bo Peng)

Fix heartbeat device treatment. (Tatsuo Ishii)

While processing pgpool.conf, heartbeat_device was mistakenly treated and the first device was ignored.

Problem analyzed by Bo Peng.

Fix documentation for parameters that are not reflected by reload. (Taiki Koshino)

"authentication_timeout" and "memqcache_oiddir" is not reflected by reload. The documentation is changed to "This parameter can only be set at server start.".

Unify watchdog leader terms (followup). (Tatsuo Ishii)

Fix example script link. (Taiki Koshino)

Modified the sample script in the section "8.2. Pgpool-II + Watchdog Setup Example"

Fix load balance explanation missed logical replication mode and Slony mode. (Tatsuo Ishii)

Add section of kernel resources. (Tatsuo Ishii)

Pgpool-II uses System V shared memory and semaphores. It's better to describe the requirements in the docs.

Add description for --with-ldap option of configure. (Tatsuo Ishii)

It was missed when LDAP support was introduced in v4.2

Clarify supported platforms for Pgpool-II. (Tatsuo Ishii)

Enhance child_life_time document. (Tatsuo Ishii)

Stabilize 029.cert_passphrase regression test. (Tatsuo Ishii)

When ssl_passphrase_command is not valid, the error message is typically "bad decrypt" but it seems sometimes "wrong tag".