wal2json
« Back to VersTracker
Description:
Convert PostgreSQL changesets to JSON format
Type: Formula  |  Tracked Since: Dec 28, 2025
Links: Homepage  |  formulae.brew.sh
Category: Databases
Tags: postgresql json replication cdc database
Install: brew install wal2json
About:
Wal2json is a PostgreSQL logical decoding plugin that extracts changes from the write-ahead log (WAL) and converts them into a structured JSON format. It enables real-time data streaming and change capture without heavy database queries. This makes it ideal for building reactive applications, data pipelines, and external integrations.
Key Features:
  • Outputs changes as JSON objects
  • Supports multiple output formats (e.g., insert, update, delete)
  • Configurable filtering for tables and operations
  • Integrates with PostgreSQL logical replication
Use Cases:
  • Real-time data synchronization with external systems
  • Auditing and logging database changes
  • Building event-driven architectures
Alternatives:
  • pg_recvlogical – PostgreSQL's native tool for receiving WAL data, but outputs in a binary format requiring custom parsing.
Version History
Detected Version Rev Change Commit
Sep 15, 2025 4:20pm 0 VERSION_BUMP 348f913e
Sep 27, 2024 8:04pm 0 VERSION_BUMP 3c6b5337
Sep 11, 2024 8:13pm 0 VERSION_BUMP d029acc1
Jan 31, 2024 9:23pm 1 VERSION_BUMP 50ed6492
Jan 11, 2024 12:32pm 0 VERSION_BUMP 8a080f9a
Sep 18, 2023 10:43pm 0 VERSION_BUMP 8b8c25c4
Mar 18, 2023 3:36am 0 VERSION_BUMP ac0e5865