diff options
| author | Taiki Koshino | 2025-09-17 07:15:11 +0000 |
|---|---|---|
| committer | Taiki Koshino | 2025-09-17 07:15:11 +0000 |
| commit | feef87e3a85ac9175ff05cb4df4e32c57c84760b (patch) | |
| tree | f7d23a65b4b68843752641b87272d90bf6648bbb /doc/src | |
| parent | 58446a66f8d7f461de0407f41a15e8fd9fe9035c (diff) | |
Update doc about "Setting up PostgreSQL standby" in "8.2. Pgpool-II + Watchdog Setup Example".
Add a note that when setting up a standby without online recovery, do not write primary_conninfo to postgresql.auto.conf.
Discussion: https://github.com/pgpool/pgpool2/issues/67
Backpatch-through: v4.2
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/example-cluster.sgml | 33 |
1 files changed, 29 insertions, 4 deletions
diff --git a/doc/src/sgml/example-cluster.sgml b/doc/src/sgml/example-cluster.sgml index 2811af8ed..580626901 100644 --- a/doc/src/sgml/example-cluster.sgml +++ b/doc/src/sgml/example-cluster.sgml @@ -417,18 +417,43 @@ wal_log_hints = on <itemizedlist> <listitem> <para> - use <command>pg_basebackup</command> to backup the data directory of the primary from the standby. + use <productname>Pgpool-II</productname>'s online recovery feature + (<xref linkend="runtime-online-recovery">) to automatically + setup a standby server. </para> </listitem> <listitem> <para> - use <productname>Pgpool-II</productname>'s online recovery feature - (<xref linkend="runtime-online-recovery">) to automatically - setup a standby server. + use <command>pg_basebackup</command> to backup the data directory of the primary from the standby. </para> </listitem> </itemizedlist> </para> + + <note> + <para> + If you manually set up standby without using online recovery, please note the following: + <itemizedlist> + <listitem> + <para> + You must manually create the replication slots. + </para> + </listitem> + </itemizedlist> + <itemizedlist> + <listitem> + <para> + Do not specify the -R option when running pg_basebackup. + Write <varname>primary_conninfo</varname>, <varname>recovery_target_timeline</varname>, and <varname>primary_slot_name</varname> in <filename>$PGDATA/myrecovery.conf</filename>, not in <filename>postgresql.auto.conf</filename>, and add the following to <filename>postgresql.conf</filename>. + </para> + </listitem> + </itemizedlist> + <programlisting> +include_if_exists = 'myrecovery.conf' + </programlisting> + </para> + </note> + <para> In this example, we use <productname>Pgpool-II</productname>'s online recovery to setup the standby server |