From e993461b08f479b08a41391cdfd6e1a1fc2ccfcf Mon Sep 17 00:00:00 2001 From: Bo Peng Date: Mon, 1 Feb 2021 23:29:29 +0900 Subject: [PATCH] Doc: mention that the sample scripts doesn't support tablespaces in "Pgpool-II + Watchdog Setup Example". --- doc.ja/src/sgml/example-cluster.sgml | 12 ++++++++++++ doc/src/sgml/example-cluster.sgml | 24 ++++++++++++++++++------ 2 files changed, 30 insertions(+), 6 deletions(-) diff --git a/doc.ja/src/sgml/example-cluster.sgml b/doc.ja/src/sgml/example-cluster.sgml index 79abcc565..2fb31ecd6 100644 --- a/doc.ja/src/sgml/example-cluster.sgml +++ b/doc.ja/src/sgml/example-cluster.sgml @@ -646,6 +646,12 @@ PCP_USER=pgpool [全サーバ]$ echo 'localhost:9898:pgpool:<pgpool user password>' > ~/.pcppass [全サーバ]$ chmod 600 ~/.pcppass + + + follow_primary.shスクリプトはテーブルスペースに対応していません。 + テーブルスペースを使っている場合は、スクリプトを自分で変更する必要があります。 + + @@ -694,6 +700,12 @@ PGHOME=/usr/pgsql-13 [server1]# su - postgres [server1]$ psql template1 -c "CREATE EXTENSION pgpool_recovery" + + + recovery_1st_stageスクリプトはテーブルスペースに対応していません。 + テーブルスペースを使っている場合は、スクリプトを自分で変更する必要があります。 + + diff --git a/doc/src/sgml/example-cluster.sgml b/doc/src/sgml/example-cluster.sgml index ca195fce9..b837f8d55 100644 --- a/doc/src/sgml/example-cluster.sgml +++ b/doc/src/sgml/example-cluster.sgml @@ -690,17 +690,23 @@ PCP_USER=pgpool [all servers]$ echo 'localhost:9898:pgpool:<pgpool user password>' > ~/.pcppass [all servers]$ chmod 600 ~/.pcppass + + + The follow_primary.sh script does not support tablespaces. + If you are using tablespaces, you need to modify the script to support tablespaces. + + Pgpool-II Online Recovery Configurations - Next, in order to perform online recovery with Pgpool-II we specify + Next, in order to perform online recovery with Pgpool-II we specify the PostgreSQL user name and online recovery command recovery_1st_stage. Because Superuser privilege in PostgreSQL is required for performing online recovery, we specify postgres user in . - Then, we create recovery_1st_stage and pgpool_remote_start + Then, we create recovery_1st_stage and pgpool_remote_start in database cluster directory of PostgreSQL primary server (server1), and add execute permission. @@ -738,16 +744,22 @@ PGHOME=/usr/pgsql-13 - In order to use the online recovery functionality, the functions of - pgpool_recovery, pgpool_remote_start, - pgpool_switch_xlog are required, so we need install - pgpool_recovery on template1 of PostgreSQL server + In order to use the online recovery functionality, the functions of + pgpool_recovery, pgpool_remote_start, + pgpool_switch_xlog are required, so we need install + pgpool_recovery on template1 of PostgreSQL server server1. [server1]# su - postgres [server1]$ psql template1 -c "CREATE EXTENSION pgpool_recovery" + + + The recovery_1st_stage script does not support tablespaces. + If you are using tablespaces, you need to modify the script to support tablespaces. + + -- 2.39.5