[pkgsrc/trunk]: pkgsrc/databases databases: Add postgresql-wal2json 2.3

[otis <otis%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/aa3779cffbea
branches:  trunk
changeset: 442996:aa3779cffbea
user:      otis <otis%pkgsrc.org@localhost>
date:      Sat Dec 05 09:04:58 2020 +0000

description:
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.

diffstat:

 databases/Makefile                     |   3 ++-
 databases/postgresql-wal2json/DESCR    |  16 ++++++++++++++++
 databases/postgresql-wal2json/Makefile |  21 +++++++++++++++++++++
 databases/postgresql-wal2json/PLIST    |   2 ++
 databases/postgresql-wal2json/distinfo |   6 ++++++
 5 files changed, 47 insertions(+), 1 deletions(-)

diffs (78 lines):

diff -r 129158835320 -r aa3779cffbea databases/Makefile
--- a/databases/Makefile        Sat Dec 05 08:52:42 2020 +0000
+++ b/databases/Makefile        Sat Dec 05 09:04:58 2020 +0000
@@ -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-promscale_extension
 SUBDIR+=       postgresql-redislog
 SUBDIR+=       postgresql-timescaledb
+SUBDIR+=       postgresql-wal2json
 SUBDIR+=       postgresql10
 SUBDIR+=       postgresql10-client
 SUBDIR+=       postgresql10-contrib
diff -r 129158835320 -r aa3779cffbea databases/postgresql-wal2json/DESCR
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql-wal2json/DESCR       Sat Dec 05 09:04:58 2020 +0000
@@ -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 -r 129158835320 -r aa3779cffbea databases/postgresql-wal2json/Makefile
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql-wal2json/Makefile    Sat Dec 05 09:04:58 2020 +0000
@@ -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@localhost
+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 -r 129158835320 -r aa3779cffbea databases/postgresql-wal2json/PLIST
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql-wal2json/PLIST       Sat Dec 05 09:04:58 2020 +0000
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1 2020/12/05 09:04:58 otis Exp $
+lib/postgresql/wal2json.so
diff -r 129158835320 -r aa3779cffbea databases/postgresql-wal2json/distinfo
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql-wal2json/distinfo    Sat Dec 05 09:04:58 2020 +0000
@@ -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