Le Mon, May 27, 2024 at 06:55:26PM -0700, Renato Aguiar a écrit :
> Diff updating timescaledb to 2.15.0.
> 
> This version has an additional upgrade step that requires running a SQL
> script that isn't included in release tarball. I added a note with a
> download link to the port README, but I'm wondering if we should include
> it in the port instead.
> 

I would add it to the port and print a message at the end of the installation.

Other than that, it is OK denis@

> diff --git a/databases/timescaledb/Makefile b/databases/timescaledb/Makefile
> index 46389fd2322..44e1e5b167d 100644
> --- a/databases/timescaledb/Makefile
> +++ b/databases/timescaledb/Makefile
> @@ -2,7 +2,7 @@ COMMENT =	database designed to make SQL scalable for time-series data
>  
>  GH_ACCOUNT =	timescale
>  GH_PROJECT =	timescaledb
> -GH_TAGNAME =	2.14.2
> +GH_TAGNAME =	2.15.0
>  
>  CATEGORIES =	databases
>  HOMEPAGE =	https://www.timescale.com/
> diff --git a/databases/timescaledb/distinfo b/databases/timescaledb/distinfo
> index a0e20a0d44b..82530f1aa61 100644
> --- a/databases/timescaledb/distinfo
> +++ b/databases/timescaledb/distinfo
> @@ -1,2 +1,2 @@
> -SHA256 (timescaledb-2.14.2.tar.gz) = x3aLJn6meRTQSRso2hAvrs0xcGDkKbLadTBRf7yU5zs=
> -SIZE (timescaledb-2.14.2.tar.gz) = 7319288
> +SHA256 (timescaledb-2.15.0.tar.gz) = /yAZ9zRWb3OvCoBB21D38dCtaWf34ufXltOIzTjAtbs=
> +SIZE (timescaledb-2.15.0.tar.gz) = 7428047
> diff --git a/databases/timescaledb/pkg/PLIST b/databases/timescaledb/pkg/PLIST
> index 5f2f8860e11..5b6187b300a 100644
> --- a/databases/timescaledb/pkg/PLIST
> +++ b/databases/timescaledb/pkg/PLIST
> @@ -18,6 +18,7 @@ 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--2.14.2--${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
> diff --git a/databases/timescaledb/pkg/README b/databases/timescaledb/pkg/README
> index a7f10d9aa05..478be4f2c7a 100644
> --- a/databases/timescaledb/pkg/README
> +++ b/databases/timescaledb/pkg/README
> @@ -18,6 +18,14 @@ You will need to start psql with '-X' and execute :
>  
>  Executing '\dx timescaledb' should show the latest version number.
>  
> +If you are upgrading from versions prior to 2.15.0, you must also download and
> +run this SQL script:
> +
> +  https://github.com/timescale/timescaledb-extras/blob/master/utils/2.15.X-fix_hypertable_foreign_keys.sql
> +
> +See changelog at https://github.com/timescale/timescaledb/releases/tag/2.15.0
> +for more details.
> +
>  Telemetry
>  =========
>  TimescaleDB telemetry and version checking is disabled by default.

> 
> -- 
> Renato Aguiar