A PostgreSQL deployment template for Railway, enabling quick setup with the Wal2Json plugin.

For more details about the Wal2Json plugin -> https://github.com/eulerto/wal2json

About Wal2Json

PostgreSQL records all changes—INSERTs, UPDATEs, and DELETEs—in a log called the Write-Ahead Log (WAL). This log ensures database consistency and allows for replication and recovery. However, WAL data is stored in a format optimized for internal database operations, not direct consumption.

Wal2Json bridges this gap by converting WAL changes into structured JSON output, making it easier for applications to process database updates in real time. This is especially useful for data replication, change auditing, event-driven architectures, and streaming data to external systems. The plugin works by using logical decoding, allowing applications to read database changes without requiring full physical replication.

Depending on configuration, UPDATE and DELETE operations can include previous row versions, making it possible to track before-and-after states of data changes. Changes can be consumed via logical replication slots for continuous streaming or queried directly using a SQL API.