Wiki / Logical Decoding Plugins
Logical Decoding Plugins
Compare versionsLogical decoding output plugins, formats, options and implementation-specific evidence.
Reading PostgreSQL 18.6.
2 core entries; 2 recorded in PostgreSQL 18.6.
-
pgoutput Core replication
Core replication
The built-in output plugin used by PostgreSQL logical replication.
-
test_decoding Testing and examples
Testing and examples
A test and example output plugin that renders logical changes in a textual format.
RecordedFirst recordedInterface or attribute changeNo longer recorded
Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.
Changes in PostgreSQL 18.6 · Export JSON
Logical-decoding plugin candidates
Current catalogue observation 2026-09-29 from pgext.universe. Extension versions, source metadata dates and declared PostgreSQL compatibility are independent of the selected core version. Catalogue classification does not establish capabilities or maintenance support.
11 directory rows.
| Existing extension | Catalogued version | Declared PG majors | Metadata checked | Evidence scope | Catalogued purpose |
|---|---|---|---|---|---|
| wal2json | 2.6 | 14, 15, 16, 17, 18 | 2026-08-30 | Primary documentation reviewed separately below | Changing data capture in JSON format |
| wal2mongo | 1.0.7 | 14, 15, 16, 17, 18 | 2026-08-30 | Catalogue candidate; interface unverified | PostgreSQL logical decoding output plugin for MongoDB |
| decoderbufs | 3.6.0 | 14, 15, 16, 17, 18 | 2026-08-30 | Catalogue candidate; interface unverified | Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format |
| decoder_raw | 1.0 | 14, 15, 16, 17, 18 | 2026-08-30 | Catalogue candidate; interface unverified | Output plugin for logical replication in Raw SQL format |
| test_decoding | - | 14, 15, 16, 17, 18 | Not recorded | Core interface; see versioned entry | SQL-based test/example module for WAL logical decoding |
| pgoutput | - | 14, 15, 16, 17, 18 | Not recorded | Core interface; see versioned entry | Logical Replication output plugin |
| jsoncdc | 0.1.0 | Unknown | 2026-08-30 | Catalogue candidate; interface unverified | JSON logical decoding output plugin |
| replisome | 0.1 | Unknown | 2026-08-30 | Catalogue candidate; interface unverified | Logical-decoding output plugin and Python consumer framework for streaming PostgreSQL row changes as JSON. |
| putpostlogic | 0.1.0 | Unknown | 2026-08-30 | Catalogue candidate; interface unverified | Unreleased logical decoding output-plugin prototype that emits JSON changes through PostgreSQL, Kafka, or Nanomsg. |
| pboutput | 0.0.0 | Unknown | 2026-08-30 | Catalogue candidate; interface unverified | Binary logical-decoding output plugin that encodes PostgreSQL changes as Protocol Buffers. |
| pg_turso | 1.0 | Unknown | 2026-08-30 | Catalogue candidate; interface unverified | Postgres output plugin for replicating data to Turso. |
Primary-source capability observations
Each statement applies to its named extension version and immutable source revision. Unlisted capabilities remain unknown. These are documentation observations, not runtime tests or current maintenance guarantees.
5 directory rows.
| Extension | Reviewed version | Capability | Evidence state | Conditions | Evidence date and source |
|---|---|---|---|---|---|
| wal2json | 2.6 | Output granularity | Verified in documentation | Format 1 emits one JSON object per transaction; format 2 emits one per tuple with optional transaction boundaries. | 2026-09-29 · 75629c2e1e81 · README.md |
| wal2json | 2.6 | Old row values | Conditional | UPDATE and DELETE old-row availability depends on replica identity. | 2026-09-29 · 75629c2e1e81 · README.md |
| wal2json | 2.6 | TRUNCATE | Conditional | The actions option controls changes; format 1 excludes TRUNCATE for compatibility. | 2026-09-29 · 75629c2e1e81 · README.md |
| wal2json | 2.6 | Table and message filters | Verified in documentation | Options select or exclude tables, origins and logical-message prefixes. | 2026-09-29 · 75629c2e1e81 · README.md |
| wal2json | 2.6 | In-progress transaction streaming / two-phase decoding | Unknown | A streaming-protocol connection does not itself establish these capabilities; this documentation review does not verify them. | 2026-09-29 · 75629c2e1e81 · README.md |
Reading this collection
Core output plugins use PostgreSQL-version evidence. Extension output formats and capabilities use independently dated, pinned project evidence. A catalog classification is not proof of protocol compatibility.