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

# A.63. Release 4.2.15

> Release Date: 2023-11-30

## A.63.1. Changes

- Modify the replication slot name conversion in sample scripts to support for the hostname in uppercase. (Bo Peng)

  Replication slots are automatically created or deleted in the scripts which are executed during failover or online recovery. Since uppercase can't be used for a replication slot name, modify these scripts to convert the hostname to lowercase.

  Patch is created by Sheikh Wasiu Al Hasib and modified by Bo Peng.

- Add SSH timeout in sample script `escalation.sh.sample` which is set in wd_escalation_command parameter. (Bo Peng)

## A.63.2. Bug fixes

- Remove unnecessary logging line. (Tatsuo Ishii)

  Debug message "unset_tx_started_by_multi_statement_query is called in CommandComplete" was accidentally left.

- Fix `Describe()` so that it does not abort with portal created by `DECLARE`. (Tatsuo Ishii)

  When `DECLARE foo CURSOR FOR` is executed, a portal named "foo" is automatically created by PostgreSQL. As the portal is not managed by Pgpool-II, "Describe foo" message failed with "unable to execute Describe. unable to get the bind message" error.

  To fix this, make `Describe()` create a dummy write query context so that the describe message is sent to primary (streaming replication mode) or all nodes (replication/snapshot isolation mode).

  Also add test case 080 for this commit.

  This problem was reported and analyzed by Heather Lapointe.

  Discussion: https://www.pgpool.net/pipermail/pgpool-general/2023-September/008995.html

- Remove duplication definitions of `NAMEDATALEN`. (Tatsuo Ishii)

  The definition for `NAMEDATALEN` is now in `src/include/pg_config_manual.h` only. Also replace `POOL_NAMEDATALEN` with `NAMEDATALEN` in `src/utils/pool_select_walker.c`.

  Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2023-August/004366.html

## A.63.3. Documents

- Modify "Pgpool-II + Watchdog Setup Example" to mention that `pcp_listen_addresses = '*'` is required to allow PCP to listen on all addresses.

- Enhance follow_primary_command manual. (Tatsuo Ishii)

  Mention that it is necessary to run pcp_attach_node if pcp_recovery_node is not used.

## A.63.4. Regression Tests

- Enhance `pgpool_setup`. (Tatsuo Ishii)

  Enhance failover script generation and follow primary script generation so that they create better logging.

Prev | Home | Next
Release 4.2.16 | Up | Release 4.2.14