Change data capture in Postgres: How to use logical decoding and wal2json

Brent -

The idea of consumer is to ingest changes in the database in a neutral format like JSON. The Consumer can then send the data to any target. For example, in this PGConf.EU presentation Webedia uses a custom service called walparser to convert wal2json’s output into MQ messages, then sends the messages to RabbitMQ and ElasticSearch. Another example is Netflix’s DBLog. Now your question is PostgreSQL as a consumer. Are you thinking of a scenario where I can take WAL from version X of Postgres and push it to version Y of Postgres engine? You can design a consumer app to feed data into target PostgreSQL.  For same PG versions, there is no reason to convert WAL to an intermediate format as it can be consumed directly.

thanks

Sunil