Replicant

A framework-agnostic Elixir CDC consumer for Postgres logical replication (pgoutput), delivering committed row changes to a pluggable sink with zero data loss: the replication slot advances only after the sink has durably persisted the transaction.

Replicant is tenant-blind and classification-blind — the reliable CDC consumer sibling to arcadic and ash_age. Multitenancy, classification, and Ash resources live one layer up, in a future ash_replicant sink adapter.

Status: v1 is complete and production-hardened (v0.1.0). Replicant owns the replication slot via Postgrex.ReplicationConnection, acks only after the sink durably commits (ack-after-checkpoint), halts fail-closed on slot invalidation, and is proven by a real-PG16 crash-injection suite (loss = 0, effect-dup = 0). Initial snapshot/backfill, a lib-owned checkpoint store for non-transactional sinks, batched checkpointing, sink-owned atomic batch delivery, in-progress-transaction streaming, and consumer-side disk spill for oversized transactions have all shipped. See "How it streams" below.

Highlights

• Sink-owned, transaction-granularity exactly-once — the unit of delivery and of the watermark is the transaction, keyed by its single commit_lsn (every row in a pgoutput proto-v1 transaction shares one commit LSN). A sink skips any transaction whose commit_lsn <= checkpoint and upserts rows by table PK; that is at-least-once plus an idempotent sink, which is the only honest way to reach exactly-once without two-phase commit.
• Value-free errors, logs, and telemetry — every row value is assumed to be PII or a secret. Decode failures are caught and scrubbed into a Replicant.Error that never carries raw WAL bytes; telemetry metadata is allowlisted to LSNs, table names, counts, durations, and error classes.
• Identifier-validated SQL — slot and publication names pass through Replicant.Identifier.validate/1 (a strict Postgres-identifier allowlist) before they reach SQL, closing the raw-interpolation surface in the upstream parser this library vendors from.
• TOAST-sentinel aware — an UPDATE that doesn't touch a TOASTed column sends a sentinel, not the value. Replicant surfaces it as a first-class unchanged: [col] list on Replicant.Change, so a sink knows exactly which columns to leave untouched on upsert, instead of overwriting them with a placeholder.
• Fail-closed on destructive schema drift — a replica-identity change or a dropped column is classified :destructive and halts, rather than silently emitting incomplete or misattributed rows.
• Column names stay strings — never String.to_atom, so a wide or attacker-influenced schema cannot exhaust the atom table.

LSN representation

A Postgres LSN is exposed as a single non_neg_integer — the 64-bit value (xlog_file <<< 32) ||| xlog_offset — so that ordinary integer comparison is correct WAL ordering, and the same value feeds the wire-level standby status update:

Replicant.lsn_to_string(0x16E3778)
#=> "0/16E3778"

Use Replicant.lsn_to_string/1 for display; LSNs are WAL positions, not row data, so they are permitted in telemetry metadata. The exactly-once watermark check is plain integer comparison: txn.commit_lsn <= checkpoint.

How it streams

A running pipeline is two processes under a :one_for_all supervisor:

• Replicant.Connection (Postgrex.ReplicationConnection) owns the replication slot and the socket. It answers every keepalive with the last durably-checkpointed LSN as the flush position (never the received wal_end), decodes each WAL message behind the value-free boundary, and forwards the decoded message to the assembler — it never runs the sink, so it is always free to answer keepalives. It advances the ack asynchronously only when the sink signals a durable commit, and halts fail-closed on slot invalidation (wal_status = 'lost' / conflicting), a decode failure, or a sustained sink-lag backlog (the bounded in-flight window).
• Replicant.AssemblerServer applies the sink synchronously, off the keepalive path, and halts fail-closed on a destructive schema change or a sink write fault.

Because the ack reports only the durable checkpoint, a crash between dispatch and persist re-delivers from the older confirmed_flush and the idempotent sink dedups — the exactly-once seam that walex's fire-and-forget wal_end + 1 ack does not have.

The 5 critical rules (see AGENTS.md for the full text)

1. No row value in an error, log, or telemetry event.
2. Validate identifiers before they reach SQL.
3. Exactly-once is at-least-once + a transaction-watermark-idempotent sink — never claim a naked exactly-once.
4. Unchanged TOAST is a sentinel, not a value — never overwrite it.
5. Stay tenant-blind — multitenancy and classification live in ash_replicant, never here.

Installation

def deps do
  [
    {:replicant, "~> 0.1"}
  ]
end

Usage

Start a pipeline against a standby with Replicant.start_link/1, pointing it at a sink that implements checkpoint/0 + handle_transaction/1:

Replicant.start_link(
  connection: [hostname: "standby.internal", port: 5432, username: "u",
               password: "p", database: "orders", ssl: true],
  slot_name: "replicant_orders",
  publication: "orders_pub",
  sink: MyApp.OrdersSink,
  go_forward_only: false
)

defmodule MyApp.OrdersSink do
  @behaviour Replicant.Sink

  @impl true
  def checkpoint, do: {:ok, MyApp.Repo.last_committed_lsn()}

  @impl true
  def handle_transaction(%Replicant.Transaction{commit_lsn: lsn} = txn) do
    # In ONE DB transaction: skip if lsn <= checkpoint, else upsert txn.changes
    # by table PK and persist lsn as the new checkpoint. Then:
    {:ok, lsn}
  end
end

Start modes. A :state_mirror sink starting from an empty checkpoint must declare its intent — go_forward_only: true (stream only new changes), or snapshot: true (backfill the current state, then hand off to streaming at the snapshot LSN with zero gap and zero duplication). A non-empty checkpoint simply resumes. snapshot: true requires the sink to also implement handle_snapshot/2 (batch upsert; clear the table on first_for_table?) and handle_snapshot_complete/1 (durably persist the handoff checkpoint); a mid-snapshot crash halts fail-closed (:snapshot_incomplete) for an operator to drop the slot and retry.

Lib-owned checkpoint (non-transactional sinks). Pass a :checkpoint_store ([connection: <postgrex opts>, table: "replicant_checkpoints"]) to flip the pipeline into lib mode: the library writes the checkpoint to a durable Postgres table after the sink persists (checkpoint-after-persist), so a non-transactional sink (files, S3, Kafka, external APIs) needs to implement only handle_transaction/1. The guarantee is at-least-once, duplicate bounded to one transaction, never loss — not effect-once (a non-transactional sink cannot dedup). A store outage (connect-read or mid-stream write) is bounded: the pipeline retries max_retries times (default 5) retry_backoff_ms apart (default 1000 ms — ~5s of outage tolerated) then halts fail-closed; a permanent fault (schema mismatch / invalid config) halts immediately.

Sink-owned atomic batch delivery (transactional sinks). For a transactional sink that can persist multiple rows + checkpoint in one database transaction, pass a top-level batch_delivery: [max_transactions: 100, max_delay_ms: 1000] to accumulate committed transactions and deliver them as a batch:

Replicant.start_link(
  connection: [hostname: "standby.internal", port: 5432, username: "u",
               password: "p", database: "orders", ssl: true],
  slot_name: "replicant_orders",
  publication: "orders_pub",
  sink: MyApp.OrdersSink,
  batch_delivery: [max_transactions: 100, max_delay_ms: 1000],
  go_forward_only: false
)

defmodule MyApp.OrdersSink do
  @behaviour Replicant.Sink

  @impl true
  def checkpoint, do: {:ok, MyApp.Repo.last_committed_lsn()}

  @impl true
  def handle_batch(transactions) do
    # In ONE DB transaction: skip any commit_lsn <= checkpoint, else upsert all
    # rows from all transactions by table PK, and persist the batch's highest
    # commit_lsn as the new checkpoint. Then:
    {:ok, List.last(transactions).commit_lsn}
  end
end

The batch flushes when it reaches max_transactions transactions, after max_delay_ms milliseconds idle, or when the batch's WAL span (LSN-span lag) hits an auto-derived safety cap (derived from :max_inflight_lag). Because the rows + checkpoint write is atomic, effect-once is preserved (dup=0, loss=0) — stronger than lib-mode's checkpoint_store: [batch: …] which is per-transaction delivery with batched checkpointing. The sink must implement both checkpoint/0 (resume) and handle_batch/1; it cannot use checkpoint_store, and any handle_transaction/1 implementation is ignored. Emits [:replicant, :sink, :batch_committed] telemetry once per flush.

Consumer-side disk spill (oversized transactions). By default a single in-progress streamed transaction is bounded by the in-flight window: one larger than max_inflight_lag halts fail-closed. Opt into disk spill to reassemble such a transaction partly on disk and still deliver it effect-once:

Replicant.start_link(
  connection: [...], slot_name: "replicant_orders", publication: "orders_pub",
  sink: MyApp.OrdersSink, go_forward_only: false,
  max_inflight_lag: 64 * 1024 * 1024,
  streaming: [
    max_concurrent_txns: 64,
    spill: [dir: "/var/lib/replicant/spill", max_spill_bytes: 1024 * 1024 * 1024]
  ]
)

A transaction whose resident bytes cross max_inflight_lag spills its oldest changes to a per-txn file under dir; at commit it is delivered as a lazy, single-pass, disk-backed%Transaction{} whose changes streams the spilled frames + the resident tail. There are two ceilings: the resident RAM bound max_inflight_lag (the spill trigger) and the disk bound max_spill_bytes (a transaction exceeding it halts :spill_exhausted). Defaults: max_spill_bytes is 16 × max_inflight_lag; dir is a 0700 subdir of the OS temp dir.

Delivery obligation. A spilled transaction's changes is a single-passEnumerable valid only during the handle_transaction/1 (or handle_batch/1) call — iterate it with Enum/Stream and do not call length/1, Enum.to_list/1, or re-iterate it (any of which forces the whole transaction back into RAM, defeating spill), and do not retain it past the call. The usual List-backed changes still works exactly as before; only an oversized spilled transaction delivers the lazy form.

Operator guidance. Spill files are ephemeral non-fsync'd scratch (0600, value-free on fault), deleted on commit/abort/reset/halt and swept per-slot on (re)connect. Replicant does not encrypt them — if the source rows are sensitive, point dir at an encrypted/secure volume; a custom persistent dir is yours to clean on decommission (the default OS temp dir is cleared by the OS).

Development

mix deps.get
mix test
mix quality   # format --check-formatted + credo --strict + dialyzer

Contributor and agent working rules — including the redaction, identifier-validation, and tenant-blind invariants — live in AGENTS.md.

Roadmap

The v1 CDC core and every delivery slice have shipped and are closeout-reviewed against a real-PG16 crash-injection suite:

• Offline core — decode / assemble / validate / redact behind the value-free boundary.
• Live streaming + exactly-once — the Postgrex.ReplicationConnection that owns the slot with ack-after-checkpoint, slot-invalidation fail-closed halt, and the bounded in-flight window (loss = 0, effect-dup = 0).
• Initial snapshot / backfill — EXPORT_SNAPSHOT → COPY → stream-at-snapshot-LSN, gap-free and dup-free.
• Lib-owned checkpoint store — a durable Postgres checkpoint written after persist for non-transactional sinks (at-least-once, dup bounded to one transaction, never loss), with bounded retry-then-halt on store faults.
• Batched checkpointing (lib mode) and sink-owned atomic batch delivery — amortize the checkpoint write / the sink's own commit across a batch of transactions.
• In-progress-transaction streaming (pgoutput v2) and consumer-side disk spill — reassemble and deliver a transaction larger than memory, effect-once, instead of halting.

The one remaining piece is a sibling library, not a slice of this core:

• ash_replicant — the Ash / multitenancy / classification sink adapter, one layer up from this tenant-blind core.

Credits

• walex — the pgoutput byte parser, OID-to-type database, type caster, and array parser this library vendors from (MIT). See NOTICE for the full attribution chain (cainophile, Supabase Realtime, epgsql).
• The postgrex/ash_postgres split that inspired arcadic and ash_arcadic also shapes the replicant/ash_replicant layering.

License

MIT — see LICENSE. Third-party attributions in NOTICE.