timescaledb-2.28.3
database designed to make SQL scalable for time-series data
Back to search · Project homepage
Other branch: OpenBSD 7.9 release package details
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.
Package information
- Ports path
- databases/timescaledb
- Package architecture
- amd64
- Maintainer
- Mark Patruck <mark@wrapped.cx>
- Categories
- databases
- Available flavors
- None listed
- Only for architectures
- aarch64, alpha, amd64, mips64, mips64el, powerpc64, riscv64, sparc64
These are ports metadata. Binary availability depends on the release, architecture and mirror. Build and test dependencies are not an installation checklist.
Direct dependencies
Library
Runtime
Build
OpenBSD README
+-----------------------------------------------------------------------
| Running timescaledb 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.