pgpool2.git / summary / log / commit / refs
commit 37d2c7ba0c0086fd2f061afbd2242e2c633a166f
Author: Masaya Kawamoto <kawamoto@sraoss.co.jp>
Date: Mon May 09 04:54:16 2022 +0000
Doc: update configuration example.
doc.ja/src/sgml/example-cluster.sgml | 24 +++++++++++++++++++++---
doc/src/sgml/example-cluster.sgml | 26 +++++++++++++++++++++++---
2 files changed, 44 insertions(+), 6 deletions(-)
diff --git a/doc.ja/src/sgml/example-cluster.sgml b/doc.ja/src/sgml/example-cluster.sgml
index 7d4a8a499..80100fcd8 100644
--- a/doc.ja/src/sgml/example-cluster.sgml
+++ b/doc.ja/src/sgml/example-cluster.sgml
@@ -312,6 +312,14 @@ exclude=pgpool*
[全サーバ]$ mkdir /var/lib/pgsql/archivedir
</programlisting>
+ <para>
+ プライマリサーバの<productname>PostgreSQL</productname>を初期化します。
+ </para>
+ <programlisting>
+[server1]# su - postgres
+[server1]$ /usr/pgsql-14/bin/initdb -D $PGDATA
+ </programlisting>
+
<para>
次に<literal>server1</literal>にて、設定ファイル<filename>$PGDATA/postgresql.conf</filename>を以下のように編集します。
<application>pg_rewind</application>を使うために<varname>wal_log_hints</varname>を有効にしておきます。
@@ -427,6 +435,8 @@ host replication all samenet scram-sha-256
生成される鍵ファイル名は<literal>id_rsa_pgpool</literal>とします。
</para>
<programlisting>
+[全サーバ]# midir ~/.ssh
+[全サーバ]# chmod 700 ~/.ssh
[全サーバ]# cd ~/.ssh
[全サーバ]# ssh-keygen -t rsa -f id_rsa_pgpool
[全サーバ]# ssh-copy-id -i id_rsa_pgpool.pub postgres@server1
@@ -434,6 +444,8 @@ host replication all samenet scram-sha-256
[全サーバ]# ssh-copy-id -i id_rsa_pgpool.pub postgres@server3
[全サーバ]# su - postgres
+[全サーバ]$ midir ~/.ssh
+[全サーバ]$ chmod 700 ~/.ssh
[全サーバ]$ cd ~/.ssh
[全サーバ]$ ssh-keygen -t rsa -f id_rsa_pgpool
[全サーバ]$ ssh-copy-id -i id_rsa_pgpool.pub postgres@server1
@@ -444,8 +456,7 @@ host replication all samenet scram-sha-256
設定後、<literal>root</literal>ユーザ及び<literal>postgres</literal>ユーザから
<command>ssh postgres@serverX -i ~/.ssh/id_rsa_pgpool</command>コマンドを実行し、
パスワード入力せずログインできることを確認してください。
- 必要に応じて<filename>/etc/ssh/sshd_config</filename>を編集し、
- <systemitem>sshd</systemitem>を再起動してください。
+ <command>ssh-copy-id</command>の実行に失敗する場合は、<literal>postgres</literal> ユーザのパスワードを設定し、一時的にパスワード認証を有効化するなどしてください。
</para>
</listitem>
@@ -1171,7 +1182,14 @@ OPTS=" -D -n"
<title>動作確認</title>
<para>
これから、動作確認を行います。
- まず、<literal>server1</literal>、<literal>server2</literal>、<literal>server3</literal>で
+ <literal>server1</literal>で以下のコマンドで<productname>PostgreSQL</productname>を起動します。
+ </para>
+ <programlisting>
+[server1]# su - postgres
+[server1]$ /usr/pgsql-14/bin/pg_ctl start -D $PGDATA
+ </programlisting>
+ <para>
+ <literal>server1</literal>、<literal>server2</literal>、<literal>server3</literal>で
以下のコマンドで<productname>Pgpool-II</productname>を起動します。
</para>
<programlisting>
diff --git a/doc/src/sgml/example-cluster.sgml b/doc/src/sgml/example-cluster.sgml
index 9cb6b0e0a..a6bf26af0 100644
--- a/doc/src/sgml/example-cluster.sgml
+++ b/doc/src/sgml/example-cluster.sgml
@@ -302,6 +302,14 @@ exclude=pgpool*
[all servers]$ mkdir /var/lib/pgsql/archivedir
</programlisting>
+ <para>
+ Initialize <productname>PostgreSQL</productname> on the primary server.
+ </para>
+ <programlisting>
+[server1]# su - postgres
+[server1]$ /usr/pgsql-14/bin/initdb -D $PGDATA
+ </programlisting>
+
<para>
Then we edit the configuration file <filename>$PGDATA/postgresql.conf</filename>
on <literal>server1</literal> (primary) as follows. Enable <literal>wal_log_hints</literal>
@@ -408,6 +416,8 @@ host replication all samenet scram-sha-256
to set up passwordless <literal>SSH</literal>. The generated key file name is <literal>id_rsa_pgpool</literal>.
</para>
<programlisting>
+[all servers]# mkdir ~/.ssh
+[all servers]# chmod 700 ~/.ssh
[all servers]# cd ~/.ssh
[all servers]# ssh-keygen -t rsa -f id_rsa_pgpool
[all servers]# ssh-copy-id -i id_rsa_pgpool.pub postgres@server1
@@ -415,6 +425,8 @@ host replication all samenet scram-sha-256
[all servers]# ssh-copy-id -i id_rsa_pgpool.pub postgres@server3
[all servers]# su - postgres
+[all servers]$ mkdir ~/.ssh
+[all servers]$ chmod 700 ~/.ssh
[all servers]$ cd ~/.ssh
[all servers]$ ssh-keygen -t rsa -f id_rsa_pgpool
[all servers]$ ssh-copy-id -i id_rsa_pgpool.pub postgres@server1
@@ -423,8 +435,9 @@ host replication all samenet scram-sha-256
</programlisting>
<para>
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.
+ make sure that you can log in without entering a password. If you fail
+ executing <command>ssh-copy-id</command>, set a password for <literal>postgres</literal> user
+ and temporarily allow password authentication for example.
</para>
</listitem>
@@ -1124,7 +1137,14 @@ OPTS=" -D -n"
<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>,
+ First, we start the primary <productname>PostgreSQL</productname>.
+ </para>
+ <programlisting>
+[server1]# su - postgres
+[server1]$ /usr/pgsql-14/bin/pg_ctl start -D $PGDATA
+ </programlisting>
+ <para>
+ Then let's start <productname>Pgpool-II</productname> on <literal>server1</literal>,
<literal>server2</literal>, <literal>server3</literal> by using the following command.
</para>
<programlisting>
[parent: fe506fbcc644]