postgres.git / summary / log / commit / refs

commit    b5f7e7569c09ca31c0da94ead44985550cf68b30
Author:   Fujii Masao <fujii@postgresql.org>
Date:     Wed May 13 02:44:31 2026 +0000

    Fix stale COPY progress during logical replication table sync
    
    Previously, pg_stat_progress_copy in the subscriber could continue to show
    the initial COPY operation for logical replication table synchronization as
    active even after the data copy had finished. The stale progress entry
    remained visible until synchronization caught up with the publisher.
    
    This happened because the table synchronization code called BeginCopyFrom()
    and CopyFrom(), but failed to call EndCopyFrom() afterward.
    
    This commit fixes the issue by adding the missing EndCopyFrom() call so that
    the COPY progress state in the subscriber is cleared as soon as the initial
    data copy completes.
    
    Backpatch to all supported branches.
    
    Author: Shinya Kato <shinya11.kato@gmail.com>
    Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
    Reviewed-by: ChangAo Chen <cca5507@qq.com>
    Reviewed-by: Chao Li <li.evan.chao@gmail.com>
    Discussion: https://postgr.es/m/CAOzEurQKuy3RiPkd=25PEwEzaqHuGvEOf=X7vaVzhgNjaukYzA@mail.gmail.com
    Backpatch-through: 14


 src/backend/replication/logical/tablesync.c | 1 +
 1 file changed, 1 insertion(+)

diff --git a/src/backend/replication/logical/tablesync.c b/src/backend/replication/logical/tablesync.c
index eb02cdd4750..b884f6240e5 100644
--- a/src/backend/replication/logical/tablesync.c
+++ b/src/backend/replication/logical/tablesync.c
@@ -1169,6 +1169,7 @@ copy_table(Relation rel)
 
 	/* Do the copy */
 	(void) CopyFrom(cstate);
+	EndCopyFrom(cstate);
 
 	logicalrep_rel_close(relmapentry, NoLock);
 }


[parent: d8d46710cdbb]