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
