CVS commit: pkgsrc/databases/postgresql-timescaledb

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Jan 22 09:10:14 UTC 2024

Modified Files:
        pkgsrc/databases/postgresql-timescaledb: Makefile PLIST distinfo

Log Message:
postgresql-timescaledb: updated to 2.13.1

2.13.1 (2024-01-09)

This release contains bug fixes since the 2.13.0 release.
We recommend that you upgrade at the next available opportunity.

**Bugfixes**
* Use numrows_pre_compression in approximate row count
* Use processed group clauses in PG16
* Change bgw_log_level to use PGC_SUSET
* Disable vectorized sum for expressions.
* Read CAgg watermark from materialized data
* Fix groupby pathkeys for gapfill in PG16
* Fix index matching during DML decompression
* Fix compressed chunk permission handling on PG16
* Fix lost concurrent CAgg updates
* Fix unique expression indexes on compressed chunks
* Fix use of freed path in decompression sort logic

**Thanks**
* @MA-MacDonald for reporting an issue with gapfill in PG16
* @aarondglover for reporting an issue with unique expression indexes on compressed chunks
* @adriangb for reporting an issue with security barrier views on pg16

2.13.0 (2023-11-28)

This release contains performance improvements, an improved hypertable DDL API
and bug fixes since the 2.12.2 release. We recommend that you upgrade at the next
available opportunity.

In addition, it includes these noteworthy features:

* Full PostgreSQL 16 support for all existing features
* Vectorized aggregation execution for sum()
* Track chunk creation time used in retention/compression policies

**Deprecation notice: Multi-node support**
TimescaleDB 2.13 is the last version that will include multi-node support. Multi-node
support in 2.13 is available for PostgreSQL 13, 14 and 15. Learn more about it
[here](docs/MultiNodeDeprecation.md).

If you want to migrate from multi-node TimescaleDB to single-node TimescaleDB read the
[migration documentation](https://docs.timescale.com/migrate/latest/multi-node-to-timescale-service/).

**PostgreSQL 13 deprecation announcement**
We will continue supporting PostgreSQL 13 until April 2024. Sooner to that time, we will announce the specific version of TimescaleDB in which PostgreSQL 13 support will not be included going forward.

**Starting from TimescaleDB 2.13.0**
* No Amazon Machine Images (AMI) are published. If you previously used AMI, please
use another [installation method](https://docs.timescale.com/self-hosted/latest/install/)
* Continuous Aggregates are materialized only (non-realtime) by default

**Features**
* Add chunk-wise sorted paths for compressed chunks
* Simplify hypertable DDL API
* Reduce WAL activity by freezing compressed tuples immediately
* Vectorized aggregation execution for sum()
* Add metadata for chunk creation time
* Make Continous Aggregates materialized only (non-realtime) by default
* Change show_chunks/drop_chunks using chunk creation time
* Show batches/tuples decompressed during DML operations in EXPLAIN output
* Keep track of catalog version
* Use creation time in retention/compression policy
* Add SQL function cagg_validate_query

**Bugfixes**
* Add GUC for setting background worker log level
* Allow enabling compression on hypertable with unique expression index
* Check if worker registration succeeded
* Fix exception detail passing in compression_policy_execute
* Fix missing bms_del_member result assignment
* Fix negative bitmapset member not allowed in compression
* Potential data loss when compressing a table with a partial index that matches compression order.
* Add support for startup chunk exclusion with aggs
* Repair relacl on upgrade
* Fix segfault when creating a cagg using a NULL width in time bucket function
* Make timescaledb_functions.makeaclitem strict
* Fix typmod and collation for segmentby columns
* Fix tablespace with constraints
* Enable segmentwise recompression in compression policy


To generate a diff of this commit:
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/postgresql-timescaledb/Makefile
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql-timescaledb/PLIST
cvs rdiff -u -r1.22 -r1.23 pkgsrc/databases/postgresql-timescaledb/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/postgresql-timescaledb/Makefile
diff -u pkgsrc/databases/postgresql-timescaledb/Makefile:1.23 pkgsrc/databases/postgresql-timescaledb/Makefile:1.24
--- pkgsrc/databases/postgresql-timescaledb/Makefile:1.23       Fri Nov  3 09:15:34 2023
+++ pkgsrc/databases/postgresql-timescaledb/Makefile    Mon Jan 22 09:10:14 2024
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.23 2023/11/03 09:15:34 adam Exp $
+# $NetBSD: Makefile,v 1.24 2024/01/22 09:10:14 adam Exp $
 
-DISTNAME=      timescaledb-2.12.1
+DISTNAME=      timescaledb-2.13.1
 PKGNAME=       postgresql${PGSQL_VERSION}-${DISTNAME}
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_GITHUB:=timescale/}
@@ -16,7 +16,15 @@ DEPENDS+=    postgresql${PGSQL_VERSION}-ser
 CMAKE_ARGS+=   -DUSE_OPENSSL=ON
 CMAKE_ARGS+=   -DREGRESS_CHECKS=OFF
 
-PGSQL_VERSIONS_ACCEPTED=       15 14 13
+.include "../../mk/bsd.prefs.mk"
+
+.if ${SHLIB_TYPE} == "dylib"
+PLIST_SUBST+=  SOEXT=dylib
+.else
+PLIST_SUBST+=  SOEXT=so
+.endif
+
+PGSQL_VERSIONS_ACCEPTED=       16 15 14 13
 
 PKG_OPTIONS_VAR=               PKG_OPTIONS.timescaledb
 PKG_SUPPORTED_OPTIONS+=                timescale-license

Index: pkgsrc/databases/postgresql-timescaledb/PLIST
diff -u pkgsrc/databases/postgresql-timescaledb/PLIST:1.20 pkgsrc/databases/postgresql-timescaledb/PLIST:1.21
--- pkgsrc/databases/postgresql-timescaledb/PLIST:1.20  Fri Nov  3 09:15:34 2023
+++ pkgsrc/databases/postgresql-timescaledb/PLIST       Mon Jan 22 09:10:14 2024
@@ -1,7 +1,7 @@
-@comment $NetBSD: PLIST,v 1.20 2023/11/03 09:15:34 adam Exp $
-lib/postgresql/timescaledb-${PKGVERSION}.so
-${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.so
-lib/postgresql/timescaledb.so
+@comment $NetBSD: PLIST,v 1.21 2024/01/22 09:10:14 adam Exp $
+lib/postgresql/timescaledb-${PKGVERSION}.${SOEXT}
+${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.${SOEXT}
+lib/postgresql/timescaledb.${SOEXT}
 share/postgresql/extension/timescaledb--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.1.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.1.1--${PKGVERSION}.sql
@@ -13,6 +13,9 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.11.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.11.2--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.12.0--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.12.1--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.12.2--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.13.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.2.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.2.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.3.0--${PKGVERSION}.sql

Index: pkgsrc/databases/postgresql-timescaledb/distinfo
diff -u pkgsrc/databases/postgresql-timescaledb/distinfo:1.22 pkgsrc/databases/postgresql-timescaledb/distinfo:1.23
--- pkgsrc/databases/postgresql-timescaledb/distinfo:1.22       Fri Nov  3 09:15:34 2023
+++ pkgsrc/databases/postgresql-timescaledb/distinfo    Mon Jan 22 09:10:14 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.22 2023/11/03 09:15:34 adam Exp $
+$NetBSD: distinfo,v 1.23 2024/01/22 09:10:14 adam Exp $
 
-BLAKE2s (timescaledb-2.12.1.tar.gz) = d94a4e557f6da33f65b10d107bc1f3d085dff560da874a3e122a2617eda73e7d
-SHA512 (timescaledb-2.12.1.tar.gz) = 0b005446eab4f3b3cf1abea6ef1cbbd77a50de40402bba1a9ba5049315b4c8ecba0e45af3288c865076534b3b0eaca68cdbe31026deaca1cdb2ab5f493bfb925
-Size (timescaledb-2.12.1.tar.gz) = 7519337 bytes
+BLAKE2s (timescaledb-2.13.1.tar.gz) = af0b4f798590feb2d89c93d5facfe41f4e553ae1fdd03c83b3558d186301b013
+SHA512 (timescaledb-2.13.1.tar.gz) = 4416d5a3693ebe20af95903abc4fbd54b13651acbb9a3b4a0eb5cbd69d00c54d73f2abcdfe195edd9f6d14a90667121dac5b3adea20b3efbe50e0318c340c8be
+Size (timescaledb-2.13.1.tar.gz) = 8239930 bytes