notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine

Bot filter coming soon

To deter bots pegging the database CPU to 100%, a bot testing filter to be added to the website. This should not affect newsfeeds etc. Anubis seems light-weight - it is already in use within the FreeBSD Project. This notice is just a heads up in case you see something odd. This notice will be updated after Anubis is installed.

Port details
timescaledb Time-series database built on PostgreSQL
2.20.2 databases on this many watch lists=5 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 2.19.0Version of this port present on the latest quarterly branch.
Maintainer: kbowling@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-06-30 21:08:56
Last Update: 2025-06-02 21:07:28
Commit Hash: b701365
People watching this port, also watch:: uwsgi-py311, nginx, redmine51, check_ssl_cert, burp
License: APACHE20 TSL
WWW:
https://www.timescale.com/
Description:
An open-source time-series database optimized for fast ingest and complex queries built on PostgreSQL.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (49 items)
Collapse this list.
  1. /usr/local/share/licenses/timescaledb-2.20.2/catalog.mk
  2. /usr/local/share/licenses/timescaledb-2.20.2/LICENSE
  3. /usr/local/share/licenses/timescaledb-2.20.2/APACHE20
  4. /usr/local/share/licenses/timescaledb-2.20.2/TSL
  5. lib/postgresql/timescaledb-2.20.2.so
  6. lib/postgresql/timescaledb-tsl-2.20.2.so
  7. lib/postgresql/timescaledb.so
  8. share/postgresql/extension/timescaledb--2.9.0--2.20.2.sql
  9. share/postgresql/extension/timescaledb--2.9.1--2.20.2.sql
  10. share/postgresql/extension/timescaledb--2.9.2--2.20.2.sql
  11. share/postgresql/extension/timescaledb--2.9.3--2.20.2.sql
  12. share/postgresql/extension/timescaledb--2.10.0--2.20.2.sql
  13. share/postgresql/extension/timescaledb--2.10.1--2.20.2.sql
  14. share/postgresql/extension/timescaledb--2.10.2--2.20.2.sql
  15. share/postgresql/extension/timescaledb--2.10.3--2.20.2.sql
  16. share/postgresql/extension/timescaledb--2.11.0--2.20.2.sql
  17. share/postgresql/extension/timescaledb--2.11.1--2.20.2.sql
  18. share/postgresql/extension/timescaledb--2.11.2--2.20.2.sql
  19. share/postgresql/extension/timescaledb--2.12.0--2.20.2.sql
  20. share/postgresql/extension/timescaledb--2.12.1--2.20.2.sql
  21. share/postgresql/extension/timescaledb--2.12.2--2.20.2.sql
  22. share/postgresql/extension/timescaledb--2.13.0--2.20.2.sql
  23. share/postgresql/extension/timescaledb--2.13.1--2.20.2.sql
  24. share/postgresql/extension/timescaledb--2.14.0--2.20.2.sql
  25. share/postgresql/extension/timescaledb--2.14.1--2.20.2.sql
  26. share/postgresql/extension/timescaledb--2.14.2--2.20.2.sql
  27. share/postgresql/extension/timescaledb--2.15.0--2.20.2.sql
  28. share/postgresql/extension/timescaledb--2.15.1--2.20.2.sql
  29. share/postgresql/extension/timescaledb--2.15.2--2.20.2.sql
  30. share/postgresql/extension/timescaledb--2.15.3--2.20.2.sql
  31. share/postgresql/extension/timescaledb--2.16.0--2.20.2.sql
  32. share/postgresql/extension/timescaledb--2.16.1--2.20.2.sql
  33. share/postgresql/extension/timescaledb--2.17.0--2.20.2.sql
  34. share/postgresql/extension/timescaledb--2.17.1--2.20.2.sql
  35. share/postgresql/extension/timescaledb--2.17.2--2.20.2.sql
  36. share/postgresql/extension/timescaledb--2.18.0--2.20.2.sql
  37. share/postgresql/extension/timescaledb--2.18.1--2.20.2.sql
  38. share/postgresql/extension/timescaledb--2.18.2--2.20.2.sql
  39. share/postgresql/extension/timescaledb--2.19.0--2.20.2.sql
  40. share/postgresql/extension/timescaledb--2.19.1--2.20.2.sql
  41. share/postgresql/extension/timescaledb--2.19.2--2.20.2.sql
  42. share/postgresql/extension/timescaledb--2.19.3--2.20.2.sql
  43. share/postgresql/extension/timescaledb--2.20.0--2.20.2.sql
  44. share/postgresql/extension/timescaledb--2.20.1--2.20.2.sql
  45. share/postgresql/extension/timescaledb--2.20.2.sql
  46. share/postgresql/extension/timescaledb.control
  47. @owner
  48. @group
  49. @mode
Collapse this list.
Dependency lines:
  • timescaledb>0:databases/timescaledb
To install the port:
cd /usr/ports/databases/timescaledb/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/timescaledb
  • pkg install timescaledb
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: timescaledb
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1748898426 SHA256 (timescale-timescaledb-2.20.2_GH0.tar.gz) = 1fea456be213479d03ce76429b5d2b68a3703ba8fe255070ec4f62fbf7b4f556 SIZE (timescale-timescaledb-2.20.2_GH0.tar.gz) = 7790395

Packages (timestamps in pop-ups are UTC):
timescaledb
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest2.19.32.20.12.0.02.19.3--1.7.4_1-
FreeBSD:13:quarterly2.19.02.19.02.10.32.19.0-2.13.02.13.02.13.0
FreeBSD:14:latest2.19.12.20.12.8.12.19.1-2.10.3-2.10.3
FreeBSD:14:quarterly2.19.02.19.0-2.19.0-2.13.02.13.02.13.0
FreeBSD:15:latest2.19.32.19.3n/a2.19.0n/a2.13.12.13.12.14.1
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. cmake : devel/cmake-core
  2. ninja : devel/ninja
  3. postgres : databases/postgresql17-server
Runtime dependencies:
  1. postgres : databases/postgresql17-server
Library dependencies:
  1. libpq.so.5 : databases/postgresql17-client
This port is required by:
for Run
  1. databases/postgresql-promscale

Configuration Options:
===> The following configuration options are available for timescaledb-2.20.2: SSL=on: Build with OpenSSL support TSL=on: Enables TSL licensed code in additon to Apache license code ===> Use 'make config' to modify these settings
Options name:
databases_timescaledb
USES:
cmake compiler:c11 cpe pgsql:15-17 ssl
pkg-message:
For install:
To activate timescaledb on your PostgreSQL server, add 'timescaledb' to shared_preload_libraries in $PGDATA/postgresql.conf. For every database, run CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE; If you are upgrading, restart PostgreSQL server and run ALTER EXTENSION timescaledb UPDATE TO '2.20.2';
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/timescale/timescaledb/tar.gz/2.20.2?dummy=/
Collapse this list.
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2024-05-09
    Affects: databases/timescaledb
    Author: kbowling@FreeBSD.org
    Reason: 
      The Foreign Key storage in hypertables has changed in an incompatible way,
      after runing ALTER EXTENSION, you must run the SQL script here:
      https://github.com/timescale/timescaledb-extras/blob/master/utils/2.15.X-fix_hypertable_foreign_keys.sql
    
      For more details, see
    
      https://github.com/timescale/timescaledb/pull/6797
    
    

Number of commits found: 112 (showing only 12 on this page)

«  1 | 2 

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
0.7.1
10 Dec 2017 19:36:33
Revision:455906Original commit files touched by this commit
riggs search for other commits by this committer
Update to upstream version 0.7.1

PR:		224197
Submitted by:	kbowling (maintainer)
0.7.0
05 Dec 2017 10:05:08
Revision:455571Original commit files touched by this commit
olgeni search for other commits by this committer
databases/timescaledb: use PORTVERSION in pkg-message.in.
0.7.0
23 Nov 2017 10:20:30
Revision:454751Original commit files touched by this commit
pizzamig search for other commits by this committer
databases/timescaledb: Update to 0.7.0

changelog: https://github.com/timescale/timescaledb/releases/tag/0.7.0
Moreover, switches build to CMake and adds support for pgsql10

PR:		223800
Submitted by:	kbowling@freebsd.org (maintainer)
Approved by:	olivier (mentor)
Differential Revision:	https://reviews.freebsd.org/D13191
0.6.0
18 Oct 2017 15:04:16
Revision:452344Original commit files touched by this commit
swills search for other commits by this committer
databases/timescaledb: Update to 0.6.0

PR:		223077
Submitted by:	kbowling
0.5.0
27 Sep 2017 14:37:14
Revision:450752Original commit files touched by this commit
swills search for other commits by this committer
databases/timescaledb: Update to 0.5.0

PR:		222486
Submitted by:	kbowling (maintainer)
0.4.1_1
10 Sep 2017 20:55:39
Revision:449591Original commit files touched by this commit
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
(via Mk/bsd.default-versions.mk and lang/gcc) which has moved from
GCC 5.4 to GCC 6.4 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c++11-lib, c++11-lang,
   c++14-lang, c++0x, c11, or gcc-c++11-lib.

PR:		219275
0.4.1
07 Sep 2017 08:49:10
Revision:449389Original commit files touched by this commit
pizzamig search for other commits by this committer
databases/timescaledb: update to 0.4.1

While I'm here, adding the LICENSE_FILE variable.

PR:		222061
Submitted by:	kbowling@freebsd.org (maintainer)
Approved by:	olivier (mentor)
Differential Revision:	https://reviews.freebsd.org/D12262
0.4.0
27 Aug 2017 09:06:22
Revision:448814Original commit files touched by this commit
tobik search for other commits by this committer
databases/timescaledb: Update to 0.4.0

Changes:	https://github.com/timescale/timescaledb/releases/tag/0.4.0
PR:		221843
Submitted by:	kbowling (maintainer)
0.3.0
14 Aug 2017 17:02:33
Revision:447952Original commit files touched by this commit
joneum search for other commits by this committer
- databases/timescaledb: Update from 0.2.0 to 0.3.0
- pet portlint
- Changelog: https://github.com/timescale/timescaledb/blob/master/CHANGELOG.md

PR:		221315
Submitted by:	kbowling (maintainer)
Approved by:	rene (mentor)
Differential Revision:	https://reviews.freebsd.org/D11989
0.2.0
20 Jul 2017 20:29:03
Revision:446290Original commit files touched by this commit
swills search for other commits by this committer
databases/timescaledb: update to 0.2.0

PR:		220859
Submitted by:	kbowling (maintainer)
0.1.0
05 Jul 2017 06:33:05
Revision:445049Original commit files touched by this commit
swills search for other commits by this committer
databases/timescaledb: needs a C11 compiler

Submitted by:	kbowling (maintainer, via private communications)
0.1.0
30 Jun 2017 21:08:47
Revision:444782Original commit files touched by this commit
swills search for other commits by this committer
databases/timescaledb: create port

An open-source time-series database optimized for fast ingest and complex
queries built on PostgreSQL.

WWW: http://www.timescale.com/

PR:		220347
Submitted by:	kbowling

Number of commits found: 112 (showing only 12 on this page)

«  1 | 2