v24-0016-Address-comments-From-Vignesh-2.patch

application/octet-stream

Filename: v24-0016-Address-comments-From-Vignesh-2.patch
Type: application/octet-stream
Part: 15
Message: RE: speed up a logical replica setup

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →
Format: format-patch
Series: patch v24-0016
Subject: Address comments From Vignesh #2
File+
doc/src/sgml/ref/pg_createsubscriber.sgml 19 10
From dcdf9498a4436a14c713fa6be6bc5aa273d62aa8 Mon Sep 17 00:00:00 2001
From: Hayato Kuroda <kuroda.hayato@fujitsu.com>
Date: Thu, 22 Feb 2024 11:01:46 +0000
Subject: [PATCH v24 16/18] Address comments From Vignesh #2

---
 doc/src/sgml/ref/pg_createsubscriber.sgml | 29 +++++++++++++++--------
 1 file changed, 19 insertions(+), 10 deletions(-)

diff --git a/doc/src/sgml/ref/pg_createsubscriber.sgml b/doc/src/sgml/ref/pg_createsubscriber.sgml
index 4579495089..92e77af6df 100644
--- a/doc/src/sgml/ref/pg_createsubscriber.sgml
+++ b/doc/src/sgml/ref/pg_createsubscriber.sgml
@@ -43,7 +43,7 @@ PostgreSQL documentation
   </cmdsynopsis>
  </refsynopsisdiv>
 
- <refsect1 id="r1-app-pg_createsubscriber-1">
+ <refsect1>
   <title>Description</title>
   <para>
    The <application>pg_createsubscriber</application> creates a new <link
@@ -63,7 +63,7 @@ PostgreSQL documentation
    these are not met an error will be reported.
   </para>
 
-  <itemizedlist>
+  <itemizedlist id="app-pg-createsubscriber-description-prerequisites">
    <listitem>
     <para>
      The given target data directory must have the same system identifier than the
@@ -106,15 +106,15 @@ PostgreSQL documentation
    </listitem>
    <listitem>
     <para>
-     The target instance must have
+     The source instance must have
      <link linkend="guc-max-replication-slots"><varname>max_replication_slots</varname></link>
-     configured to a value greater than or equal to the number of target
-     databases and replication slots.
+     configured to a value greater than the number of target databases and
+     replication slots.
     </para>
    </listitem>
    <listitem>
     <para>
-     The target instance must have
+     The source instance must have
      <link linkend="guc-max-wal-senders"><varname>max_wal_senders</varname></link>
      configured to a value greater than or equal to the number of target
      databases and walsenders.
@@ -149,6 +149,15 @@ PostgreSQL documentation
     replication</link> is recommended.
    </para>
   </note>
+
+  <caution>
+   <para>
+    If <application>pg_createsubscriber</application> fails after the
+    promotion of physical standby, you must re-create the new physical standby
+    before continuing.
+   </para>
+  </caution>
+
  </refsect1>
 
  <refsect1>
@@ -314,8 +323,8 @@ PostgreSQL documentation
    <step>
     <para>
      Checks the target can be converted.  In particular, things listed in
-     <link linkend="r1-app-pg_createsubscriber-1">above section</link> would be
-     checked.  If these are not met <application>pg_createsubscriber</application>
+     <link linkend="app-pg-createsubscriber-description-prerequisites">prerequisites</link>
+     would be checked.  If these are not met <application>pg_createsubscriber</application>
      will terminate with an error.
     </para>
    </step>
@@ -406,9 +415,9 @@ PostgreSQL documentation
 
   <para>
    Here is an example of using <application>pg_createsubscriber</application>.
-   Before running the command, please make sure target server is stopped.
+   Before running the command, please make sure target server is running.
 <screen>
-<prompt>$</prompt> <userinput>pg_ctl -D /usr/local/pgsql/data stop</userinput>
+<prompt>$</prompt> <userinput>pg_ctl -D /usr/local/pgsql/data start</userinput>
 </screen>
 
    Then run <application>pg_createsubscriber</application>. Below tries to
-- 
2.43.0