Expose yb_restart_commit_ht in pg_replication_slots view #22040
Assignees
Labels
area/cdcsdk
CDC SDK
jira-originated
kind/new-feature
This is a request for a completely new feature
priority/high
High Priority
Comments
yugabyte-ci
added
area/cdcsdk
asrinivasanyb
changed the title
asrinivasanyb
added a commit
that referenced
this issue
Apr 24, 2024
…s view Summary: Summary This is related to the project to support Replication slot API in YSQL (#18724). (https://phorge.dev.yugabyte.com/D29194). This is also related to the PG Compatible Logical Replication Consumption project. The schema of the pg_replication_slots view has been modified by adding an extra yb-specific column yb_restart_commit_ht which is a int8. The value of this column is a uint64 representation of the commit Hybrid Time corresponding to the restart_lsn. This can be used by the client (like YB-PG Connector) to perform a consistent snapshot (as of the consistent_point) in the case when a replication slot already exists. UPGRADE/ROLLBACK SAFETY: These changes are protected via the preview flag: ysql_yb_enable_replication_commands Jira: DB-10956 Test Plan: Manual Testing ./yb_build.sh --java-test 'org.yb.pgsql.TestPgReplicationSlot' ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressReplicationSlot' ./yb_build.sh --java-test 'org.yb.pgsql.TestYsqlUpgrade#upgradeIsIdempotent' ./yb_build.sh --java-test 'org.yb.pgsql.TestYsqlUpgrade#upgradeIsIdempotentSingleConn' Reviewers: stiwary, skumar Reviewed By: stiwary Subscribers: yql, ycdcxcluster Differential Revision: https://phorge.dev.yugabyte.com/D34279
yugabyte-ci
added
priority/high
asrinivasanyb
added a commit
that referenced
this issue
Apr 25, 2024
…_replication_slots view Summary: **Backport Description** There were no merge conflicts **Original Description** Original commit: 3956dbd / D34279 Summary This is related to the project to support Replication slot API in YSQL (#18724). (https://phorge.dev.yugabyte.com/D29194). This is also related to the PG Compatible Logical Replication Consumption project. The schema of the pg_replication_slots view has been modified by adding an extra yb-specific column yb_restart_commit_ht which is a int8. The value of this column is a uint64 representation of the commit Hybrid Time corresponding to the restart_lsn. This can be used by the client (like YB-PG Connector) to perform a consistent snapshot (as of the consistent_point) in the case when a replication slot already exists. UPGRADE/ROLLBACK SAFETY: These changes are protected via the preview flag: ysql_yb_enable_replication_commands Jira: DB-10956 Test Plan: Manual Testing ./yb_build.sh --java-test 'org.yb.pgsql.TestPgReplicationSlot' ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressReplicationSlot' ./yb_build.sh --java-test 'org.yb.pgsql.TestYsqlUpgrade#upgradeIsIdempotent' ./yb_build.sh --java-test 'org.yb.pgsql.TestYsqlUpgrade#upgradeIsIdempotentSingleConn' Reviewers: stiwary, skumar Reviewed By: stiwary Subscribers: ycdcxcluster, yql Tags: #jenkins-ready Differential Revision: https://phorge.dev.yugabyte.com/D34525
svarnau
pushed a commit
that referenced
this issue
May 25, 2024
…s view Summary: Summary This is related to the project to support Replication slot API in YSQL (#18724). (https://phorge.dev.yugabyte.com/D29194). This is also related to the PG Compatible Logical Replication Consumption project. The schema of the pg_replication_slots view has been modified by adding an extra yb-specific column yb_restart_commit_ht which is a int8. The value of this column is a uint64 representation of the commit Hybrid Time corresponding to the restart_lsn. This can be used by the client (like YB-PG Connector) to perform a consistent snapshot (as of the consistent_point) in the case when a replication slot already exists. UPGRADE/ROLLBACK SAFETY: These changes are protected via the preview flag: ysql_yb_enable_replication_commands Jira: DB-10956 Test Plan: Manual Testing ./yb_build.sh --java-test 'org.yb.pgsql.TestPgReplicationSlot' ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressReplicationSlot' ./yb_build.sh --java-test 'org.yb.pgsql.TestYsqlUpgrade#upgradeIsIdempotent' ./yb_build.sh --java-test 'org.yb.pgsql.TestYsqlUpgrade#upgradeIsIdempotentSingleConn' Reviewers: stiwary, skumar Reviewed By: stiwary Subscribers: yql, ycdcxcluster Differential Revision: https://phorge.dev.yugabyte.com/D34279
ZhenYongFan
pushed a commit
to ZhenYongFan/yugabyte-db
that referenced
this issue
Jun 15, 2024
…mn in pg_replication_slots view Summary: **Backport Description** There were no merge conflicts **Original Description** Original commit: 3956dbd / D34279 Summary This is related to the project to support Replication slot API in YSQL (yugabyte#18724). (https://phorge.dev.yugabyte.com/D29194). This is also related to the PG Compatible Logical Replication Consumption project. The schema of the pg_replication_slots view has been modified by adding an extra yb-specific column yb_restart_commit_ht which is a int8. The value of this column is a uint64 representation of the commit Hybrid Time corresponding to the restart_lsn. This can be used by the client (like YB-PG Connector) to perform a consistent snapshot (as of the consistent_point) in the case when a replication slot already exists. UPGRADE/ROLLBACK SAFETY: These changes are protected via the preview flag: ysql_yb_enable_replication_commands Jira: DB-10956 Test Plan: Manual Testing ./yb_build.sh --java-test 'org.yb.pgsql.TestPgReplicationSlot' ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressReplicationSlot' ./yb_build.sh --java-test 'org.yb.pgsql.TestYsqlUpgrade#upgradeIsIdempotent' ./yb_build.sh --java-test 'org.yb.pgsql.TestYsqlUpgrade#upgradeIsIdempotentSingleConn' Reviewers: stiwary, skumar Reviewed By: stiwary Subscribers: ycdcxcluster, yql Tags: #jenkins-ready Differential Revision: https://phorge.dev.yugabyte.com/D34525
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Jira Link: DB-10956
The text was updated successfully, but these errors were encountered: