Release 3.7.23

Release Date: 2022-02-17

A.49.1. Changes

  • Suppress message length log for in_hot_standby . (Tatsuo Ishii)

    PostgreSQL 14 introduced new config parameter in_hot_standby .

    The value is either "on" for standby servers or "off" for primary servers. As a result pgpool log is flooded by the messages:

         LOG:  reading message length
         DETAIL:  message length (22) in slot 1 does not match with slot 0(23)
        

    To avoid this, only complain if the parameter name is not in_hot_standby .

    Also the message is enhanced to show the parameter name. For example:

         LOG:  ParameterStatus "TimeZone": node 1 message length 30 is different from main node message length 24
        

    Discussion: [pgpool-hackers: 4076]

  • Enhance parameter status handling. (Tatsuo Ishii)

    When a parameter status message arrives from backend Pgpool-II forwards it to frontend not just memorize.

A.49.2. Bug fixes

  • Fix long standing bug with pcp_node_info . (Tatsuo Ishii)

    Discussion: [pgpool-hackers: 4109]

  • Fix health check process issues pointed out by Coverity . (Tatsuo Ishii)

  • Fix memory leak pointed out by Coverity . (Tatsuo Ishii)

  • Fix failover() to deal with the case when no former primary node exists. (Tatsuo Ishii)

    In case Req_info->primary_node_id is -1 like no primary node exists when Pgpool-II starts up, failover() skipped to call find_primary_node_repeatedly() . Also follow_master_command was not executed.

    Discussion: [pgpool-hackers: 4113]

  • Fixed the streaming replication check process not to retry if it cannot connect to the backend.( bug 742 ) (Bo Peng)

    This retry caused a long time failover.

A.49.3. Documents

  • Add restriction regarding ParameterStatus and in_hot_standby parameter. (Tatsuo Ishii)

  • Add restriction about set_config . (Tatsuo Ishii)

A.49.4. Test tools

  • Fix pgpool_setup in failover script creation. (Tatsuo Ishii)

    When pgpool_setup creates failover.sh , it did not consider the case when no primary server existed.

A.49.5. Regression tests

  • Allow to run regression test against existing installation without recompiling. (Tatsuo Ishii)

    Discussion: [pgpool-hackers: 4077]

  • Fix pgpool_setup and watchdog_setup binary PATH in noinstall mode. (Bo Peng)