wal2json 2.6

Notable changes in this release include:

• noew option to output numeric data types as string (#255)
• fix JSON for non-transactional messages in version 1
• fix deleted row reference for primary key in version 1 (#252)
• avoid variable shadowing
• fix lag tracking support for large transactions
• add macro to store version
• fix option include-pk when replica identity is full
• update documentation to the latest PostgreSQL version
• fix Red Hat package name
• add PostgreSQL 17 support
• update build infrastructure for Windows

Thanks to all users that submitted patches and also to all users who reported bugs.

New Contributors

• @robert-pang : first contribution in #252
• @shubhamdhama : first contribution in #255

All changes: wal2json_2_5...wal2json_2_6

waljson 2.5

Notable changes in this release include:

• fix bug that prevents a default value to be printed in v1 after a TRUNCATE
• document that write-in-chunks parameter is only used for v1
• add include-type-oids support in v2
• array type does not print the correct type name
• add lag tracking support (lag time in pg_stat_replication)
• add support to PostgreSQL 15

wal2json 2.4

Notable changes in this release include:

• Don't rely on index attribute names for primary key
• Filter was not applied for TRUNCATE
• Avoid duplicate double quotes for type names
• Refactor filter code to be used by both wal2json formats
• documentation improvements

Thanks to all users that submitted patches and also to all users who reported bugs.

wal2json 2.3

Notable changes in this release include:

• add parameter include-domain-data-type (replace domain name with its underlying data type)
• add support for Postgres 13
• add parameter filter-origins (filter out changes from replication origins)
• improve installation and configuration instructions
• fix an oversight for old minor versions
• add parameter include-column-positions (include pg_attribute.attnum)
• add parameter include-default (column default expression)
• add parameter include-pk (primary key)
• fix oversight in format 2: add nextlsn

Thanks to all users that who reported bugs and feature requests.

wal2json 2.2

This release contains a bug fix:

• Fix compilation for Postgres 9.4 and 9.5.

This bug affects wal2json 2.1 in older Postgres versions (9.4, 9.5).

wal2json 2.1

This release contains only bug fixes:

• fix oversight in actions option
• fix a memory leak while using add-tables and filter-tablesoption
• fix a segfault on 32 bits

Thanks to all users that submitted patches and also to all users who reported bugs.

wal2json 2.0

Notable changes in this release include:

• new wal2json format (one JSON per tuple)
• add option actions (choose actions among insert, update, delete, truncate)
• add option format-version (current is 1 and new is 2. default is 1)
• add option filter-msg-prefixes (filter messages by prefix)
• add option add-msg-prefixes (add messages by prefix)
• add option include-origin
• support TRUNCATE into wal2json output
• improve performance for REPLICA IDENTITY FULL
• add a bunch of tests

Observe the following incompatibilities:

• revert option include-unchanged-toast (unsafe)

Thanks to all users that submitted patches and also to all users who reported bugs and feature requests.

wal2json 1.0

First stable release.