Home

The databases/timescaledb port

timescaledb-2.16.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 arm hppa i386 mips64 mips64el powerpc powerpc64 riscv64 sparc64

Categories

databases

Library dependencies

Build dependencies

Run dependencies

Files

Search