databases: Add postgresql-wal2json 2.3

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.

5 files changed, 47 insertions, 1 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 46e697bb018..55a7b7170ba 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.619 2020/11/03 23:01:59 tnn Exp $
+# $NetBSD: Makefile,v 1.620 2020/12/05 09:04:58 otis Exp $
 
 COMMENT=	Databases
 
@@ -295,6 +295,7 @@ SUBDIR+=	postgresql-postgis2
 SUBDIR+=	postgresql-promscale_extension
 SUBDIR+=	postgresql-redislog
 SUBDIR+=	postgresql-timescaledb
+SUBDIR+=	postgresql-wal2json
 SUBDIR+=	postgresql10
 SUBDIR+=	postgresql10-client
 SUBDIR+=	postgresql10-contrib
diff --git a/databases/postgresql-wal2json/DESCR b/databases/postgresql-wal2json/DESCR
new file mode 100644
index 00000000000..a724e4c4d56
--- /dev/null
+++ b/databases/postgresql-wal2json/DESCR
@@ -0,0 +1,16 @@
+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
diff --git a/databases/postgresql-wal2json/Makefile b/databases/postgresql-wal2json/Makefile
new file mode 100644
index 00000000000..a76d22c05ee
--- /dev/null
+++ b/databases/postgresql-wal2json/Makefile
@@ -0,0 +1,21 @@
+# $NetBSD: Makefile,v 1.1 2020/12/05 09:04:58 otis Exp $
+
+WAL2JSONVERSION=	2.3
+GITHUB_PROJECT=		wal2json
+GITHUB_TAG=		${GITHUB_PROJECT}_${WAL2JSONVERSION:C/\./_/}
+DISTNAME=		${GITHUB_PROJECT}_${WAL2JSONVERSION:C/\./_/}
+PKGNAME=		postgresql${PGSQL_VERSION}-${GITHUB_PROJECT}-${WAL2JSONVERSION}
+CATEGORIES=		databases
+MASTER_SITES=		${MASTER_SITE_GITHUB:=eulerto/}
+
+MAINTAINER=	otis@NetBSD.org
+HOMEPAGE=	https://github.com/eulerto/wal2json
+COMMENT=	Plugin to decode PostgreSQL WAL to JSON
+LICENSE=	modified-bsd
+
+DEPENDS+=	postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server
+
+USE_TOOLS+=	gmake
+
+.include "../../mk/pgsql.buildlink3.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql-wal2json/PLIST b/databases/postgresql-wal2json/PLIST
new file mode 100644
index 00000000000..26680a2bcca
--- /dev/null
+++ b/databases/postgresql-wal2json/PLIST
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1 2020/12/05 09:04:58 otis Exp $
+lib/postgresql/wal2json.so
diff --git a/databases/postgresql-wal2json/distinfo b/databases/postgresql-wal2json/distinfo
new file mode 100644
index 00000000000..79a97aab471
--- /dev/null
+++ b/databases/postgresql-wal2json/distinfo
@@ -0,0 +1,6 @@
+$NetBSD: distinfo,v 1.1 2020/12/05 09:04:58 otis Exp $
+
+SHA1 (wal2json_2_3.tar.gz) = 923f9bbcd0505a1f0b6eac1d371e4ff2d266a958
+RMD160 (wal2json_2_3.tar.gz) = ddd2a36503a2ec99e5a33e9fd9629612172db5fc
+SHA512 (wal2json_2_3.tar.gz) = 968f15a64daba77ad439fc95e4091ec2fe8581bf40559f1ff3a2c75c129e4954b43eea7300678a0b27a7fc880f25266e39aa8b9bc8bd2c9001661fc93f9c981f
+Size (wal2json_2_3.tar.gz) = 87413 bytes