skip_apply_transaction
Skip a stuck logical replication transaction at an explicit LSN, discarding its changes permanently. Confirm redundancy first, then pass the LSN from diagnose_stuck_subscription.
Instructions
Skip the transaction wedging a subscription at an EXPLICIT LSN.
Issues ALTER SUBSCRIPTION ... SKIP (lsn = ...) so the apply worker steps over the offending transaction. That transaction's changes are discarded PERMANENTLY — use only when you've confirmed (from the subscriber log) that the change is genuinely redundant. Pass the exact LSN from diagnose_stuck_subscription; there is no skip-to-head shortcut. Dry-run unless allow_writes=true AND PG_LOGICAL_MCP_ALLOW_WRITES is set.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| lsn | Yes | ||
| allow_writes | No | ||
| subscription_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||