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

Newsfeed changes

The news feed page[s] were not laid out well. Two pages, disjointed information, hard to figure out how to use the optional parameters...

Thankfully, someone told me.

The new page is ready for your review. Please compare these two:

You may also be interested in the Github issue.
Port details
timescaledb Time-series database built on PostgreSQL
2.19.1 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-04-02 05:34:08
Commit Hash: 1b1b681
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 (54 items)
Collapse this list.
  1. /usr/local/share/licenses/timescaledb-2.19.1/catalog.mk
  2. /usr/local/share/licenses/timescaledb-2.19.1/LICENSE
  3. /usr/local/share/licenses/timescaledb-2.19.1/APACHE20
  4. /usr/local/share/licenses/timescaledb-2.19.1/TSL
  5. lib/postgresql/timescaledb-2.19.1.so
  6. lib/postgresql/timescaledb-tsl-2.19.1.so
  7. lib/postgresql/timescaledb.so
  8. share/postgresql/extension/timescaledb--2.5.0--2.19.1.sql
  9. share/postgresql/extension/timescaledb--2.5.1--2.19.1.sql
  10. share/postgresql/extension/timescaledb--2.5.2--2.19.1.sql
  11. share/postgresql/extension/timescaledb--2.6.0--2.19.1.sql
  12. share/postgresql/extension/timescaledb--2.6.1--2.19.1.sql
  13. share/postgresql/extension/timescaledb--2.7.0--2.19.1.sql
  14. share/postgresql/extension/timescaledb--2.7.1--2.19.1.sql
  15. share/postgresql/extension/timescaledb--2.7.2--2.19.1.sql
  16. share/postgresql/extension/timescaledb--2.8.0--2.19.1.sql
  17. share/postgresql/extension/timescaledb--2.8.1--2.19.1.sql
  18. share/postgresql/extension/timescaledb--2.9.0--2.19.1.sql
  19. share/postgresql/extension/timescaledb--2.9.1--2.19.1.sql
  20. share/postgresql/extension/timescaledb--2.9.2--2.19.1.sql
  21. share/postgresql/extension/timescaledb--2.9.3--2.19.1.sql
  22. share/postgresql/extension/timescaledb--2.10.0--2.19.1.sql
  23. share/postgresql/extension/timescaledb--2.10.1--2.19.1.sql
  24. share/postgresql/extension/timescaledb--2.10.2--2.19.1.sql
  25. share/postgresql/extension/timescaledb--2.10.3--2.19.1.sql
  26. share/postgresql/extension/timescaledb--2.11.0--2.19.1.sql
  27. share/postgresql/extension/timescaledb--2.11.1--2.19.1.sql
  28. share/postgresql/extension/timescaledb--2.11.2--2.19.1.sql
  29. share/postgresql/extension/timescaledb--2.12.0--2.19.1.sql
  30. share/postgresql/extension/timescaledb--2.12.1--2.19.1.sql
  31. share/postgresql/extension/timescaledb--2.12.2--2.19.1.sql
  32. share/postgresql/extension/timescaledb--2.13.0--2.19.1.sql
  33. share/postgresql/extension/timescaledb--2.13.1--2.19.1.sql
  34. share/postgresql/extension/timescaledb--2.14.0--2.19.1.sql
  35. share/postgresql/extension/timescaledb--2.14.1--2.19.1.sql
  36. share/postgresql/extension/timescaledb--2.14.2--2.19.1.sql
  37. share/postgresql/extension/timescaledb--2.15.0--2.19.1.sql
  38. share/postgresql/extension/timescaledb--2.15.1--2.19.1.sql
  39. share/postgresql/extension/timescaledb--2.15.2--2.19.1.sql
  40. share/postgresql/extension/timescaledb--2.15.3--2.19.1.sql
  41. share/postgresql/extension/timescaledb--2.16.0--2.19.1.sql
  42. share/postgresql/extension/timescaledb--2.16.1--2.19.1.sql
  43. share/postgresql/extension/timescaledb--2.17.0--2.19.1.sql
  44. share/postgresql/extension/timescaledb--2.17.1--2.19.1.sql
  45. share/postgresql/extension/timescaledb--2.17.2--2.19.1.sql
  46. share/postgresql/extension/timescaledb--2.18.0--2.19.1.sql
  47. share/postgresql/extension/timescaledb--2.18.1--2.19.1.sql
  48. share/postgresql/extension/timescaledb--2.18.2--2.19.1.sql
  49. share/postgresql/extension/timescaledb--2.19.0--2.19.1.sql
  50. share/postgresql/extension/timescaledb--2.19.1.sql
  51. share/postgresql/extension/timescaledb.control
  52. @owner
  53. @group
  54. @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 = 1743565423 SHA256 (timescale-timescaledb-2.19.1_GH0.tar.gz) = dc4966263b5354f21cd5c36a75d872923f18c9ab148e36d68c61c6fc6203801e SIZE (timescale-timescaledb-2.19.1_GH0.tar.gz) = 7998818

Packages (timestamps in pop-ups are UTC):
timescaledb
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest2.18.12.19.02.0.02.18.1--1.7.4_1-
FreeBSD:13:quarterly2.17.22.17.22.10.32.17.22.17.22.13.02.13.02.13.0
FreeBSD:14:latest2.18.12.19.02.8.12.18.1-2.10.3-2.10.3
FreeBSD:14:quarterly2.17.22.17.2-2.17.22.17.22.13.02.13.02.13.0
FreeBSD:15:latest2.18.12.18.1n/a2.18.1n/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. gettext-runtime>=0.22_1 : devel/gettext-runtime
  4. postgres : databases/postgresql16-server
Runtime dependencies:
  1. postgres : databases/postgresql16-server
Library dependencies:
  1. libintl.so : devel/gettext-runtime
  2. libpq.so.5 : databases/postgresql16-client
This port is required by:
for Run
  1. databases/postgresql-promscale

Configuration Options:
===> The following configuration options are available for timescaledb-2.19.1: 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:
compiler:c11 cmake gettext-runtime cpe pgsql:14-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.19.1';
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/timescale/timescaledb/tar.gz/2.19.1?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: 107 (showing only 7 on this page)

«  1 | 2 

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
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: 107 (showing only 7 on this page)

«  1 | 2