From 2357c9223b710c91b0f05cbc56bd435baeac961f Mon Sep 17 00:00:00 2001 From: Amit Kapila Date: Mon, 1 Jul 2024 11:36:56 +0530 Subject: Rename standby_slot_names to synchronized_standby_slots. The standby_slot_names GUC allows the specification of physical standby slots that must be synchronized before the logical walsenders associated with logical failover slots. However, for this purpose, the GUC name is too generic. Author: Hou Zhijie Reviewed-by: Bertrand Drouvot, Masahiko Sawada Backpatch-through: 17 Discussion: https://postgr.es/m/ZnWeUgdHong93fQN@momjian.us --- doc/src/sgml/config.sgml | 12 ++++++------ doc/src/sgml/func.sgml | 4 ++-- doc/src/sgml/logical-replication.sgml | 2 +- doc/src/sgml/logicaldecoding.sgml | 8 ++++---- 4 files changed, 13 insertions(+), 13 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 0c7a9082c54..17d84bd321a 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4569,10 +4569,10 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - - standby_slot_names (string) + + synchronized_standby_slots (string) - standby_slot_names configuration parameter + synchronized_standby_slots configuration parameter @@ -4587,7 +4587,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows after the standby is promoted, the physical replication slot for the standby should be listed here. Note that logical replication will not proceed if the slots specified in the - standby_slot_names do not exist or are invalidated. + synchronized_standby_slots do not exist or are invalidated. Additionally, the replication management functions pg_replication_slot_advance, @@ -4596,12 +4596,12 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows pg_logical_slot_peek_changes, when used with logical failover slots, will block until all - physical slots specified in standby_slot_names have + physical slots specified in synchronized_standby_slots have confirmed WAL receipt. The standbys corresponding to the physical replication slots in - standby_slot_names must configure + synchronized_standby_slots must configure sync_replication_slots = true so they can receive logical failover slot changes from the primary. diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 45e6eb0415f..f1f22a19601 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -29057,7 +29057,7 @@ postgres=# SELECT '0/0'::pg_lsn + pd.segment_number * ps.setting::int + :offset adding the rows produced when decoding each new transaction commit. If the specified slot is a logical failover slot then the function will not return until all physical slots specified in - standby_slot_names + synchronized_standby_slots have confirmed WAL receipt. @@ -29137,7 +29137,7 @@ postgres=# SELECT '0/0'::pg_lsn + pd.segment_number * ps.setting::int + :offset slot may return to an earlier position. If the specified slot is a logical failover slot then the function will not return until all physical slots specified in - standby_slot_names + synchronized_standby_slots have confirmed WAL receipt. diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index 746d5bd330c..ccdd24312bd 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -713,7 +713,7 @@ ALTER SUBSCRIPTION server before the failover happens. To ensure a successful failover, the standby server must be ahead of the subscriber. This can be achieved by configuring - standby_slot_names. + synchronized_standby_slots. diff --git a/doc/src/sgml/logicaldecoding.sgml b/doc/src/sgml/logicaldecoding.sgml index 5a15bbc580c..1c4ae38f1b9 100644 --- a/doc/src/sgml/logicaldecoding.sgml +++ b/doc/src/sgml/logicaldecoding.sgml @@ -385,16 +385,16 @@ postgres=# select * from pg_logical_slot_get_changes('regression_slot', NULL, NU dbname in the primary_conninfo. It's highly recommended that the said physical replication slot is named in - standby_slot_names + synchronized_standby_slots list on the primary, to prevent the subscriber from consuming changes faster than the hot standby. Even when correctly configured, some latency is expected when sending changes to logical subscribers due to the waiting on slots named in - standby_slot_names. - When standby_slot_names is utilized, the + synchronized_standby_slots. + When synchronized_standby_slots is utilized, the primary server will not completely shut down until the corresponding standbys, associated with the physical replication slots specified - in standby_slot_names, have confirmed + in synchronized_standby_slots, have confirmed receiving the WAL up to the latest flushed position on the primary server. -- cgit v1.2.3