BSD Ports

databases/postgresql-wal2json 2.6 NetBSD

Plugin to decode PostgreSQL WAL to JSON

System
NetBSD
Repository
pkgsrc
Maintainer
[email protected]
License
modified-bsd
Categories
databases
Package size
18.7 KiB, 48.5 KiB installed

Description

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

In the other systems

SystemPortVersion
NetBSDdatabases/postgresql-wal2json2.6
FreeBSDdatabases/postgresql-wal2json2.5
DragonFlydatabases/postgresql-wal2json2.5
MidnightBSDdatabases/postgresql-wal2json2.5

Install

Binary package:

pkgin install postgresql14-wal2json

From pkgsrc:

cd /usr/pkgsrc/databases/postgresql-wal2json && make install clean

Dependencies

Run dependencies 2

No port depends on this one.

Configuration

No options to configure.

Service scripts
none
Flavors
postgresql15-wal2json-2.6, postgresql16-wal2json-2.6, postgresql17-wal2json-2.6, postgresql18-wal2json-2.6