pgpool2.git / summary / log / commit / refs

commit    e993461b08f479b08a41391cdfd6e1a1fc2ccfcf
Author:   Bo Peng <pengbo@sraoss.co.jp>
Date:     Mon Feb 01 14:29:29 2021 +0000

    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:&lt;pgpool user password&gt;' &gt; ~/.pcppass [全サーバ]$ chmod 600 ~/.pcppass </programlisting> + <note> + <para> + <filename>follow_primary.sh</filename>スクリプトはテーブルスペースに対応していません。 + テーブルスペースを使っている場合は、スクリプトを自分で変更する必要があります。 + </para> + </note> </sect3> <sect3 id="example-cluster-pgpool-config-online-recovery"> @@ -694,6 +700,12 @@ PGHOME=/usr/pgsql-13 [server1]# su - postgres [server1]$ psql template1 -c "CREATE EXTENSION pgpool_recovery" </programlisting> + <note> + <para> + <filename>recovery_1st_stage</filename>スクリプトはテーブルスペースに対応していません。 + テーブルスペースを使っている場合は、スクリプトを自分で変更する必要があります。 + </para> + </note> </sect3> <sect3 id="example-cluster-pgpool-config-auth"> 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:&lt;pgpool user password&gt;' &gt; ~/.pcppass [all servers]$ chmod 600 ~/.pcppass </programlisting> + <note> + <para> + The <filename>follow_primary.sh</filename> script does not support tablespaces. + If you are using tablespaces, you need to modify the script to support tablespaces. + </para> + </note> </sect3> <sect3 id="example-cluster-pgpool-config-online-recovery"> <title>Pgpool-II Online Recovery Configurations</title> <para> - Next, in order to perform online recovery with <productname>Pgpool-II</productname> we specify + Next, in order to perform online recovery with <productname>Pgpool-II</productname> we specify the <productname>PostgreSQL</productname> user name and online recovery command <command>recovery_1st_stage</command>. Because <emphasis>Superuser</emphasis> privilege in <productname>PostgreSQL</productname> is required for performing online recovery, we specify <literal>postgres</literal> user in <xref linkend="GUC-RECOVERY-USER">. - Then, we create <filename>recovery_1st_stage</filename> and <filename>pgpool_remote_start</filename> + Then, we create <filename>recovery_1st_stage</filename> and <filename>pgpool_remote_start</filename> in database cluster directory of <productname>PostgreSQL</productname> primary server (server1), and add execute permission. </para> @@ -738,16 +744,22 @@ PGHOME=/usr/pgsql-13 </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_recovery</function> on template1 of <productname>PostgreSQL</productname> server + 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_recovery</function> on template1 of <productname>PostgreSQL</productname> server <literal>server1</literal>. </para> <programlisting> [server1]# su - postgres [server1]$ psql template1 -c "CREATE EXTENSION pgpool_recovery" </programlisting> + <note> + <para> + The <filename>recovery_1st_stage</filename> script does not support tablespaces. + If you are using tablespaces, you need to modify the script to support tablespaces. + </para> + </note> </sect3> <sect3 id="example-cluster-pgpool-config-auth"> [parent: ecd4b04a4e76]