diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml
index ba8c2b1..666d9b0 100644
--- a/doc/src/sgml/ref/alter_subscription.sgml
+++ b/doc/src/sgml/ref/alter_subscription.sgml
@@ -153,7 +153,7 @@ ALTER SUBSCRIPTION name RENAME TO <
REFRESH PUBLICATION
- Fetch missing table information from publisher. This will start
+ Fetch missing table information from the publisher. This will start
replication of tables that were added to the subscribed-to publications
since
CREATE SUBSCRIPTION or
@@ -161,29 +161,26 @@ ALTER SUBSCRIPTION name RENAME TO <
- It also fetches the missing sequence information from the publisher and
- synchronize the sequence data for newly added sequences with the
- publisher. This will start synchronizing of sequences that were added to
- the subscribed-to publications since
- CREATE SUBSCRIPTION or the last invocation of
- REFRESH PUBLICATION. Additionally, it will remove any
- sequences that are no longer part of the publication from the
- pg_subscription_rel
- system catalog. Sequences that have already been synchronized will not be
- re-synchronized.
+ Also, fetch missing sequence information from the publisher.
+
+
+
+ The system catalog pg_subscription_rel
+ is updated to record all tables and sequences known to the subscription,
+ that are still part of the publication.
refresh_option specifies additional options for the
- refresh operation. The supported options are:
+ refresh operation. The only supported option is:
copy_data (boolean)
- Specifies whether to copy pre-existing data for tables and sequences
- in the publications that are being subscribed to when the replication
+ Specifies whether to copy pre-existing data for tables and synchronize
+ sequences in the publications that are being subscribed to when the replication
starts. The default is true.
@@ -191,6 +188,11 @@ ALTER SUBSCRIPTION name RENAME TO <
filter WHERE clause has since been modified.
+ Previously subscribed sequences are not re-synchronized. To do that,
+ see
+ ALTER SUBSCRIPTION ... REFRESH PUBLICATION SEQUENCES
+
+
See for details of
how copy_data = true can interact with the
origin
@@ -212,11 +214,11 @@ ALTER SUBSCRIPTION name RENAME TO <
REFRESH PUBLICATION SEQUENCES
- Fetch missing sequences information from publisher and re-synchronize the
+ Fetch missing sequence information from the publisher, then re-synchronize
sequence data with the publisher. Unlike
ALTER SUBSCRIPTION ... REFRESH PUBLICATION which
- only syncronizes the newly added sequences, this option will also
- re-synchronize the sequence data for sequences that were previously added.
+ only synchronizes newly added sequences, REFRESH PUBLICATION SEQUENCES
+ will re-synchronize the sequence data for all subscribed sequences.