pgpool2.git / summary / log / commit / refs
commit d07aac37a22d8d2f9fbe3bba5c8f1e9c9ffef69d
Author: Bo Peng <pengbo@sraoss.co.jp>
Date: Sun Dec 05 16:55:34 2021 +0000
Doc: update documentation "Pgpool-II + Watchdog Setup Example".
doc.ja/src/sgml/example-cluster.sgml | 46 +++------
doc/src/sgml/example-cluster.sgml | 189 ++++++++++++++++-------------------
2 files changed, 97 insertions(+), 138 deletions(-)
diff --git a/doc.ja/src/sgml/example-cluster.sgml b/doc.ja/src/sgml/example-cluster.sgml
index 56d2dd85a..b5fee16d5 100644
--- a/doc.ja/src/sgml/example-cluster.sgml
+++ b/doc.ja/src/sgml/example-cluster.sgml
@@ -10,7 +10,7 @@
</para>
<para>
この設定例では<productname>PostgreSQL</productname> 14を使っていますが、
- 各種スクリプトは<productname>PostgreSQL</productname> 9.6以降での動作確認を行っています。
+ 各種スクリプトは<productname>PostgreSQL</productname> 10以降での動作確認を行っています。
</para>
<sect2 id="example-cluster-requirement">
<title>前提条件</title>
@@ -24,7 +24,7 @@
<title>全体構成</title>
<para>
今回は、Linuxサーバを3台用意し、それぞれのホスト名は 「server1」、「server2」、「server3」 とします。
- 使用するOSはすべてCentOS 7.4とします。
+ 使用するOSはすべてCentOS 7.9とします。
それぞれのサーバに<productname>PostgreSQL</productname>と<productname>Pgpool-II</productname>をインストールします。
3台の<productname>PostgreSQL</productname>がストリーミングレプリケーション構成になります。全体構成図は以下の通りです。
</para>
@@ -506,6 +506,10 @@ server3:5432:postgres:postgres:<postgresユーザのパスワード>
<sect2 id="example-cluster-pgpool-config">
<title><productname>Pgpool-II</productname>の設定</title>
+ <para>
+ RPMからインストールした場合、<productname>Pgpool-II</productname>の設定ファイル
+ <filename>pgpool.conf</filename>は<filename>/etc/pgpool-II</filename>にあります。
+ </para>
<para>
<productname>Pgpool-II</productname> 4.2以降、すべての設定パラメーターがすべてのホストで同一になったので、
どれか一つのノード上で<filename>pgpool.conf</filename>を編集し、
@@ -519,13 +523,6 @@ server3:5432:postgres:postgres:<postgresユーザのパスワード>
クラスタリングモードの設定には<xref linkend="GUC-BACKEND-CLUSTERING-MODE">を使用します。
今回の設定例では、ストリーミングレプリケーションモードを設定します。
</para>
- <para>
- RPMからインストールした場合、<productname>Pgpool-II</productname>のサンプル設定ファイルは
- <filename>/etc/pgpool-II</filename>にあります。
- </para>
- <programlisting>
-[server1]# cp -p /etc/pgpool-II/pgpool.conf.sample /etc/pgpool-II/pgpool.conf
- </programlisting>
<programlisting>
backend_clustering_mode = 'streaming_replication'
</programlisting>
@@ -584,14 +581,9 @@ sr_check_password = ''
</para>
<programlisting>
health_check_period = 5
- # Health check period
- # Disabled (0) by default
health_check_timeout = 30
- # Health check timeout
- # 0 means no timeout
health_check_user = 'pgpool'
health_check_password = ''
-
health_check_max_retries = 3
</programlisting>
</sect3>
@@ -608,16 +600,11 @@ health_check_max_retries = 3
# - Backend Connection Settings -
backend_hostname0 = 'server1'
- # Host name or IP address to connect to for backend 0
backend_port0 = 5432
- # Port number for backend 0
backend_weight0 = 1
- # Weight for backend 0 (only in load balancing mode)
backend_data_directory0 = '/var/lib/pgsql/14/data'
- # Data directory for backend 0
backend_flag0 = 'ALLOW_TO_FAILOVER'
- # Controls various backend behavior
- # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER
+
backend_hostname1 = 'server2'
backend_port1 = 5432
backend_weight1 = 1
@@ -751,9 +738,7 @@ PCP_USER=pgpool
</para>
<programlisting>
recovery_user = 'postgres'
- # Online recovery user
recovery_password = ''
- # Online recovery password
recovery_1st_stage_command = 'recovery_1st_stage'
</programlisting>
@@ -940,15 +925,8 @@ arping_path = '/usr/sbin'
</para>
<programlisting>
hostname0 = 'server1'
- # Host name or IP address of pgpool node
- # for watchdog connection
- # (change requires restart)
wd_port0 = 9000
- # Port number for watchdog service
- # (change requires restart)
pgpool_port0 = 9999
- # Port number for pgpool
- # (change requires restart)
hostname1 = 'server2'
wd_port1 = 9000
@@ -1148,7 +1126,7 @@ OPTS=" -D -n"
</itemizedlist>
</sect2>
- <sect2 id="example-cluster-try">
+ <sect2 id="example-cluster-verify">
<title>動作確認</title>
<para>
これから、動作確認を行います。
@@ -1159,7 +1137,7 @@ OPTS=" -D -n"
# systemctl start pgpool.service
</programlisting>
- <sect3 id="example-cluster-try-standby">
+ <sect3 id="example-cluster-verify-standby">
<title>PostgreSQL スタンバイサーバを構築</title>
<para>
まず、<productname>Pgpool-II</productname>のオンラインリカバリ機能を利用し、スタンバイサーバを構築します。
@@ -1193,7 +1171,7 @@ Password for user pgpool:
</programlisting>
</sect3>
- <sect3 id="example-cluster-try-watchdog">
+ <sect3 id="example-cluster-verify-watchdog">
<title>Watchdogアクティブ/スタンバイの切り替え</title>
<para>
<command>pcp_watchdog_info</command>で<productname>Pgpool-II</productname>
@@ -1243,7 +1221,7 @@ server3:9999 Linux server3 server3 9999 9000 7 STANDBY
</programlisting>
</sect3>
- <sect3 id="example-cluster-try-failover">
+ <sect3 id="example-cluster-verify-failover">
<title>自動フェイルオーバ</title>
<para>
<command>psql</command>で仮想IPに接続し、バックエンドの情報を確認します。
@@ -1320,7 +1298,7 @@ reply_time | 2021-10-19 07:11:53.886477+00
</programlisting>
</sect3>
- <sect3 id="example-cluster-try-online-recovery">
+ <sect3 id="example-cluster-verify-online-recovery">
<title>オンラインリカバリ</title>
<para>
次に、<productname>Pgpool-II</productname>のオンラインリカバリ機能を利用し、
diff --git a/doc/src/sgml/example-cluster.sgml b/doc/src/sgml/example-cluster.sgml
index 6c10c579d..ddda34d01 100644
--- a/doc/src/sgml/example-cluster.sgml
+++ b/doc/src/sgml/example-cluster.sgml
@@ -7,8 +7,8 @@
servers to create a robust cluster system and avoid the single point of failure or split brain.
</para>
<para>
- <productname>PostgreSQL</productname> 13 is used in this configuration example.
- All scripts have been tested with <productname>PostgreSQL</productname> 95 and later.
+ <productname>PostgreSQL</productname> 14 is used in this configuration example.
+ All scripts have been tested with <productname>PostgreSQL</productname> 10 and later.
</para>
<sect2 id="example-cluster-requirement">
<title>Requirements</title>
@@ -20,8 +20,8 @@
<sect2 id="example-cluster-structure">
<title>Cluster System Configuration</title>
<para>
- We use 3 servers with CentOS 7.4. Let these servers be <literal>server1</literal>,
- <literal>server2</literal>, <literal>server3</literal>.
+ We use 3 servers with CentOS 7.9 installed. Let these servers be <literal>server1</literal>
+ <literal>server2</literal>, <literal>server3</literal>.
We install <productname>PostgreSQL</productname> and <productname>Pgpool-II</productname> on each server.
</para>
<para>
@@ -81,7 +81,7 @@
<tbody>
<row>
<entry>PostgreSQL Version</entry>
- <entry>13.0</entry>
+ <entry>14.0</entry>
<entry>-</entry>
</row>
<row>
@@ -91,7 +91,7 @@
</row>
<row>
<entry>$PGDATA</entry>
- <entry>/var/lib/pgsql/13/data</entry>
+ <entry>/var/lib/pgsql/14/data</entry>
<entry>-</entry>
</row>
<row>
@@ -126,7 +126,7 @@
<tbody>
<row>
<entry>Pgpool-II Version</entry>
- <entry>4.2.0</entry>
+ <entry>4.3.0</entry>
<entry>-</entry>
</row>
<row>
@@ -220,7 +220,7 @@
<sect2 id="example-cluster-installation">
<title>Installation</title>
<para>
- In this example, we install <productname>Pgpool-II</productname> 4.2 and <productname>PostgreSQL</productname> 13.0 using RPM packages.
+ In this example, we install <productname>Pgpool-II</productname> 4.3 and <productname>PostgreSQL</productname> 14.0 using RPM packages.
</para>
<para>
@@ -228,14 +228,14 @@
</para>
<programlisting>
# yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
-# yum install -y postgresql13-server
+# yum install -y postgresql14-server
</programlisting>
<para>
Install <productname>Pgpool-II</productname> by using Pgpool-II YUM repository.
</para>
<programlisting>
# yum install -y https://www.pgpool.net/yum/rpms/4.3/redhat/rhel-7-x86_64/pgpool-II-release-4.3-1.noarch.rpm
-# yum install -y pgpool-II-pg13-*
+# yum install -y pgpool-II-pg14-*
</programlisting>
</sect2>
@@ -381,7 +381,7 @@ host replication all samenet scram-sha-256
[all servers]$ ssh-copy-id -i id_rsa_pgpool.pub postgres@server3
</programlisting>
<para>
- After setting, use <command>ssh postgres@serverX -i ~/.ssh/id_rsa_pgpool</command> command to
+ After setting SSH, use <command>ssh postgres@serverX -i ~/.ssh/id_rsa_pgpool</command> command to
make sure that you can log in without entering a password. Edit <filename>/etc/ssh/sshd_config</filename>
if necessary and restart sshd.
</para>
@@ -429,8 +429,13 @@ server3:5432:postgres:postgres:<postgres user passowrd>
<note>
<para>
- If you set the auto-start of <productname>Pgpool-II</productname>, you need to change the <xref linkend="guc-search-primary-node-timeout"> to an appropriate value that you can start the <productname>PostgreSQL</productname> after the server has been started.
- <productname>Pgpool-II</productname> will fail if it can't connect to the <productname>PostgreSQL</productname> on the backend during the <literal>search_primary_node_timeout</literal>.
+ If you set the auto-start of <productname>Pgpool-II</productname>, you need to
+ change the <xref linkend="guc-search-primary-node-timeout"> to an appropriate
+ value that you can start the <productname>PostgreSQL</productname> after the
+ server has been started.
+ <productname>Pgpool-II</productname> will fail if it can't connect to the
+ <productname>PostgreSQL</productname> on the backend during the
+ <literal>search_primary_node_timeout</literal>.
</para>
</note>
@@ -480,6 +485,11 @@ server3:5432:postgres:postgres:<postgres user passowrd>
<sect2 id="example-cluster-pgpool-config">
<title><productname>Pgpool-II</productname> Configuration</title>
+ <para>
+ When installing <productname>Pgpool-II</productname> using YUM, the
+ <productname>Pgpool-II</productname> configuration file <filename>pgpool.conf</filename>
+ is installed in <filename>/etc/pgpool-II</filename>.
+ </para>
<para>
Since from <productname>Pgpool-II</productname> 4.2, all configuration parameters are
identical on all hosts, you can edit <filename>pgpool.conf</filename> on any pgpool node
@@ -493,15 +503,6 @@ server3:5432:postgres:postgres:<postgres user passowrd>
mode, <xref linkend="GUC-BACKEND-CLUSTERING-MODE"> can be used. In this configuration
example, streaming replication mode is used.
</para>
- <para>
- When installing <productname>Pgpool-II</productname> using RPM, the
- <productname>Pgpool-II</productname> configuration sample files are in
- <filename>/etc/pgpool-II</filename>.
- In this example, we copy the sample configuration file for streaming replication mode.
- </para>
- <programlisting>
-# cp -p /etc/pgpool-II/pgpool.conf.sample /etc/pgpool-II/pgpool.conf
- </programlisting>
<programlisting>
backend_clustering_mode = 'streaming_replication'
</programlisting>
@@ -556,14 +557,9 @@ sr_check_password = ''
</para>
<programlisting>
health_check_period = 5
- # Health check period
- # Disabled (0) by default
health_check_timeout = 30
- # Health check timeout
- # 0 means no timeout
health_check_user = 'pgpool'
health_check_password = ''
-
health_check_max_retries = 3
</programlisting>
</sect3>
@@ -578,26 +574,21 @@ health_check_max_retries = 3
# - Backend Connection Settings -
backend_hostname0 = 'server1'
- # Host name or IP address to connect to for backend 0
backend_port0 = 5432
- # Port number for backend 0
backend_weight0 = 1
- # Weight for backend 0 (only in load balancing mode)
-backend_data_directory0 = '/var/lib/pgsql/13/data'
- # Data directory for backend 0
+backend_data_directory0 = '/var/lib/pgsql/14/data'
backend_flag0 = 'ALLOW_TO_FAILOVER'
- # Controls various backend behavior
- # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER
+
backend_hostname1 = 'server2'
backend_port1 = 5432
backend_weight1 = 1
-backend_data_directory1 = '/var/lib/pgsql/13/data'
+backend_data_directory1 = '/var/lib/pgsql/14/data'
backend_flag1 = 'ALLOW_TO_FAILOVER'
backend_hostname2 = 'server3'
backend_port2 = 5432
backend_weight2 = 1
-backend_data_directory2 = '/var/lib/pgsql/13/data'
+backend_data_directory2 = '/var/lib/pgsql/14/data'
backend_flag2 = 'ALLOW_TO_FAILOVER'
</programlisting>
<para>
@@ -630,7 +621,7 @@ backend_application_name2 = 'server3'
</para>
<programlisting>
failover_command = '/etc/pgpool-II/failover.sh %d %h %p %D %m %H %M %P %r %R %N %S'
-follow_primary_command = '/etc/pgpool-II/follow_primary.sh %d %h %p %D %m %H %M %P %r %R'
+follow_primary_command = '/etc/pgpool-II/follow_primary.sh %d %h %p %D %m %H %M %P %r %R
</programlisting>
<note>
<para>
@@ -654,12 +645,12 @@ follow_primary_command = '/etc/pgpool-II/follow_primary.sh %d %h %p %D %m %H %M
<programlisting>
[all servers]# vi /etc/pgpool-II/failover.sh
...
-PGHOME=/usr/pgsql-13
+PGHOME=/usr/pgsql-14
...
[all servers]# vi /etc/pgpool-II/follow_primary.sh
...
-PGHOME=/usr/pgsql-13
+PGHOME=/usr/pgsql-14
...
</programlisting>
@@ -716,10 +707,7 @@ PCP_USER=pgpool
</para>
<programlisting>
recovery_user = 'postgres'
- # Online recovery user
recovery_password = ''
- # Online recovery password
-
recovery_1st_stage_command = 'recovery_1st_stage'
</programlisting>
<para>
@@ -728,29 +716,29 @@ recovery_1st_stage_command = 'recovery_1st_stage'
are installed in <filename>/etc/pgpool-II/</filename>. Copy these files to the data directory of the primary server (server1).
</para>
<programlisting>
-[server1]# cp -p /etc/pgpool-II/recovery_1st_stage.sample /var/lib/pgsql/13/data/recovery_1st_stage
-[server1]# cp -p /etc/pgpool-II/pgpool_remote_start.sample /var/lib/pgsql/13/data/pgpool_remote_start
-[server1]# chown postgres:postgres /var/lib/pgsql/13/data/{recovery_1st_stage,pgpool_remote_start}
+[server1]# cp -p /etc/pgpool-II/recovery_1st_stage.sample /var/lib/pgsql/14/data/recovery_1st_stage
+[server1]# cp -p /etc/pgpool-II/pgpool_remote_start.sample /var/lib/pgsql/14/data/pgpool_remote_start
+[server1]# chown postgres:postgres /var/lib/pgsql/14/data/{recovery_1st_stage,pgpool_remote_start}
</programlisting>
<para>
Basically, it should work if you change <emphasis>PGHOME</emphasis> according to PostgreSQL installation directory.
</para>
<programlisting>
-[server1]# vi /var/lib/pgsql/13/data/recovery_1st_stage
+[server1]# vi /var/lib/pgsql/14/data/recovery_1st_stage
...
-PGHOME=/usr/pgsql-13
+PGHOME=/usr/pgsql-14
...
-[server1]# vi /var/lib/pgsql/13/data/pgpool_remote_start
+[server1]# vi /var/lib/pgsql/14/data/pgpool_remote_start
...
-PGHOME=/usr/pgsql-13
+PGHOME=/usr/pgsql-14
...
</programlisting>
<para>
In order to use the online recovery functionality, the functions of
<function>pgpool_recovery</function>, <function>pgpool_remote_start</function>,
- <function>pgpool_switch_xlog</function> are required, so we need install
+ <function>pgpool_switch_xlog</function> are required, so we need to install
<function>pgpool_recovery</function> on template1 of <productname>PostgreSQL</productname> server
<literal>server1</literal>.
</para>
@@ -893,15 +881,8 @@ arping_path = '/usr/sbin'
</para>
<programlisting>
hostname0 = 'server1'
- # Host name or IP address of pgpool node
- # for watchdog connection
- # (change requires restart)
wd_port0 = 9000
- # Port number for watchdog service
- # (change requires restart)
pgpool_port0 = 9999
- # Port number for pgpool
- # (change requires restart)
hostname1 = 'server2'
wd_port1 = 9000
@@ -1067,10 +1048,10 @@ OPTS=" -D -n"
<sect2 id="example-cluster-start-stop">
<title>Starting/Stopping Pgpool-II</title>
<para>
- Next we start <productname>Pgpool-II</productname>. Before starting
- <productname>Pgpool-II</productname>, please start
- <productname>PostgreSQL</productname> servers first.
- Also, when stopping <productname>PostgreSQL</productname>, it is necessary to
+ Next we start <productname>Pgpool-II</productname>. Before starting
+ <productname>Pgpool-II</productname>, please start
+ <productname>PostgreSQL</productname> servers first.
+ Also, when stopping <productname>PostgreSQL</productname>, it is necessary to
stop Pgpool-II first.
</para>
<itemizedlist>
@@ -1098,18 +1079,18 @@ OPTS=" -D -n"
</itemizedlist>
</sect2>
- <sect2 id="example-cluster-try">
+ <sect2 id="example-cluster-verify">
<title>How to use</title>
<para>
- Let's start to use <productname>Pgpool-II</productname>.
- First, let's start <productname>Pgpool-II</productname> on <literal>server1</literal>,
+ Let's start to use <productname>Pgpool-II</productname>.
+ First, let's start <productname>Pgpool-II</productname> on <literal>server1</literal>,
<literal>server2</literal>, <literal>server3</literal> by using the following command.
</para>
<programlisting>
# systemctl start pgpool.service
</programlisting>
- <sect3 id="example-cluster-try-standby">
+ <sect3 id="example-cluster-verify-standby">
<title>Set up PostgreSQL standby server</title>
<para>
First, we should set up <productname>PostgreSQL</productname> standby server by
@@ -1135,16 +1116,16 @@ pcp_recovery_node -- Command Successful
<programlisting>
# psql -h 192.168.137.150 -p 9999 -U pgpool postgres -c "show pool_nodes"
Password for user pgpool
-node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
----------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
-0 | server1 | 5432 | up | 0.333333 | primary | 0 | false | 0 | | | 2019-08-06 11:13:17
-1 | server2 | 5432 | up | 0.333333 | standby | 0 | true | 0 | streaming | async | 2019-08-06 11:13:25
-2 | server3 | 5432 | up | 0.333333 | standby | 0 | false | 0 | streaming | async | 2019-08-06 11:14:20
+ node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
+---------+----------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
+ 0 | server1 | 5432 | up | up | 0.333333 | primary | primary | 0 | false | 0 | | | 2021-10-19 07:00:57
+ 1 | server2 | 5432 | up | up | 0.333333 | standby | standby | 0 | true | 0 | streaming | async | 2021-10-19 07:00:57
+ 2 | server3 | 5432 | up | up | 0.333333 | standby | standby | 0 | false | 0 | streaming | async | 2021-10-19 07:00:57
(3 rows)
</programlisting>
</sect3>
- <sect3 id="example-cluster-try-watchdog">
+ <sect3 id="example-cluster-verify-watchdog">
<title>Switching active/standby watchdog</title>
<para>
Confirm the watchdog status by using <command>pcp_watchdog_info</command>. The <command>Pgpool-II</command> server which is started first run as <literal>LEADER</literal>.
@@ -1192,7 +1173,7 @@ server3:9999 Linux server3 server3 9999 9000 7 STANDBY 0 MEMBER
</programlisting>
</sect3>
- <sect3 id="example-cluster-try-failover">
+ <sect3 id="example-cluster-verify-failover">
<title>Failover</title>
<para>
First, use <command>psql</command> to connect to <productname>PostgreSQL</productname> via virtual IP,
@@ -1201,11 +1182,11 @@ server3:9999 Linux server3 server3 9999 9000 7 STANDBY 0 MEMBER
<programlisting>
# psql -h 192.168.137.150 -p 9999 -U pgpool postgres -c "show pool_nodes"
Password for user pgpool:
-node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
----------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
-0 | server1 | 5432 | up | 0.333333 | primary | 0 | false | 0 | | | 2019-08-06 11:13:17
-1 | server2 | 5432 | up | 0.333333 | standby | 0 | true | 0 | streaming | async | 2019-08-06 11:13:25
-2 | server3 | 5432 | up | 0.333333 | standby | 0 | false | 0 | streaming | async | 2019-08-06 11:14:20
+ node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
+---------+----------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
+ 0 | server1 | 5432 | up | up | 0.333333 | primary | primary | 0 | false | 0 | | | 2021-10-19 07:08:14
+ 1 | server2 | 5432 | up | up | 0.333333 | standby | standby | 0 | false | 0 | streaming | async | 2021-10-19 07:08:14
+ 2 | server3 | 5432 | up | up | 0.333333 | standby | standby | 0 | true | 0 | streaming | async | 2021-10-19 07:08:14
(3 rows)
</programlisting>
<para>
@@ -1223,11 +1204,11 @@ node_id | hostname | port | status | lb_weight | role | select_cnt | load_bal
<programlisting>
# psql -h 192.168.137.150 -p 9999 -U pgpool postgres -c "show pool_nodes"
Password for user pgpool:
-node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
----------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
-0 | server1 | 5432 | down | 0.333333 | standby | 0 | false | 0 | | | 2019-08-06 11:36:03
-1 | server2 | 5432 | up | 0.333333 | primary | 0 | true | 0 | | | 2019-08-06 11:36:03
-2 | server3 | 5432 | up | 0.333333 | standby | 0 | false | 0 | streaming | async | 2019-08-06 11:36:15
+ node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
+---------+----------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
+ 0 | server1 | 5432 | down | down | 0.333333 | standby | unknown | 0 | false | 0 | | | 2021-10-19 07:10:01
+ 1 | server2 | 5432 | up | up | 0.333333 | primary | primary | 0 | false | 0 | | | 2021-10-19 07:10:01
+ 2 | server3 | 5432 | up | up | 0.333333 | standby | standby | 0 | true | 0 | streaming | async | 2021-10-19 07:10:03
(3 rows)
</programlisting>
<para>
@@ -1247,36 +1228,36 @@ f
[server2]# psql -h server2 -p 5432 -U pgpool postgres -c "select * from pg_stat_replication" -x
-[ RECORD 1 ]----+------------------------------
-pid | 11059
-usesysid | 16392
+pid | 7198
+usesysid | 16385
usename | repl
application_name | server3
client_addr | 192.168.137.103
-client_hostname |
-client_port | 48694
-backend_start | 2019-08-06 11:36:07.479161+09
-backend_xmin |
+client_hostname |
+client_port | 40916
+backend_start | 2021-10-19 07:10:03.067241+00
+backend_xmin |
state | streaming
-sent_lsn | 0/75000148
-write_lsn | 0/75000148
-flush_lsn | 0/75000148
-replay_lsn | 0/75000148
-write_lag |
-flush_lag |
-replay_lag |
+sent_lsn | 0/12000260
+write_lsn | 0/12000260
+flush_lsn | 0/12000260
+replay_lsn | 0/12000260
+write_lag |
+flush_lag |
+replay_lag |
sync_priority | 0
sync_state | async
-reply_time | 2019-08-06 11:42:59.823961+09
+reply_time | 2021-10-19 07:11:53.886477+00
</programlisting>
</sect3>
- <sect3 id="example-cluster-try-online-recovery">
+ <sect3 id="example-cluster-verify-online-recovery">
<title>Online Recovery</title>
<para>
Here, we use <productname>Pgpool-II</productname> online recovery functionality to
- restore <literal>server1</literal> (old primary server) as a standby. Before
- restoring the old primary server, please ensure that
- <filename>recovery_1st_stage</filename> and <filename>pgpool_remote_start</filename> scripts
+ restore <literal>server1</literal> (old primary server) as a standby. Before
+ restoring the old primary server, please ensure that
+ <filename>recovery_1st_stage</filename> and <filename>pgpool_remote_start</filename> scripts
exist in database cluster directory of current primary server <literal>server2</literal>.
</para>
<programlisting>
@@ -1291,10 +1272,10 @@ pcp_recovery_node -- Command Successful
# psql -h 192.168.137.150 -p 9999 -U pgpool postgres -c "show pool_nodes"
Password for user pgpool:
node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
----------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
-0 | server1 | 5432 | up | 0.333333 | standby | 0 | false | 0 | streaming | async | 2019-08-06 11:48:05
-1 | server2 | 5432 | up | 0.333333 | primary | 0 | false | 0 | | | 2019-08-06 11:36:03
-2 | server3 | 5432 | up | 0.333333 | standby | 0 | true | 0 | streaming | async | 2019-08-06 11:36:15
+---------+----------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
+ 0 | server1 | 5432 | up | up | 0.333333 | standby | standby | 0 | true | 0 | streaming | async | 2021-10-19 07:14:06
+ 1 | server2 | 5432 | up | up | 0.333333 | primary | primary | 0 | false | 0 | | | 2021-10-19 07:10:01
+ 2 | server3 | 5432 | up | up | 0.333333 | standby | standby | 0 | false | 0 | streaming | async | 2021-10-19 07:10:03
(3 rows)
</programlisting>
</sect3>
[parent: f7c44fcc58d9]