Ability to output data changes via logical decoding (ex. wal2json)
PostgreSQL, since 9.4, has the ability to provide the list of changes made to a database in a manner that is transaction-safe and lossless.
To enable this feature, the wal_level needs to be set to logical and there needs to be an available output plugin. Unfortunately, PostgreSQL only comes with the test_decoding plugin, which was only really meant as an example.
AWS for example, has included wal2json support:
The simple wal2json output plugin would be a good way to provide access to this powerful feature for a wide audience.
I'd also be fine with other output plugins. It may be worth noting that there has been some discussion about including wal2json in the standard set of contrib plugins.
Looking forward to having some way to get this CDC data out of PostgreSQL with this great feature.
Jelmer van Amen commented
Any indication whether this is under consideration.
As per author's update this is the plugin: https://github.com/eulerto/wal2json
Patrick Earl commented
That should be wal2json, not wol2json.