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

# A.112. Release 4.0.6

> Release Date: 2019-08-15

## A.112.1. Enhancements

- Doc: Update "Pgpool-II + Watchdog Setup Example" to support PostgreSQL 12. (Bo Peng)

- Import some of memory manager debug facilities from PostgreSQL. (Tatsuo Ishii)

- Use `pg_get_expr()` instead of `pg_attrdef.adsrc` to support for PostgreSQL 12. (Bo Peng)

- Enhance shutdown script of pgpool_setup. (Tatsuo Ishii)

  - Make shutdownall to wait for completion of shutdown of Pgpool-II.

  - If environment variable `CHECK_TIME_WAIT` is set to true, use `netstat` command to confirm usage of the `TCP/IP` port while executing shutdown script.

- Deal `pgpool_adm` extension with PostgreSQL 12. (Tatsuo Ishii)

- Doc: add description to pg_md5 man page how to show `pool_passwd` hashed string. (Tatsuo Ishii)

- Doc: add general description about failover. (Tatsuo Ishii)

## A.112.2. Bug fixes

- Test: Fix test failure of extended-query-test when `disable_load_balance_on_write = off/transaction/always`. (Tatsuo Ishii)

- Fix "unable to bind. cannot get parse message" error. (bug 531) (Tatsuo Ishii)

- Fix online-recovery is blocked after a child process exits abnormally with replication mode and watchdog. (bug 483) (Muhammad Usama)

- Fix for keep the backend health check running on quarantined nodes. (Muhammad Usama)

  Pgpool should keep the backend health check running on quarantined nodes so that when the connectivity resumes, they should automatically get removed from the quarantine.

  See [pgpool-hackers: 3295] for more details.

- Fix for no primary on standby pgpool when primary is quarantined on master. (Muhammad Usama)

  Master watchdog Pgpool sends the backend status sync message if the primary node is quarantined on it. So standby watchdog pgpool must not update its status when the status of current primary node is not DOWN.

- Fix watchdog_setup command `mode` option to work correctly. (Takuma Hoshiai)

- Fix pgpool_setup to produce correct follow master command. (Tatsuo Ishii)

- Fix in native replication mode Pgpool-II rewriting query error when the queries include `GROUPS` and `EXCLUDE` in `frame` clauses. (Bo Peng)

- Fix query cache module so that it checks oid array's bound. (Tatsuo Ishii)

- Fix off-by-one error in query cache module. (Tatsuo Ishii)

- Allow health check process to reload. (Tatsuo Ishii)

- Fix segfault when query cache is enabled. (bug 525) (Tatsuo Ishii)

- Down grade LOG "checking zapping sent message ..." to DEBUG5. (Tatsuo Ishii)

  Discussion: [pgpool-general: 6620]

- Fix segfault when `samenet` is specified in `pool_hba.conf`. (Tatsuo Ishii)

  Discussion: [pgpool-general: 6601].

- Doc: Fix documentation mistakes in `follow_master.sh` script and typos. (Bo Peng)

- Fix health check process is not shutting down in certain cases. (Tatsuo Ishii)

- Fix to deal with backslashes according to the config of `standard_conforming_strings` in native replication mode. (bug 467) (Bo Peng)

- Fix compile error on FreeBSD. (bug 512, bug 519) (Bo Peng)

- Fix memory leaks. (Tatsuo Ishii)

- Make failover in progress check more aggressively to avoid potential segfault. (Tatsuo Ishii)

Prev | Home | Next
Release 4.0.7 | Up | Release 4.0.5