summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTaiki Koshino2025-08-19 01:36:06 +0000
committerTaiki Koshino2025-08-19 01:36:06 +0000
commitc5fa45f6974971dd9a1cb0701c28d66ce4220aa8 (patch)
tree244044dc36660609ceee7f1d6d65d35bc1226085 /doc/src
parent606ebc91493eb5adb8a525a68d6cc36bea1617dd (diff)
Doc: add release notes.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/release-4.2.sgml214
-rw-r--r--doc/src/sgml/release-4.3.sgml249
-rw-r--r--doc/src/sgml/release-4.4.sgml249
-rw-r--r--doc/src/sgml/release-4.5.sgml249
-rw-r--r--doc/src/sgml/release-4.6.sgml333
5 files changed, 1292 insertions, 2 deletions
diff --git a/doc/src/sgml/release-4.2.sgml b/doc/src/sgml/release-4.2.sgml
index 94af553da..3d3972638 100644
--- a/doc/src/sgml/release-4.2.sgml
+++ b/doc/src/sgml/release-4.2.sgml
@@ -1,6 +1,220 @@
<!-- doc/src/sgml/release-4.2.sgml -->
<!-- See header comment in release.sgml about typical markup -->
+<sect1 id="release-4-2-23">
+ <title>Release 4.2.23</title>
+ <note>
+ <title>Release Date</title>
+ <simpara>2025-08-21</simpara>
+ </note>
+
+ <sect2>
+ <title>Bug fixes</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-07-25 [75d905ff9]
+ -->
+ <para>
+ Fix watchdog to print inappropriate NOTICE message. (Tatsuo Ishii)
+ </para>
+ <para>
+ <function>read_ipc_socket_and_process()</function> printed a notice message every time when
+ it wrote commands to IPC socket even if it was successful. Fix this to
+ print the notice message only when the write failed.
+
+ The reason why this bug was not recognized is, the message appears
+ only when <varname>log_min_messages</varname> is set to notice or higher.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/121">pgpool IPC socket connection issue</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-07-19 [d05de5c73]
+ -->
+ <!--
+ 2025-07-19 [ed57af34e]
+ -->
+ <para>
+ Fix resource leak while reading startup packet. (Tatsuo Ishii)
+ </para>
+ <para>
+ Fix resource leak in pool_push_pending_data.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-30 [bac455b2f]
+ -->
+ <para>
+ Fix broken scram-sha-256 authentication on big-endian machines. (Tatsuo Ishii)
+ </para>
+ <para>
+ When <literal>scram-sha-256</literal> authentication is performed, a hash function
+ <function>pg_sha_256_final</function> is used. It was imported from <productname>PostgreSQL</productname> and it uses
+ preprocessor define WORDS_BIGENDIAN to judge host machine's
+ endianness. Although WORDS_BIGENDIAN should be defined while
+ configure, this part was missed when <function>pg_sha_256_final</function> (and others) was
+ imported from <productname>PostgreSQL</productname>. As a result, <literal>scram-sha-256</literal> worked only in
+ little endian machines. Fixed the issue by adding
+ AC_C_BIGENDIAN macro to configure.ac.
+ </para>
+ <para>
+ Problem reported by Christoph Berg and analyzed by pranavkaruvally.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/106">4.6.1 fails on big-endian s390x: backend response with kind 'E' when expecting 'R'</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-23 [2721c7b76]
+ -->
+ <para>
+ Fix source code typos. (Bo Peng)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-09 [4305c42d6]
+ -->
+ <para>
+ Fix heartbeat device treatment. (Tatsuo Ishii)
+ </para>
+ <para>
+ While processing <filename>pgpool.conf</filename>, <varname>heartbeat_device</varname> was mistakenly treated
+ and the first device was ignored.
+ </para>
+ <para>
+ Problem analyzed by Bo Peng.
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Documents</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-08-04 [e2f24fec8]
+ -->
+ <para>
+ Fix documentation for parameters that are not reflected by reload. (Taiki Koshino)
+ </para>
+ <para>
+ "authentication_timeout" and "memqcache_oiddir" is not reflected by reload.
+ The documentation is changed to "This parameter can only be set at server start.".
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-07-24 [bc5fa5e7e]
+ -->
+ <!--
+ 2025-07-23 [1e8963554]
+ -->
+ <para>
+ Unify watchdog leader terms (followup). (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-08-06 [31eee18d7]
+ -->
+ <!--
+ 2025-07-16 [34b07c2d5]
+ -->
+ <para>
+ Fix example script link. (Taiki Koshino)
+ </para>
+ <para>
+ Modified the sample script in the section "<ulink url="https://www.pgpool.net/docs/46/en/html/example-cluster.html">8.2. Pgpool-II + Watchdog Setup Example</ulink>"
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-18 [f4ae9f39e]
+ 2025-06-18 [7a20dc419]
+ -->
+ <para>
+ Fix load balance explanation missed logical replication mode and Slony mode. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-08 [59f9df005]
+ -->
+ <para>
+ Add section of kernel resources. (Tatsuo Ishii)
+ </para>
+ <para>
+ <productname>Pgpool-II</productname> uses System V shared memory and semaphores. It's better to
+ describe the requirements in the docs.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-07 [40617fd90]
+ -->
+ <para>
+ Add description for <option>--with-ldap</option> option of configure. (Tatsuo Ishii)
+ </para>
+ <para>
+ It was missed when LDAP support was introduced in v4.2
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-04 [ff60bf930]
+ -->
+ <para>
+ Clarify supported platforms for <productname>Pgpool-II</productname>. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-03 [cc4da5979]
+ -->
+ <para>
+ Enhance <xref linkend="guc-child-life-time"> document. (Tatsuo Ishii)
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Regression Tests</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-06-08 [78e45decf]
+ -->
+ <para>
+ Stabilize 029.cert_passphrase regression test. (Tatsuo Ishii)
+ </para>
+ <para>
+ When <varname>ssl_passphrase_command</varname> is not valid, the error message is
+ typically "bad decrypt" but it seems sometimes "wrong tag".
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+</sect1>
+
<sect1 id="release-4-2-22">
<title>Release 4.2.22</title>
<note>
diff --git a/doc/src/sgml/release-4.3.sgml b/doc/src/sgml/release-4.3.sgml
index 733e5db53..1ebc0be06 100644
--- a/doc/src/sgml/release-4.3.sgml
+++ b/doc/src/sgml/release-4.3.sgml
@@ -1,6 +1,255 @@
<!-- doc/src/sgml/release-4.3.sgml -->
<!-- See header comment in release.sgml about typical markup -->
+<sect1 id="release-4-4-16">
+ <title>Release 4.3.16</title>
+ <note>
+ <title>Release Date</title>
+ <simpara>2025-08-21</simpara>
+ </note>
+
+ <sect2>
+ <title>Bug fixes</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-07-25 [75d905ff9]
+ -->
+ <para>
+ Fix watchdog to print inappropriate NOTICE message. (Tatsuo Ishii)
+ </para>
+ <para>
+ <function>read_ipc_socket_and_process()</function> printed a notice message every time when
+ it wrote commands to IPC socket even if it was successful. Fix this to
+ print the notice message only when the write failed.
+
+ The reason why this bug was not recognized is, the message appears
+ only when <varname>log_min_messages</varname> is set to notice or higher.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/121">pgpool IPC socket connection issue</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-07-19 [d05de5c73]
+ -->
+ <!--
+ 2025-07-19 [ed57af34e]
+ -->
+ <para>
+ Fix resource leak while reading startup packet. (Tatsuo Ishii)
+ </para>
+ <para>
+ Fix resource leak in pool_push_pending_data.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-30 [bac455b2f]
+ -->
+ <para>
+ Fix broken scram-sha-256 authentication on big-endian machines. (Tatsuo Ishii)
+ </para>
+ <para>
+ When <literal>scram-sha-256</literal> authentication is performed, a hash function
+ <function>pg_sha_256_final</function> is used. It was imported from <productname>PostgreSQL</productname> and it uses
+ preprocessor define WORDS_BIGENDIAN to judge host machine's
+ endianness. Although WORDS_BIGENDIAN should be defined while
+ configure, this part was missed when <function>pg_sha_256_final</function> (and others) was
+ imported from <productname>PostgreSQL</productname>. As a result, <literal>scram-sha-256</literal> worked only in
+ little endian machines. Fixed the issue by adding
+ AC_C_BIGENDIAN macro to configure.ac.
+ </para>
+ <para>
+ Problem reported by Christoph Berg and analyzed by pranavkaruvally.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/106">4.6.1 fails on big-endian s390x: backend response with kind 'E' when expecting 'R'</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-23 [2721c7b76]
+ -->
+ <para>
+ Fix source code typos. (Bo Peng)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-09 [4305c42d6]
+ -->
+ <para>
+ Fix heartbeat device treatment. (Tatsuo Ishii)
+ </para>
+ <para>
+ While processing <filename>pgpool.conf</filename>, <varname>heartbeat_device</varname> was mistakenly treated
+ and the first device was ignored.
+ </para>
+ <para>
+ Problem analyzed by Bo Peng.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-02 [06ba7dde4]
+ -->
+ <para>
+ Fix typo in the comments of <filename>pgpool.conf</filename>. (Tatsuo Ishii)
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Documents</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-08-15 [a54f5d1ad]
+ -->
+ <para>
+ Enhance "8.3. Replication Mode and Snapshot Isolation Mode Configuration Example" Document. (Taiki Koshino)
+ </para>
+ <para>
+ Updated the link to the example script and the explanation in the "8.3.3. Before you begin" section.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-08-04 [e2f24fec8]
+ -->
+ <para>
+ Fix documentation for parameters that are not reflected by reload. (Taiki Koshino)
+ </para>
+ <para>
+ "authentication_timeout" and "memqcache_oiddir" is not reflected by reload.
+ The documentation is changed to "This parameter can only be set at server start.".
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-07-24 [bc5fa5e7e]
+ -->
+ <!--
+ 2025-07-23 [1e8963554]
+ -->
+ <para>
+ Unify watchdog leader terms (followup). (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-08-06 [31eee18d7]
+ -->
+ <!--
+ 2025-07-16 [34b07c2d5]
+ -->
+ <para>
+ Fix example script link. (Taiki Koshino)
+ </para>
+ <para>
+ Modified the sample script in the section "<ulink url="https://www.pgpool.net/docs/46/en/html/example-cluster.html">8.2. Pgpool-II + Watchdog Setup Example</ulink>"
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-18 [f4ae9f39e]
+ 2025-06-18 [7a20dc419]
+ -->
+ <para>
+ Fix load balance explanation missed logical replication mode and Slony mode. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-18 [9d2e4e692]
+ -->
+ <para>
+ Enhance <xref linkend="pcp-node-info"> document. (Bo Peng)
+ </para>
+ <para>
+ Clarify that each <varname>backend_application_nameX</varname> must match the value specified
+ in the <varname>application_name</varname> of <varname>primary_conninfo</varname> to correctly display
+ "<varname>replication_state</varname>" and "<varname>replication_sync_state</varname>".
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-08 [59f9df005]
+ -->
+ <para>
+ Add section of kernel resources. (Tatsuo Ishii)
+ </para>
+ <para>
+ <productname>Pgpool-II</productname> uses System V shared memory and semaphores. It's better to
+ describe the requirements in the docs.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-07 [40617fd90]
+ -->
+ <para>
+ Add description for <option>--with-ldap</option> option of configure. (Tatsuo Ishii)
+ </para>
+ <para>
+ It was missed when LDAP support was introduced in v4.2
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-04 [ff60bf930]
+ -->
+ <para>
+ Clarify supported platforms for <productname>Pgpool-II</productname>. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-03 [cc4da5979]
+ -->
+ <para>
+ Enhance <xref linkend="guc-child-life-time"> document. (Tatsuo Ishii)
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Regression Tests</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-06-08 [78e45decf]
+ -->
+ <para>
+ Stabilize 029.cert_passphrase regression test. (Tatsuo Ishii)
+ </para>
+ <para>
+ When <varname>ssl_passphrase_command</varname> is not valid, the error message is
+ typically "bad decrypt" but it seems sometimes "wrong tag".
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+</sect1>
+
<sect1 id="release-4-3-15">
<title>Release 4.3.15</title>
<note>
diff --git a/doc/src/sgml/release-4.4.sgml b/doc/src/sgml/release-4.4.sgml
index 5a05025e6..8bf79e5f5 100644
--- a/doc/src/sgml/release-4.4.sgml
+++ b/doc/src/sgml/release-4.4.sgml
@@ -1,6 +1,255 @@
<!-- doc/src/sgml/release-4.4.sgml -->
<!-- See header comment in release.sgml about typical markup -->
+<sect1 id="release-4-4-13">
+ <title>Release 4.4.13</title>
+ <note>
+ <title>Release Date</title>
+ <simpara>2025-08-21</simpara>
+ </note>
+
+ <sect2>
+ <title>Bug fixes</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-07-25 [75d905ff9]
+ -->
+ <para>
+ Fix watchdog to print inappropriate NOTICE message. (Tatsuo Ishii)
+ </para>
+ <para>
+ <function>read_ipc_socket_and_process()</function> printed a notice message every time when
+ it wrote commands to IPC socket even if it was successful. Fix this to
+ print the notice message only when the write failed.
+
+ The reason why this bug was not recognized is, the message appears
+ only when <varname>log_min_messages</varname> is set to notice or higher.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/121">pgpool IPC socket connection issue</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-07-19 [d05de5c73]
+ -->
+ <!--
+ 2025-07-19 [ed57af34e]
+ -->
+ <para>
+ Fix resource leak while reading startup packet. (Tatsuo Ishii)
+ </para>
+ <para>
+ Fix resource leak in pool_push_pending_data.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-30 [bac455b2f]
+ -->
+ <para>
+ Fix broken scram-sha-256 authentication on big-endian machines. (Tatsuo Ishii)
+ </para>
+ <para>
+ When <literal>scram-sha-256</literal> authentication is performed, a hash function
+ <function>pg_sha_256_final</function> is used. It was imported from <productname>PostgreSQL</productname> and it uses
+ preprocessor define WORDS_BIGENDIAN to judge host machine's
+ endianness. Although WORDS_BIGENDIAN should be defined while
+ configure, this part was missed when <function>pg_sha_256_final</function> (and others) was
+ imported from <productname>PostgreSQL</productname>. As a result, <literal>scram-sha-256</literal> worked only in
+ little endian machines. Fixed the issue by adding
+ AC_C_BIGENDIAN macro to configure.ac.
+ </para>
+ <para>
+ Problem reported by Christoph Berg and analyzed by pranavkaruvally.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/106">4.6.1 fails on big-endian s390x: backend response with kind 'E' when expecting 'R'</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-23 [2721c7b76]
+ -->
+ <para>
+ Fix source code typos. (Bo Peng)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-09 [4305c42d6]
+ -->
+ <para>
+ Fix heartbeat device treatment. (Tatsuo Ishii)
+ </para>
+ <para>
+ While processing <filename>pgpool.conf</filename>, <varname>heartbeat_device</varname> was mistakenly treated
+ and the first device was ignored.
+ </para>
+ <para>
+ Problem analyzed by Bo Peng.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-02 [06ba7dde4]
+ -->
+ <para>
+ Fix typo in the comments of <filename>pgpool.conf</filename>. (Tatsuo Ishii)
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Documents</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-08-15 [a54f5d1ad]
+ -->
+ <para>
+ Enhance "8.3. Replication Mode and Snapshot Isolation Mode Configuration Example" Document. (Taiki Koshino)
+ </para>
+ <para>
+ Updated the link to the example script and the explanation in the "8.3.3. Before you begin" section.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-08-04 [e2f24fec8]
+ -->
+ <para>
+ Fix documentation for parameters that are not reflected by reload. (Taiki Koshino)
+ </para>
+ <para>
+ "authentication_timeout" and "memqcache_oiddir" is not reflected by reload.
+ The documentation is changed to "This parameter can only be set at server start.".
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-07-24 [bc5fa5e7e]
+ -->
+ <!--
+ 2025-07-23 [1e8963554]
+ -->
+ <para>
+ Unify watchdog leader terms (followup). (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-08-06 [31eee18d7]
+ -->
+ <!--
+ 2025-07-16 [34b07c2d5]
+ -->
+ <para>
+ Fix example script link. (Taiki Koshino)
+ </para>
+ <para>
+ Modified the sample script in the section "<ulink url="https://www.pgpool.net/docs/46/en/html/example-cluster.html">8.2. Pgpool-II + Watchdog Setup Example</ulink>"
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-18 [f4ae9f39e]
+ 2025-06-18 [7a20dc419]
+ -->
+ <para>
+ Fix load balance explanation missed logical replication mode and Slony mode. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-18 [9d2e4e692]
+ -->
+ <para>
+ Enhance <xref linkend="pcp-node-info"> document. (Bo Peng)
+ </para>
+ <para>
+ Clarify that each <varname>backend_application_nameX</varname> must match the value specified
+ in the <varname>application_name</varname> of <varname>primary_conninfo</varname> to correctly display
+ "<varname>replication_state</varname>" and "<varname>replication_sync_state</varname>".
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-08 [59f9df005]
+ -->
+ <para>
+ Add section of kernel resources. (Tatsuo Ishii)
+ </para>
+ <para>
+ <productname>Pgpool-II</productname> uses System V shared memory and semaphores. It's better to
+ describe the requirements in the docs.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-07 [40617fd90]
+ -->
+ <para>
+ Add description for <option>--with-ldap</option> option of configure. (Tatsuo Ishii)
+ </para>
+ <para>
+ It was missed when LDAP support was introduced in v4.2
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-04 [ff60bf930]
+ -->
+ <para>
+ Clarify supported platforms for <productname>Pgpool-II</productname>. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-03 [cc4da5979]
+ -->
+ <para>
+ Enhance <xref linkend="guc-child-life-time"> document. (Tatsuo Ishii)
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Regression Tests</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-06-08 [78e45decf]
+ -->
+ <para>
+ Stabilize 029.cert_passphrase regression test. (Tatsuo Ishii)
+ </para>
+ <para>
+ When <varname>ssl_passphrase_command</varname> is not valid, the error message is
+ typically "bad decrypt" but it seems sometimes "wrong tag".
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+</sect1>
+
<sect1 id="release-4-4-12">
<title>Release 4.4.12</title>
<note>
diff --git a/doc/src/sgml/release-4.5.sgml b/doc/src/sgml/release-4.5.sgml
index 2f3966018..e60bd966a 100644
--- a/doc/src/sgml/release-4.5.sgml
+++ b/doc/src/sgml/release-4.5.sgml
@@ -1,3 +1,252 @@
+<sect1 id="release-4-5-8">
+ <title>Release 4.5.8</title>
+ <note>
+ <title>Release Date</title>
+ <simpara>2025-08-21</simpara>
+ </note>
+
+ <sect2>
+ <title>Bug fixes</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-07-25 [75d905ff9]
+ -->
+ <para>
+ Fix watchdog to print inappropriate NOTICE message. (Tatsuo Ishii)
+ </para>
+ <para>
+ <function>read_ipc_socket_and_process()</function> printed a notice message every time when
+ it wrote commands to IPC socket even if it was successful. Fix this to
+ print the notice message only when the write failed.
+
+ The reason why this bug was not recognized is, the message appears
+ only when <varname>log_min_messages</varname> is set to notice or higher.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/121">pgpool IPC socket connection issue</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-07-19 [d05de5c73]
+ -->
+ <!--
+ 2025-07-19 [ed57af34e]
+ -->
+ <para>
+ Fix resource leak while reading startup packet. (Tatsuo Ishii)
+ </para>
+ <para>
+ Fix resource leak in pool_push_pending_data.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-30 [bac455b2f]
+ -->
+ <para>
+ Fix broken scram-sha-256 authentication on big-endian machines. (Tatsuo Ishii)
+ </para>
+ <para>
+ When <literal>scram-sha-256</literal> authentication is performed, a hash function
+ <function>pg_sha_256_final</function> is used. It was imported from <productname>PostgreSQL</productname> and it uses
+ preprocessor define WORDS_BIGENDIAN to judge host machine's
+ endianness. Although WORDS_BIGENDIAN should be defined while
+ configure, this part was missed when <function>pg_sha_256_final</function> (and others) was
+ imported from <productname>PostgreSQL</productname>. As a result, <literal>scram-sha-256</literal> worked only in
+ little endian machines. Fixed the issue by adding
+ AC_C_BIGENDIAN macro to configure.ac.
+ </para>
+ <para>
+ Problem reported by Christoph Berg and analyzed by pranavkaruvally.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/106">4.6.1 fails on big-endian s390x: backend response with kind 'E' when expecting 'R'</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-23 [2721c7b76]
+ -->
+ <para>
+ Fix source code typos. (Bo Peng)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-09 [4305c42d6]
+ -->
+ <para>
+ Fix heartbeat device treatment. (Tatsuo Ishii)
+ </para>
+ <para>
+ While processing <filename>pgpool.conf</filename>, <varname>heartbeat_device</varname> was mistakenly treated
+ and the first device was ignored.
+ </para>
+ <para>
+ Problem analyzed by Bo Peng.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-02 [06ba7dde4]
+ -->
+ <para>
+ Fix typo in the comments of <filename>pgpool.conf</filename>. (Tatsuo Ishii)
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Documents</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-08-15 [a54f5d1ad]
+ -->
+ <para>
+ Enhance "8.3. Replication Mode and Snapshot Isolation Mode Configuration Example" Document. (Taiki Koshino)
+ </para>
+ <para>
+ Updated the link to the example script and the explanation in the "8.3.3. Before you begin" section.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-08-04 [e2f24fec8]
+ -->
+ <para>
+ Fix documentation for parameters that are not reflected by reload. (Taiki Koshino)
+ </para>
+ <para>
+ "authentication_timeout" and "memqcache_oiddir" is not reflected by reload.
+ The documentation is changed to "This parameter can only be set at server start.".
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-07-24 [bc5fa5e7e]
+ -->
+ <!--
+ 2025-07-23 [1e8963554]
+ -->
+ <para>
+ Unify watchdog leader terms (followup). (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-08-06 [31eee18d7]
+ -->
+ <!--
+ 2025-07-16 [34b07c2d5]
+ -->
+ <para>
+ Fix example script link. (Taiki Koshino)
+ </para>
+ <para>
+ Modified the sample script in the section "<ulink url="https://www.pgpool.net/docs/46/en/html/example-cluster.html">8.2. Pgpool-II + Watchdog Setup Example</ulink>"
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-18 [f4ae9f39e]
+ 2025-06-18 [7a20dc419]
+ -->
+ <para>
+ Fix load balance explanation missed logical replication mode and Slony mode. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-18 [9d2e4e692]
+ -->
+ <para>
+ Enhance <xref linkend="pcp-node-info"> document. (Bo Peng)
+ </para>
+ <para>
+ Clarify that each <varname>backend_application_nameX</varname> must match the value specified
+ in the <varname>application_name</varname> of <varname>primary_conninfo</varname> to correctly display
+ "<varname>replication_state</varname>" and "<varname>replication_sync_state</varname>".
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-08 [59f9df005]
+ -->
+ <para>
+ Add section of kernel resources. (Tatsuo Ishii)
+ </para>
+ <para>
+ <productname>Pgpool-II</productname> uses System V shared memory and semaphores. It's better to
+ describe the requirements in the docs.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-07 [40617fd90]
+ -->
+ <para>
+ Add description for <option>--with-ldap</option> option of configure. (Tatsuo Ishii)
+ </para>
+ <para>
+ It was missed when LDAP support was introduced in v4.2
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-04 [ff60bf930]
+ -->
+ <para>
+ Clarify supported platforms for <productname>Pgpool-II</productname>. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-03 [cc4da5979]
+ -->
+ <para>
+ Enhance <xref linkend="guc-child-life-time"> document. (Tatsuo Ishii)
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Regression Tests</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-06-08 [78e45decf]
+ -->
+ <para>
+ Stabilize 029.cert_passphrase regression test. (Tatsuo Ishii)
+ </para>
+ <para>
+ When <varname>ssl_passphrase_command</varname> is not valid, the error message is
+ typically "bad decrypt" but it seems sometimes "wrong tag".
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+</sect1>
+
<sect1 id="release-4-5-7">
<title>Release 4.5.7</title>
<note>
diff --git a/doc/src/sgml/release-4.6.sgml b/doc/src/sgml/release-4.6.sgml
index eb196bfa9..2f5514974 100644
--- a/doc/src/sgml/release-4.6.sgml
+++ b/doc/src/sgml/release-4.6.sgml
@@ -1,7 +1,336 @@
-<sect1 id="release-4-6-2">
- <title>Release 4.6.2</title>
+<sect1 id="release-4-6-3">
+ <title>Release 4.6.3</title>
<note>
<title>Release Date</title>
+ <simpara>2025-08-21</simpara>
+ </note>
+
+ <sect2>
+ <title>Changes</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-06-13 [ebfd2423c]
+ -->
+ <para>
+ Enhance connecting process to backend. (Tatsuo Ishii)
+ </para>
+ <para>
+ In certain environment (especially k8s), DNS look up is unstable and
+ connecting to backend process fails. This occurs in call to
+ <function>getaddrinfo()</function> in <function>connect_inet_domain_socket_by_port()</function>. To enhance the
+ situation, retry up to 5 times (at each retry, sleep 1 second) if
+ <function>getaddrinfo()</function> fails with EAI_AGAIN. Note that if
+ <function>connect_inet_domain_socket_by_port()</function> is called with "retry" argument
+ is false, the retry will not happen. Health check calls
+ <function>connect_inet_domain_socket_by_port()</function> with the retry flag to false so
+ that retrying is controlled health check's own parameters.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/104">A single DNS lookup failure will trigger backend failover</ulink>
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Bug fixes</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-07-25 [75d905ff9]
+ -->
+ <para>
+ Fix watchdog to print inappropriate NOTICE message. (Tatsuo Ishii)
+ </para>
+ <para>
+ <function>read_ipc_socket_and_process()</function> printed a notice message every time when
+ it wrote commands to IPC socket even if it was successful. Fix this to
+ print the notice message only when the write failed.
+
+ The reason why this bug was not recognized is, the message appears
+ only when <varname>log_min_messages</varname> is set to notice or higher.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/121">pgpool IPC socket connection issue</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-07-19 [d05de5c73]
+ -->
+ <!--
+ 2025-07-19 [ed57af34e]
+ -->
+ <para>
+ Fix resource leak while reading startup packet. (Tatsuo Ishii)
+ </para>
+ <para>
+ Fix resource leak in pool_push_pending_data.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-30 [bac455b2f]
+ -->
+ <para>
+ Fix broken scram-sha-256 authentication on big-endian machines. (Tatsuo Ishii)
+ </para>
+ <para>
+ When <literal>scram-sha-256</literal> authentication is performed, a hash function
+ <function>pg_sha_256_final</function> is used. It was imported from <productname>PostgreSQL</productname> and it uses
+ preprocessor define WORDS_BIGENDIAN to judge host machine's
+ endianness. Although WORDS_BIGENDIAN should be defined while
+ configure, this part was missed when <function>pg_sha_256_final</function> (and others) was
+ imported from <productname>PostgreSQL</productname>. As a result, <literal>scram-sha-256</literal> worked only in
+ little endian machines. Fixed the issue by adding
+ AC_C_BIGENDIAN macro to configure.ac.
+ </para>
+ <para>
+ Problem reported by Christoph Berg and analyzed by pranavkaruvally.
+ </para>
+ <para>
+ Discussion: <ulink url="https://github.com/pgpool/pgpool2/issues/106">4.6.1 fails on big-endian s390x: backend response with kind 'E' when expecting 'R'</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-23 [2721c7b76]
+ -->
+ <para>
+ Fix source code typos. (Bo Peng)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-14 [f88b1c18f]
+ -->
+ <para>
+ Fix heartbeat device treatment. (Tatsuo Ishii)
+ </para>
+ <para>
+ Fix <function>wd_create_hb_recv_socket()</function> and <function>wd_create_hb_send_socket()</function>
+ to pass a null-terminated device name string to setsockopt(SO_BINDTODEVICE)
+ instead of incorrectly passing a struct ifreq.
+ </para>
+ <para>
+ Discussion: <ulink url="https://www.pgpool.net/pipermail/pgpool-hackers/2025-May/004603.html">[pgpool-hackers: 4602] heartbeat and SO_BINDTODEVICE</ulink>
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-14 [73bcbd96e]
+ -->
+ <para>
+ Fix resource leak in hearbeat receiver process. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-09 [4305c42d6]
+ -->
+ <para>
+ Fix heartbeat device treatment. (Tatsuo Ishii)
+ </para>
+ <para>
+ While processing <filename>pgpool.conf</filename>, <varname>heartbeat_device</varname> was mistakenly treated
+ and the first device was ignored.
+ </para>
+ <para>
+ Problem analyzed by Bo Peng.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-05 [b249a118c]
+ -->
+ <para>
+ Fix heartbeat receiver not working. (Tatsuo Ishii)
+ </para>
+ <para>
+ IPv6 support for heartbeat was added in version 4.6,
+ but the receive process mistakenly bound only to loopback addresses,
+ preventing reception from other nodes.
+ Adding the AI_PASSIVE flag to <function>getaddrinfo()</function> fixes this by binding to all network interfaces.
+ </para>
+ <para>
+ Problem analyzed by Bo Peng.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-02 [06ba7dde4]
+ -->
+ <para>
+ Fix typo in the comments of <filename>pgpool.conf</filename>. (Tatsuo Ishii)
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Documents</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-08-15 [a54f5d1ad]
+ -->
+ <para>
+ Enhance "8.3. Replication Mode and Snapshot Isolation Mode Configuration Example" Document. (Taiki Koshino)
+ </para>
+ <para>
+ Updated the link to the example script and the explanation in the "8.3.3. Before you begin" section.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-08-04 [e2f24fec8]
+ -->
+ <para>
+ Fix documentation for parameters that are not reflected by reload. (Taiki Koshino)
+ </para>
+ <para>
+ "authentication_timeout" and "memqcache_oiddir" is not reflected by reload.
+ The documentation is changed to "This parameter can only be set at server start.".
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-07-24 [bc5fa5e7e]
+ -->
+ <!--
+ 2025-07-23 [1e8963554]
+ -->
+ <para>
+ Unify watchdog leader terms (followup). (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-08-06 [31eee18d7]
+ -->
+ <!--
+ 2025-07-16 [34b07c2d5]
+ -->
+ <para>
+ Fix example script link. (Taiki Koshino)
+ </para>
+ <para>
+ Modified the sample script in the section "<ulink url="https://www.pgpool.net/docs/46/en/html/example-cluster.html">8.2. Pgpool-II + Watchdog Setup Example</ulink>"
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-18 [f4ae9f39e]
+ 2025-06-18 [7a20dc419]
+ -->
+ <para>
+ Fix load balance explanation missed logical replication mode and Slony mode. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-18 [9d2e4e692]
+ -->
+ <para>
+ Enhance <xref linkend="pcp-node-info"> document. (Bo Peng)
+ </para>
+ <para>
+ Clarify that each <varname>backend_application_nameX</varname> must match the value specified
+ in the <varname>application_name</varname> of <varname>primary_conninfo</varname> to correctly display
+ "<varname>replication_state</varname>" and "<varname>replication_sync_state</varname>".
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-08 [59f9df005]
+ -->
+ <para>
+ Add section of kernel resources. (Tatsuo Ishii)
+ </para>
+ <para>
+ <productname>Pgpool-II</productname> uses System V shared memory and semaphores. It's better to
+ describe the requirements in the docs.
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-07 [40617fd90]
+ -->
+ <para>
+ Add description for <option>--with-ldap</option> option of configure. (Tatsuo Ishii)
+ </para>
+ <para>
+ It was missed when LDAP support was introduced in v4.2
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-05 [9ee9eb164]
+ -->
+ <para>
+ Fix command in "8.2. <productname>Pgpool-II</productname> + Watchdog Setup Example" to escape $PGDATA. (Bo Peng)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-04 [ff60bf930]
+ -->
+ <para>
+ Clarify supported platforms for <productname>Pgpool-II</productname>. (Tatsuo Ishii)
+ </para>
+ </listitem>
+
+ <listitem>
+ <!--
+ 2025-06-03 [cc4da5979]
+ -->
+ <para>
+ Enhance <xref linkend="guc-child-life-time"> document. (Tatsuo Ishii)
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+
+ <sect2>
+ <title>Regression Tests</title>
+ <itemizedlist>
+ <listitem>
+ <!--
+ 2025-06-08 [78e45decf]
+ -->
+ <para>
+ Stabilize 029.cert_passphrase regression test. (Tatsuo Ishii)
+ </para>
+ <para>
+ When <varname>ssl_passphrase_command</varname> is not valid, the error message is
+ typically "bad decrypt" but it seems sometimes "wrong tag".
+ </para>
+ </listitem>
+ </itemizedlist>
+ </sect2>
+</sect1>
+
+<sect1 id="release-4-6-2">
+ <title>Release 4.6.2</title>
+ <note> <title>Release Date</title>
<simpara>2025-05-30</simpara>
</note>