diff options
author | otis <otis@pkgsrc.org> | 2020-12-05 09:04:58 +0000 |
---|---|---|
committer | otis <otis@pkgsrc.org> | 2020-12-05 09:04:58 +0000 |
commit | e0ae056766741daaf85522412f8984c91dccdd2d (patch) | |
tree | 9269b26747f50770f4d09c3c3f3727db2d34451c /databases | |
parent | b37ef996a090a899f6ca5d04d7bb3b739fd6a416 (diff) | |
download | pkgsrc-e0ae056766741daaf85522412f8984c91dccdd2d.tar.gz |
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 (limited to 'databases')
-rw-r--r-- | databases/Makefile | 3 | ||||
-rw-r--r-- | databases/postgresql-wal2json/DESCR | 16 | ||||
-rw-r--r-- | databases/postgresql-wal2json/Makefile | 21 | ||||
-rw-r--r-- | databases/postgresql-wal2json/PLIST | 2 | ||||
-rw-r--r-- | databases/postgresql-wal2json/distinfo | 6 |
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 |