On Tue, May 28 2024, Denis Fondras wrote:

> Le Mon, May 27, 2024 at 06:55:26PM -0700, Renato Aguiar a écrit :
>
> I would add it to the port and print a message at the end of the installation.
>

Here is a new diff adding the sql script, the post-install message and
also updating it to version 2.15.1 (which was just released).

diff --git a/databases/timescaledb/Makefile b/databases/timescaledb/Makefile
index 46389fd2322..658c95bb727 100644
--- a/databases/timescaledb/Makefile
+++ b/databases/timescaledb/Makefile
@@ -1,8 +1,11 @@
 COMMENT =	database designed to make SQL scalable for time-series data
 
-GH_ACCOUNT =	timescale
-GH_PROJECT =	timescaledb
-GH_TAGNAME =	2.14.2
+V =		2.15.1
+EXTRAS_COMMIT =	52443a469a58d3f64a4e049889f468e8a149cc8f
+PKGNAME =	timescaledb-${V}
+
+DIST_TUPLE +=	github timescale timescaledb ${V} .
+DIST_TUPLE +=	github timescale timescaledb-extras ${EXTRAS_COMMIT} _extras
 
 CATEGORIES =	databases
 HOMEPAGE =	https://www.timescale.com/
@@ -15,7 +18,7 @@ PERMIT_PACKAGE = Yes
 MODULES =	devel/cmake
 SUBST_VARS +=	GH_TAGNAME
 
-WANTLIB =	c crypto pq ssl
+WANTLIB =	crypto pq ssl
 
 COMPILER =	base-clang ports-gcc
 
@@ -29,4 +32,12 @@ CONFIGURE_ARGS +=	-DREGRESS_CHECKS=OFF \
 			-DSEND_TELEMETRY_DEFAULT=OFF \
 			-DCMAKE_DISABLE_FIND_PACKAGE_Git=ON
 
+SUBST_VARS =	V
+
+post-install:
+	${INSTALL_DATA_DIR} ${PREFIX}/share/timescaledb
+	${INSTALL_DATA} \
+		${WRKSRC}/_extras/utils/2.15.X-fix_hypertable_foreign_keys.sql \
+		${PREFIX}/share/timescaledb
+
 .include <bsd.port.mk>
diff --git a/databases/timescaledb/distinfo b/databases/timescaledb/distinfo
index a0e20a0d44b..ef7c024f064 100644
--- a/databases/timescaledb/distinfo
+++ b/databases/timescaledb/distinfo
@@ -1,2 +1,4 @@
-SHA256 (timescaledb-2.14.2.tar.gz) = x3aLJn6meRTQSRso2hAvrs0xcGDkKbLadTBRf7yU5zs=
-SIZE (timescaledb-2.14.2.tar.gz) = 7319288
+SHA256 (timescale-timescaledb-2.15.1.tar.gz) = IOLdxPtzaN61soxnilTj5gk7nA8dyghy0LbIkk6IWEo=
+SHA256 (timescale-timescaledb-extras-52443a469a58d3f64a4e049889f468e8a149cc8f.tar.gz) = /fBZ0+p3BcPYlmf7Oj4cqXKF19YpWJaywrt0qGuZqvw=
+SIZE (timescale-timescaledb-2.15.1.tar.gz) = 7434713
+SIZE (timescale-timescaledb-extras-52443a469a58d3f64a4e049889f468e8a149cc8f.tar.gz) = 12981
diff --git a/databases/timescaledb/pkg/MESSAGE b/databases/timescaledb/pkg/MESSAGE
new file mode 100644
index 00000000000..d422a212a3d
--- /dev/null
+++ b/databases/timescaledb/pkg/MESSAGE
@@ -0,0 +1,3 @@
+If you are upgrading from versions prior to 2.15.0, after you run 'ALTER
+EXTENSION', you must also run this SQL script:
+${PREFIX}/share/timescaledb/2.15.X-fix_hypertable_foreign_keys.sql
diff --git a/databases/timescaledb/pkg/PLIST b/databases/timescaledb/pkg/PLIST
index 5f2f8860e11..3f9a22b44a1 100644
--- a/databases/timescaledb/pkg/PLIST
+++ b/databases/timescaledb/pkg/PLIST
@@ -1,43 +1,47 @@
-@so lib/postgresql/timescaledb-${GH_TAGNAME}.so
-@so lib/postgresql/timescaledb-tsl-${GH_TAGNAME}.so
+@so lib/postgresql/timescaledb-${V}.so
+@so lib/postgresql/timescaledb-tsl-${V}.so
 @so lib/postgresql/timescaledb.so
 share/doc/pkg-readmes/${PKGSTEM}
-share/postgresql/extension/timescaledb--2.1.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.1.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.10.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.10.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.10.2--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.10.3--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.11.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.11.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.11.2--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.12.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.12.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.12.2--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.13.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.13.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.14.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.14.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.2.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.2.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.3.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.3.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.4.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.4.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.4.2--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.5.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.5.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.5.2--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.6.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.6.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.7.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.7.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.7.2--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.8.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.8.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.9.0--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.9.1--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.9.2--${GH_TAGNAME}.sql
-share/postgresql/extension/timescaledb--2.9.3--${GH_TAGNAME}.sql
+share/postgresql/extension/timescaledb--2.1.0--${V}.sql
+share/postgresql/extension/timescaledb--2.1.1--${V}.sql
+share/postgresql/extension/timescaledb--2.10.0--${V}.sql
+share/postgresql/extension/timescaledb--2.10.1--${V}.sql
+share/postgresql/extension/timescaledb--2.10.2--${V}.sql
+share/postgresql/extension/timescaledb--2.10.3--${V}.sql
+share/postgresql/extension/timescaledb--2.11.0--${V}.sql
+share/postgresql/extension/timescaledb--2.11.1--${V}.sql
+share/postgresql/extension/timescaledb--2.11.2--${V}.sql
+share/postgresql/extension/timescaledb--2.12.0--${V}.sql
+share/postgresql/extension/timescaledb--2.12.1--${V}.sql
+share/postgresql/extension/timescaledb--2.12.2--${V}.sql
+share/postgresql/extension/timescaledb--2.13.0--${V}.sql
+share/postgresql/extension/timescaledb--2.13.1--${V}.sql
+share/postgresql/extension/timescaledb--2.14.0--${V}.sql
+share/postgresql/extension/timescaledb--2.14.1--${V}.sql
+share/postgresql/extension/timescaledb--2.14.2--${V}.sql
+share/postgresql/extension/timescaledb--2.15.0--${V}.sql
+share/postgresql/extension/timescaledb--${V}.sql
+share/postgresql/extension/timescaledb--2.2.0--${V}.sql
+share/postgresql/extension/timescaledb--2.2.1--${V}.sql
+share/postgresql/extension/timescaledb--2.3.0--${V}.sql
+share/postgresql/extension/timescaledb--2.3.1--${V}.sql
+share/postgresql/extension/timescaledb--2.4.0--${V}.sql
+share/postgresql/extension/timescaledb--2.4.1--${V}.sql
+share/postgresql/extension/timescaledb--2.4.2--${V}.sql
+share/postgresql/extension/timescaledb--2.5.0--${V}.sql
+share/postgresql/extension/timescaledb--2.5.1--${V}.sql
+share/postgresql/extension/timescaledb--2.5.2--${V}.sql
+share/postgresql/extension/timescaledb--2.6.0--${V}.sql
+share/postgresql/extension/timescaledb--2.6.1--${V}.sql
+share/postgresql/extension/timescaledb--2.7.0--${V}.sql
+share/postgresql/extension/timescaledb--2.7.1--${V}.sql
+share/postgresql/extension/timescaledb--2.7.2--${V}.sql
+share/postgresql/extension/timescaledb--2.8.0--${V}.sql
+share/postgresql/extension/timescaledb--2.8.1--${V}.sql
+share/postgresql/extension/timescaledb--2.9.0--${V}.sql
+share/postgresql/extension/timescaledb--2.9.1--${V}.sql
+share/postgresql/extension/timescaledb--2.9.2--${V}.sql
+share/postgresql/extension/timescaledb--2.9.3--${V}.sql
 share/postgresql/extension/timescaledb.control
+share/timescaledb/
+share/timescaledb/2.15.X-fix_hypertable_foreign_keys.sql


-- 
Renato Aguiar

• timescaledb.patch (8K)