A.19. Release 4.2.8

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]

Add validations of wd_lifecheck_password and recovery_password format (Masaya Kawamoto)

wd_lifecheck_password and recovery_password are not allowed to be md5 hashed password format but pgpool just reported authentication failure and did not check them.

Enhance parameter status handling. (Tatsuo Ishii)

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

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 sample failover script. (Bo Peng)

This script did not consider the case when the old primary node id is "-1".

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.

Fix documentation typos. (pengbo)

Patch is created by Umar Hayat.

Add "exclude" settings to /etc/yum.repos.d/pgdg-redhat-all.repo so that Pgpool-II is not installed from PostgreSQL YUM repository. (Bo Peng)

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

Add restriction about set_config. (Tatsuo Ishii)

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.

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

Discussion: [pgpool-hackers: 4077]

Fix regression test 075. (Tatsuo Ishii)

The test reported success even if pgpool does not start up. Problem reported and patch provided by Qiang Lingjie. Discussion: [pgpool-hackers: 4085]

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