Release 3.6.23

Release Date: 2020-09-17

A.78.1. Changes

  • Follow the guide line of PostgreSQL 12.4 regarding extensions. (Tatsuo Ishii)

    CREATE OR REPLACE FUNCTION should be avoided. Use CREATE FUNCTION instead.

  • Replace "PGBIN" and "LPATH" in pgpool_setup and watchdog_setup using PostgreSQL's bin path and lib path. (Bo Peng)

A.78.2. Bug fixes

  • Doc: fix the incorrect description regarding the running modes of Pgpool-II in which online recovery is available. (Bo Peng)

  • Remove unnecessary checks in some code path. (Tatsuo Ishii)

    Patch contributed by Hou, Zhijie.

  • Fix relcache query sometimes sent to other than primary. (Tatsuo Ishii)

    In streaming replication mode, relcache queries are supposed to be sent to the primary node. But actually they were not sent to the primary node if primary node was not the master node. Typically this could happen when the primary is not node 0.

  • Fix connection_life_time not working when serialize_accept is enabled. (Tatsuo Ishii)

    Discussion: [pgpool-general: 7175]

  • Display more informative error message in authentication process. (Tatsuo Ishii)

  • Fix segfault in pgpool child process in certain case. (Tatsuo Ishii)

    This issue can be reproduced with the following steps:

    1. Shutdown all backends.

    2. Connect to pgpool with invalid client. I have used pcp_attach_node with pgpool's port number, not pcp's.