diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index 44ae7e0e87..188bafe4f9 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -154,6 +154,26 @@ ALTER PUBLICATION name RENAME TO . See there for more information. + + + When the partition root table is specified as the replication target + instead of its leaf tables, or this is either FOR ALL TABLES + or FOR TABLES IN SCHEMA publication, altering the + publish_via_partition_root parameter during + replication can cause data loss or duplication. + This happens because altering the parameter changes the identity and + schema of the publishing tables. + After running the ALTER PUBLICATION ... SET and + ALTER SUBSCRIPTION ... REFRESH PUBLICATION + command, the subscriber will subscribe to the appropriate table. + + + To prevent the issue, you can avoid modifying any leaf tables between + the ALTER PUBLICATION ... SET and + ALTER SUBSCRIPTION ... REFRESH PUBLICATION and + refresh publication with copy_data = off. + +