A PostgreSQL logical decoder output plugin to deliver data in JSON
- PostgreSQL 9.4+
- libjansson (for JSON support)
make deps
make
Add to your postgresql.conf lines from logical.conf. Then run:
sudo chmod +x `pg_config --pkglibdir`
make test
Use built-in JSON from PostgreSQL for output generation.
- https://github.com/xstevens/decoderbufs - uses Protocol Buffers
- https://github.com/michaelpq/pg_plugins/tree/master/decoder_raw - generates SQL queries
- https://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=contrib/test_decoding;h=ed74920f61b3440d2d880a8fdfc74ec8d12fcd35;hb=HEAD - sample decoder from postgresql sources