From dcdf9498a4436a14c713fa6be6bc5aa273d62aa8 Mon Sep 17 00:00:00 2001 From: Hayato Kuroda 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 - + Description The pg_createsubscriber creates a new - + The given target data directory must have the same system identifier than the @@ -106,15 +106,15 @@ PostgreSQL documentation - The target instance must have + The source instance must have max_replication_slots - 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. - The target instance must have + The source instance must have max_wal_senders configured to a value greater than or equal to the number of target databases and walsenders. @@ -149,6 +149,15 @@ PostgreSQL documentation replication is recommended. + + + + If pg_createsubscriber fails after the + promotion of physical standby, you must re-create the new physical standby + before continuing. + + + @@ -314,8 +323,8 @@ PostgreSQL documentation Checks the target can be converted. In particular, things listed in - above section would be - checked. If these are not met pg_createsubscriber + prerequisites + would be checked. If these are not met pg_createsubscriber will terminate with an error. @@ -406,9 +415,9 @@ PostgreSQL documentation Here is an example of using pg_createsubscriber. - Before running the command, please make sure target server is stopped. + Before running the command, please make sure target server is running. -$ pg_ctl -D /usr/local/pgsql/data stop +$ pg_ctl -D /usr/local/pgsql/data start Then run pg_createsubscriber. Below tries to -- 2.43.0