databases/postgresql-wal2json - The NetBSD Packages Collection

Plugin to decode PostgreSQL WAL to JSON

wal2json is an output plugin for logical decoding. It means that the plugin
have access to tuples produced by INSERT and UPDATE. Also, UPDATE/DELETE old
row versions can be accessed depending on the configured replica identity.
Changes can be consumed using the streaming protocol (logical replication
slots) or by a special SQL API.

format version 1 produces a JSON object per transaction. All of the new/old
tuples are available in the JSON object. Also, there are options to include
properties such as transaction timestamp, schema-qualified, data types, and
transaction ids.

format version 2 produces a JSON object per tuple. Optional JSON object for
beginning and end of transaction. Also, there are a variety of options to
include properties.

WWW: https://github.com/eulerto/wal2json

Build dependencies

pkgtools/mktools devel/gmake pkgtools/cwrappers

Runtime dependencies

databases/postgresql14-server databases/postgresql14-client databases/postgresql14-client

Binary packages

OSArchitectureVersion
NetBSD 10.0aarch64postgresql12-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql13-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql14-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql15-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql16-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql11-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql12-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql13-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql14-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql15-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql16-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql12-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql13-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql14-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql15-wal2json-2.5.tgz
NetBSD 10.0aarch64postgresql16-wal2json-2.5.tgz
NetBSD 10.0aarch64ebpostgresql12-wal2json-2.5.tgz
NetBSD 10.0aarch64ebpostgresql13-wal2json-2.5.tgz
NetBSD 10.0aarch64ebpostgresql14-wal2json-2.5.tgz
NetBSD 10.0aarch64ebpostgresql15-wal2json-2.5.tgz
NetBSD 10.0aarch64ebpostgresql16-wal2json-2.5.tgz
NetBSD 10.0aarch64ebpostgresql12-wal2json-2.5.tgz
NetBSD 10.0aarch64ebpostgresql13-wal2json-2.5.tgz
NetBSD 10.0aarch64ebpostgresql14-wal2json-2.5.tgz
NetBSD 10.0aarch64ebpostgresql15-wal2json-2.5.tgz
NetBSD 10.0aarch64ebpostgresql16-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql11-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql12-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql13-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql14-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql15-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql16-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql12-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql13-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql14-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql15-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql16-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql12-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql13-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql14-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql15-wal2json-2.5.tgz
NetBSD 10.0earmv6hfpostgresql16-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql12-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql13-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql14-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql15-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql16-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql11-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql12-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql13-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql14-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql15-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql16-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql12-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql13-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql14-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql15-wal2json-2.5.tgz
NetBSD 10.0earmv7hfpostgresql16-wal2json-2.5.tgz
NetBSD 10.0i386postgresql12-wal2json-2.5.tgz
NetBSD 10.0i386postgresql13-wal2json-2.5.tgz
NetBSD 10.0i386postgresql14-wal2json-2.5.tgz
NetBSD 10.0i386postgresql15-wal2json-2.5.tgz
NetBSD 10.0i386postgresql16-wal2json-2.5.tgz
NetBSD 10.0i386postgresql11-wal2json-2.5.tgz
NetBSD 10.0i386postgresql12-wal2json-2.5.tgz
NetBSD 10.0i386postgresql13-wal2json-2.5.tgz
NetBSD 10.0i386postgresql14-wal2json-2.5.tgz
NetBSD 10.0i386postgresql15-wal2json-2.5.tgz
NetBSD 10.0i386postgresql16-wal2json-2.5.tgz
NetBSD 10.0i386postgresql12-wal2json-2.5.tgz
NetBSD 10.0i386postgresql13-wal2json-2.5.tgz
NetBSD 10.0i386postgresql14-wal2json-2.5.tgz
NetBSD 10.0i386postgresql15-wal2json-2.5.tgz
NetBSD 10.0i386postgresql16-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql10-wal2json-2.3.tgz
NetBSD 10.0powerpcpostgresql10-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql11-wal2json-2.3.tgz
NetBSD 10.0powerpcpostgresql11-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql12-wal2json-2.3.tgz
NetBSD 10.0powerpcpostgresql12-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql13-wal2json-2.3.tgz
NetBSD 10.0powerpcpostgresql13-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql14-wal2json-2.3.tgz
NetBSD 10.0powerpcpostgresql14-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql15-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql16-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql10-wal2json-2.3.tgz
NetBSD 10.0powerpcpostgresql10-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql11-wal2json-2.3.tgz
NetBSD 10.0powerpcpostgresql11-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql12-wal2json-2.3.tgz
NetBSD 10.0powerpcpostgresql12-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql13-wal2json-2.3.tgz
NetBSD 10.0powerpcpostgresql13-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql14-wal2json-2.3.tgz
NetBSD 10.0powerpcpostgresql14-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql15-wal2json-2.5.tgz
NetBSD 10.0powerpcpostgresql16-wal2json-2.5.tgz
NetBSD 10.0sparc64postgresql12-wal2json-2.5.tgz
NetBSD 10.0sparc64postgresql13-wal2json-2.5.tgz
NetBSD 10.0sparc64postgresql14-wal2json-2.5.tgz
NetBSD 10.0sparc64postgresql15-wal2json-2.5.tgz
NetBSD 10.0sparc64postgresql16-wal2json-2.5.tgz
NetBSD 10.0sparc64postgresql12-wal2json-2.5.tgz
NetBSD 10.0sparc64postgresql13-wal2json-2.5.tgz
NetBSD 10.0sparc64postgresql14-wal2json-2.5.tgz
NetBSD 10.0sparc64postgresql15-wal2json-2.5.tgz
NetBSD 10.0sparc64postgresql16-wal2json-2.5.tgz
NetBSD 10.0sparcpostgresql12-wal2json-2.5.tgz
NetBSD 10.0sparcpostgresql13-wal2json-2.5.tgz
NetBSD 10.0sparcpostgresql14-wal2json-2.5.tgz
NetBSD 10.0sparcpostgresql15-wal2json-2.5.tgz
NetBSD 10.0sparcpostgresql12-wal2json-2.5.tgz
NetBSD 10.0sparcpostgresql13-wal2json-2.5.tgz
NetBSD 10.0sparcpostgresql14-wal2json-2.5.tgz
NetBSD 10.0sparcpostgresql15-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql12-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql13-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql14-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql15-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql16-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql11-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql12-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql13-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql14-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql15-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql16-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql12-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql13-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql14-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql15-wal2json-2.5.tgz
NetBSD 10.0x86_64postgresql16-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql12-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql13-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql14-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql15-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql16-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql11-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql12-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql13-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql14-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql15-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql16-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql12-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql13-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql14-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql15-wal2json-2.5.tgz
NetBSD 9.0aarch64postgresql16-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql12-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql13-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql14-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql15-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql16-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql11-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql12-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql13-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql14-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql15-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql16-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql12-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql13-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql14-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql15-wal2json-2.5.tgz
NetBSD 9.0earmv6hfpostgresql16-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql12-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql13-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql14-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql15-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql16-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql11-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql12-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql13-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql14-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql15-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql16-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql12-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql13-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql14-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql15-wal2json-2.5.tgz
NetBSD 9.0earmv7hfpostgresql16-wal2json-2.5.tgz
NetBSD 9.0i386postgresql12-wal2json-2.5.tgz
NetBSD 9.0i386postgresql13-wal2json-2.5.tgz
NetBSD 9.0i386postgresql14-wal2json-2.5.tgz
NetBSD 9.0i386postgresql15-wal2json-2.5.tgz
NetBSD 9.0i386postgresql16-wal2json-2.5.tgz
NetBSD 9.0i386postgresql11-wal2json-2.5.tgz
NetBSD 9.0i386postgresql12-wal2json-2.5.tgz
NetBSD 9.0i386postgresql13-wal2json-2.5.tgz
NetBSD 9.0i386postgresql14-wal2json-2.5.tgz
NetBSD 9.0i386postgresql15-wal2json-2.5.tgz
NetBSD 9.0i386postgresql16-wal2json-2.5.tgz
NetBSD 9.0i386postgresql12-wal2json-2.5.tgz
NetBSD 9.0i386postgresql13-wal2json-2.5.tgz
NetBSD 9.0i386postgresql14-wal2json-2.5.tgz
NetBSD 9.0i386postgresql15-wal2json-2.5.tgz
NetBSD 9.0i386postgresql16-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql10-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql10-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql11-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql11-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql12-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql12-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql13-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql13-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql14-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql14-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql15-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql16-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql95-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql96-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql10-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql10-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql11-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql11-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql12-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql12-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql13-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql13-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql14-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql14-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql15-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql16-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql95-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql96-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql10-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql10-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql11-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql11-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql12-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql12-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql13-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql13-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql14-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql14-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql15-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql16-wal2json-2.5.tgz
NetBSD 9.0powerpcpostgresql95-wal2json-2.3.tgz
NetBSD 9.0powerpcpostgresql96-wal2json-2.3.tgz
NetBSD 9.0sparc64postgresql12-wal2json-2.5.tgz
NetBSD 9.0sparc64postgresql13-wal2json-2.5.tgz
NetBSD 9.0sparc64postgresql14-wal2json-2.5.tgz
NetBSD 9.0sparc64postgresql15-wal2json-2.5.tgz
NetBSD 9.0sparc64postgresql16-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql12-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql13-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql14-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql15-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql16-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql11-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql12-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql13-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql14-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql15-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql16-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql12-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql13-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql14-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql15-wal2json-2.5.tgz
NetBSD 9.0x86_64postgresql16-wal2json-2.5.tgz
NetBSD 9.3x86_64postgresql12-wal2json-2.5.tgz
NetBSD 9.3x86_64postgresql13-wal2json-2.5.tgz
NetBSD 9.3x86_64postgresql14-wal2json-2.5.tgz
NetBSD 9.3x86_64postgresql15-wal2json-2.5.tgz
NetBSD 9.3x86_64postgresql16-wal2json-2.5.tgz
NetBSD 9.3x86_64postgresql12-wal2json-2.5.tgz
NetBSD 9.3x86_64postgresql13-wal2json-2.5.tgz
NetBSD 9.3x86_64postgresql14-wal2json-2.5.tgz
NetBSD 9.3x86_64postgresql15-wal2json-2.5.tgz
NetBSD 9.3x86_64postgresql16-wal2json-2.5.tgz

Binary packages can be installed with the high-level tool pkgin (which can be installed with pkg_add) or pkg_add(1) (installed by default). The NetBSD packages collection is also designed to permit easy installation from source.

Available build options

(none)

Known vulnerabilities

The pkg_admin audit command locates any installed package which has been mentioned in security advisories as having vulnerabilities.

Please note the vulnerabilities database might not be fully accurate, and not every bug is exploitable with every configuration.


Problem reports, updates or suggestions for this package should be reported with send-pr.