PostgreSQL 15 preview - 逻辑复制订阅端跳过lsn

之前版本的逻辑复制如果冲突，需要手动处理冲突，并且步骤较为繁琐(参考https://www.modb.pro/db/48642)，v15中提供了更简便的处理方式: ALTER SUBSCRIPTION … SKIP

提交日志

commit 208c5d65bbd60e33e272964578cb74182ac726a8
Author: Amit Kapila <akapila@postgresql.org>
Date:   Tue Mar 22 07:11:19 2022 +0530

    Add ALTER SUBSCRIPTION ... SKIP.

    This feature allows skipping the transaction on subscriber nodes.

    If incoming change violates any constraint, logical replication stops
    until it's resolved. Currently, users need to either manually resolve the
    conflict by updating a subscriber-side database or by using function
    pg_replication_origin_advance() to skip the conflicting transaction. This
    commit introduces a simpler way to skip the conflicting transactions.

    The user can specify LSN by ALTER SUBSCRIPTION ... SKIP (lsn = XXX),
    which allows the apply worker to skip the transaction finished at
    specified LSN. The apply worker skips all data modification changes within
    the transaction.

    Author: Masahiko Sawada
    Reviewed-by: Takamichi Osumi, Hou Zhijie, Peter Eisentraut, Amit Kapila, Shi Yu, Vignesh C, Greg Nancarrow, Haiying Tang, Euler Taveira
    Discussion: https://postgr.es/m/CAD21AoDeScrsHhLyEPYqN3sydg6PxAPVBboK=30xJfUVihNZDA@mail.gmail.com