Back to directory

Logical Replication

Agent skill
1 skill

PostgreSQL's logical replication — publisher-side WAL decoding + subscriber-side apply — plus everything under src/backend/replication/logical/. Loads when the user asks about logical decoding, pglogicalslotgetchanges, publications / subscriptions, output plugins (pgoutput / testdecoding), reorder buffer, historic snapshots (SnapBuild), the apply worker + parallel apply, conflict resolution (PG 18+ conflict tracking), replication origins, replication slots (physical vs logical, slot.c + slotsync.c), streaming mode for in-progress transactions, tablesync's initial COPY, or debugging apply-worker crashes / slot advancement / catalogxmin retention. Skip when the ask is about physical streaming replication (walsender/walreceiver, replication/basebackup.c, replication/walsender.c in isolation) — those are the sibling replication subsystem, mostly disjoint code paths.

Install with
Claude CodeCodexCursorGitHub CopilotGemini CLI

Supported by the Atlas install prompt. Skill-specific requirements vary.

Skill stats

Skills1CategoryEngineeringStars0

About this skill

PostgreSQL's logical replication — publisher-side WAL decoding + subscriber-side apply — plus everything under src/backend/replication/logical/. Loads when the user asks about logical decoding, pglogicalslotgetchanges, publications / subscriptions, output plugins (pgoutput / testdecoding), reorder buffer, historic snapshots (SnapBuild), the apply worker + parallel apply, conflict resolution (PG 18+ conflict tracking), replication origins, replication slots (physical vs logical, slot.c + slotsync.c), streaming mode for in-progress transactions, tablesync's initial COPY, or debugging apply-worker crashes / slot advancement / catalogxmin retention. Skip when the ask is about physical streaming replication (walsender/walreceiver, replication/basebackup.c, replication/walsender.c in isolation) — those are the sibling replication subsystem, mostly disjoint code paths.

Quick start

  1. Copy the install prompt. Use the green button above this README.
  2. Send it to your agent. Paste it into your coding agent’s chat and send.
  3. Review the setup. Your agent checks the skill’s instructions, requirements, and installation scope.
Review, license & listing details
Review the source before using this skill

This is an imported listing. We haven’t certified its safety, license, or compatibility. Skills may include executable scripts.

Automated security scan: Partial

Only SKILL.md was scanned. Supporting files and scripts were not checked. No safety grade has been assigned.

0 potential findings · Scanned 11/4/2026 · Scanner 0.2.1

Content SHA-256: cf338bf5b629f352b7d05f81b5a717effbc61160ff151c99603113ab1726ad73

About scan coverage and limitations

About this listing

Category
Engineering
Reported license
PostgreSQL
Listing language (estimated)
English
Review status
Not individually reviewed
Agent compatibility
Atlas installation supports Claude Code, Codex, and Cursor. Skill-specific dependencies and features are checked during setup.