openbsd-ports/databases/timescaledb/pkg
denis 603e76dd58 update to v2.7.1
Changelog : https://github.com/timescale/timescaledb/compare/2.7.0...2.7.1
2022-07-10 08:44:07 +00:00
..
DESCR
PLIST update to v2.7.1 2022-07-10 08:44:07 +00:00
README drop RCS Ids 2022-03-11 18:31:17 +00:00

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.