The databases/timescaledb port
timescaledb-2.22.1 – database designed to make SQL scalable for time-series data (cvsweb github mirror)
Description
TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL and packaged as a PostgreSQL extension, providing automatic partitioning across time and space (partitioning key), as well as full SQL support.WWW: https://www.timescale.com/
Readme
+-----------------------------------------------------------------------
| Running ${PKGSTEM} on OpenBSD
+-----------------------------------------------------------------------
Enabling TimescaleDB
====================
You will need to edit your postgresql.conf file to include the TimescaleDB
library, and then restart PostgreSQL.
shared_preload_libraries = 'timescaledb'
Upgrading TimescaleDB
=====================
(Perform a backup beforehand)
You will need to start psql with '-X' and execute :
ALTER EXTENSION timescaledb UPDATE;
Executing '\dx timescaledb' should show the latest version number.
Telemetry
=========
TimescaleDB telemetry and version checking is disabled by default.
To turn on telemetry for a whole instance, simply include the following line
in your postgresql.conf file:
timescaledb.telemetry_level=basic
Alternatively, you can enable it from psql:
ALTER [SYSTEM | DATABASE | USER] { *db_name* | *role_specification* }
SET timescaledb.telemetry_level=basic;
Then reload the configuration.
To disable it again at a later time, replace 'basic' with 'off' in the above.
Maintainer
Renato Aguiar
Only for arches
aarch64 alpha amd64 mips64 mips64el powerpc64 riscv64 sparc64