A.23. Release 3.7.3

A.23.1. Bug fixes

• Disable health check per node parameters by default. (Bo Peng)

• Fix pcp_detach_node hung when -g option is specified. (bug 391) (Tatsuo Ishii)

• Test: Add new regression test for node 0 is down. (Tatsuo Ishii)

• Make calls to to_regclass fully schema qualified. (Tatsuo Ishii)

• Fix pgpool child process segfault when ALWAYS_MASTER is on. (Tatsuo Ishii)

  If following conditions are all met pgpool child segfaults:

  1. Streaming replication mode.

  2. fail_over_on_backend_error is off.

  3. ALWAYS_MASTER flag is set to the master (writer) node.

  4. pgpool_status file indicates that the node mentioned in #3 is in down status.

• Doc: Improve watchdog documents. (Tatsuo Ishii)

• Doc: Add a document for adding new config parameter. (Tatsuo Ishii)

• Test: Improve test script 003.failover. (Bo Peng)

• Deal with "unable to bind D cannot get parse message "S1" error. (Tatsuo Ishii)

• Doc: Mention that users can avoid failover using backend_flag even PostgreSQL admin shutdown. (Tatsuo Ishii)

• Doc: Fix document typos. (Bo Peng)

• Test: Add new regression test for node 0 not being primary. (Tatsuo Ishii)

• Fix pgpool_setup failure in replication mode. (Tatsuo Ishii)

• Allow to support pgpool_switch_xlog PostgreSQL 10. (Tatsuo Ishii)

• Revert "Fix pgpool child process segfault when ALWAYS_MASTER is on." (Tatsuo Ishii)

  With the commit, write queries are always sent to node 0 even if the primary node is not 0 because PRIMARY_NODE_ID macro returns REAL_MASTER_NODE_ID, which is usually 0. Thus write queries are failed with: ERROR: cannot execute INSERT in a read-only transaction

• Test: Enhance extended query test. (Tatsuo Ishii)

• Doc: Fix pgpool_adm family functions examples. (Tatsuo Ishii)