pgpool-II 4.7.0 Documentation
Prev | Up | Appendix A. Release Notes | Next

# A.55. Release 4.2.23

> Release Date: 2025-08-21

## A.55.1. Bug fixes

- 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.

## A.55.2. Documents

- 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)

## A.55.3. Regression Tests

- 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".

Prev | Home | Next
Release 4.2.24 | Up | Release 4.2.22