PORTNAME=	wal2json

PORTVERSION=	2.3

CATEGORIES=	databases

PKGNAMEPREFIX=	postgresql${PGSQL_VER:S/.//}-

MAINTAINER=	daniel@morante.net

COMMENT=	JSON output plugin for changeset extraction for PostgreSQL databases

LICENSE=	BSD3CLAUSE

LICENSE_FILE=	${WRKSRC}/LICENSE

USES=		gmake pgsql:9.6-13

WANT_PGSQL=	server

USE_GITHUB=	yes

GH_ACCOUNT=	eulerto

GH_TAGNAME=	${PORTNAME}_${PORTVERSION:S/./_/}

MAKE_ARGS=	PG_CONFIG=${LOCALBASE}/bin/pg_config

PLIST_FILES=	lib/postgresql/wal2json.so

.include <bsd.port.mk>

TIMESTAMP = 1629177407

SHA256 (eulerto-wal2json-2.3-wal2json_2_3_GH0.tar.gz) = 2ebf71ace3c9f4b66703bcf6e3fa6ef7b6b026f9e31db4cf864eb3deb4e1a5b3

SIZE (eulerto-wal2json-2.3-wal2json_2_3_GH0.tar.gz) = 87413

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.

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

[

{ type: install

  message: <<EOM

You need to set up at least two parameters in postgresql.conf:

	wal_level = logical

	#

	# these parameters only need to set in versions 9.4, 9.5 and 9.6

	# default values are ok in version 10 or later

	#

	max_replication_slots = 10

	max_wal_senders = 10

After changing these parameters, a restart is needed.

EOM

}

]