notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Ukraine
Some details on the 2023-01-16 website outage.
We just rebooted with several updates: * new HMTLify code * no port maintainer is now highly visible (e.g. https://freshports.org/security/sssd/) * fixed search logic error when using plain/ text details at https://github.com/FreshPorts/freshports/releases/tag/2.2.34
Port details
postgresql-promscale Tables, types and functions supporting Promscale
0.8.0 databases on this many watch lists=0 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 Version of this port present on the latest quarterly branch.
Maintainer: feld@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2022-11-02 21:51:06
Last Update: 2023-01-25 17:00:46
Commit Hash: 880ce97
License: PostgreSQL
Description:
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port
pkg-plist: as obtained via: make generate-plist
Expand this list (63 items)
Collapse this list.
  1. /usr/local/share/licenses/postgresql13-promscale-0.8.0/catalog.mk
  2. /usr/local/share/licenses/postgresql13-promscale-0.8.0/LICENSE
  3. /usr/local/share/licenses/postgresql13-promscale-0.8.0/PostgreSQL
  4. lib/postgresql/promscale-0.8.0.so
  5. share/postgresql/extension/promscale.control
  6. share/postgresql/extension/promscale--0.0.0.sql
  7. share/postgresql/extension/promscale--0.0.0--0.5.0.sql
  8. share/postgresql/extension/promscale--0.0.0--0.5.1.sql
  9. share/postgresql/extension/promscale--0.0.0--0.5.2.sql
  10. share/postgresql/extension/promscale--0.0.0--0.5.4.sql
  11. share/postgresql/extension/promscale--0.0.0--0.6.0.sql
  12. share/postgresql/extension/promscale--0.0.0--0.7.0.sql
  13. share/postgresql/extension/promscale--0.0.0--0.8.0.sql
  14. share/postgresql/extension/promscale--0.1.sql
  15. share/postgresql/extension/promscale--0.1--0.1.1.sql
  16. share/postgresql/extension/promscale--0.1.1.sql
  17. share/postgresql/extension/promscale--0.1.1--0.1.2.sql
  18. share/postgresql/extension/promscale--0.1.2.sql
  19. share/postgresql/extension/promscale--0.1.2--0.1.3-beta.sql
  20. share/postgresql/extension/promscale--0.1.3-beta.sql
  21. share/postgresql/extension/promscale--0.1.3-beta--0.2.0.sql
  22. share/postgresql/extension/promscale--0.2.0.sql
  23. share/postgresql/extension/promscale--0.2.0--0.3.0.sql
  24. share/postgresql/extension/promscale--0.3.0.sql
  25. share/postgresql/extension/promscale--0.3.0--0.3.1.sql
  26. share/postgresql/extension/promscale--0.3.1.sql
  27. share/postgresql/extension/promscale--0.3.1--0.3.2.sql
  28. share/postgresql/extension/promscale--0.3.2.sql
  29. share/postgresql/extension/promscale--0.5.0.sql
  30. share/postgresql/extension/promscale--0.5.0--0.5.1.sql
  31. share/postgresql/extension/promscale--0.5.0--0.5.2.sql
  32. share/postgresql/extension/promscale--0.5.0--0.5.4.sql
  33. share/postgresql/extension/promscale--0.5.0--0.6.0.sql
  34. share/postgresql/extension/promscale--0.5.0--0.7.0.sql
  35. share/postgresql/extension/promscale--0.5.0--0.8.0.sql
  36. share/postgresql/extension/promscale--0.5.1.sql
  37. share/postgresql/extension/promscale--0.5.1--0.5.2.sql
  38. share/postgresql/extension/promscale--0.5.1--0.5.4.sql
  39. share/postgresql/extension/promscale--0.5.1--0.6.0.sql
  40. share/postgresql/extension/promscale--0.5.1--0.7.0.sql
  41. share/postgresql/extension/promscale--0.5.1--0.8.0.sql
  42. share/postgresql/extension/promscale--0.5.2.sql
  43. share/postgresql/extension/promscale--0.5.2--0.5.4.sql
  44. share/postgresql/extension/promscale--0.5.2--0.6.0.sql
  45. share/postgresql/extension/promscale--0.5.2--0.7.0.sql
  46. share/postgresql/extension/promscale--0.5.2--0.8.0.sql
  47. share/postgresql/extension/promscale--0.5.3--0.5.4.sql
  48. share/postgresql/extension/promscale--0.5.3--0.6.0.sql
  49. share/postgresql/extension/promscale--0.5.3--0.7.0.sql
  50. share/postgresql/extension/promscale--0.5.3--0.8.0.sql
  51. share/postgresql/extension/promscale--0.5.4.sql
  52. share/postgresql/extension/promscale--0.5.4--0.6.0.sql
  53. share/postgresql/extension/promscale--0.5.4--0.7.0.sql
  54. share/postgresql/extension/promscale--0.5.4--0.8.0.sql
  55. share/postgresql/extension/promscale--0.6.0.sql
  56. share/postgresql/extension/promscale--0.6.0--0.7.0.sql
  57. share/postgresql/extension/promscale--0.6.0--0.8.0.sql
  58. share/postgresql/extension/promscale--0.7.0.sql
  59. share/postgresql/extension/promscale--0.7.0--0.8.0.sql
  60. share/postgresql/extension/promscale--0.8.0.sql
  61. @owner
  62. @group
  63. @mode
Collapse this list.
Dependency lines:
  • postgresql13-promscale>0:databases/postgresql-promscale
To install the port:
cd /usr/ports/databases/postgresql-promscale/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/postgresql-promscale
  • pkg install postgresql13-promscale
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: postgresql13-promscale
Flavors: there is no flavor information for this port.
ONLY_FOR_ARCHS: aarch64 amd64
distinfo:

Packages (timestamps in pop-ups are UTC):
postgresql13-promscale
ABIlatestquarterly
FreeBSD:11:aarch64pkg-falloutpkg-fallout
FreeBSD:11:amd64pkg-falloutpkg-fallout
FreeBSD:11:armv6pkg-falloutpkg-fallout
FreeBSD:11:i386pkg-falloutpkg-fallout
FreeBSD:11:mipspkg-falloutpkg-fallout
FreeBSD:11:mips64pkg-falloutpkg-fallout
FreeBSD:12:aarch64pkg-falloutpkg-fallout
FreeBSD:12:amd640.8.0pkg-fallout
FreeBSD:12:armv6pkg-falloutpkg-fallout
FreeBSD:12:armv7pkg-falloutpkg-fallout
FreeBSD:12:i386pkg-falloutpkg-fallout
FreeBSD:12:mipspkg-falloutpkg-fallout
FreeBSD:12:mips64pkg-falloutpkg-fallout
FreeBSD:12:powerpc64pkg-falloutpkg-fallout
FreeBSD:13:aarch64pkg-falloutpkg-fallout
FreeBSD:13:amd640.8.0pkg-fallout
FreeBSD:13:armv6pkg-falloutpkg-fallout
FreeBSD:13:armv7pkg-falloutpkg-fallout
FreeBSD:13:i386pkg-falloutpkg-fallout
FreeBSD:13:mipspkg-falloutpkg-fallout
FreeBSD:13:mips64pkg-falloutpkg-fallout
FreeBSD:13:powerpc64pkg-falloutpkg-fallout
FreeBSD:13:riscv64pkg-falloutpkg-fallout
FreeBSD:14:aarch64pkg-falloutpkg-fallout
FreeBSD:14:amd640.8.0pkg-fallout
FreeBSD:14:armv6pkg-falloutpkg-fallout
FreeBSD:14:armv7pkg-falloutpkg-fallout
FreeBSD:14:i386pkg-falloutpkg-fallout
FreeBSD:14:mipspkg-falloutpkg-fallout
FreeBSD:14:mips64pkg-falloutpkg-fallout
FreeBSD:14:powerpc64pkg-falloutpkg-fallout
FreeBSD:14:riscv64pkg-falloutpkg-fallout
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. bash>0 : shells/bash
  2. rust>=1.66.0 : lang/rust
  3. pkgconf>=1.3.0_1 : devel/pkgconf
  4. gmake>=4.3 : devel/gmake
  5. postgres : databases/postgresql13-server
Runtime dependencies:
  1. timescaledb>=2.9.1 : databases/timescaledb
  2. postgres : databases/postgresql13-server
There are no ports dependent upon this port

Configuration Options:
Options name:
USES:
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/timescale/promscale_extension/tar.gz/0.8.0?dummy=/
Collapse this list.
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2021-10-24
    Affects: users of databases/postgresql* and other software using PostgreSQL to run
    Author: kbowling@FreeBSD.org
    Reason: 
      The default version of PostgreSQL has been switched from 12 to 13.
      The upgrade procedure can use up twice the space the databases
      currently needs. If you have a big amount of stored data take a
      closer look at the manpage of pg_upgrade for avoidance and/or
      speedup of the upgrade.
    
      The upgrade instructions consider a basic usage and do not match
      complex scenarios like replication, sharding, or similar.
    
      Upgrade instructions:
    
      First stop your PostgreSQL, create PostgreSQL-binaries and backup your data.
      If you have another Version of PostgreSQL installed, for example 12.8, your
      files are named according to this.
    
      # service postgresql stop
      # pkg create postgresql12-server postgresql12-contrib
      # mkdir /tmp/pg-upgrade
      # tar xf postgresql12-server-12.8.pkg -C /tmp/pg-upgrade
      # tar xf postgresql12-contrib-12.8.pkg -C /tmp/pg-upgrade
      # pkg delete -f databases/postgresql12-server databases/postgresql12-contrib databases/postgresql12-client
    
      Now update PostgreSQL:
    
        pkg user:
        # pkg install databases/postgresql13-server databases/postgresql13-contrib
        # pkg upgrade
    
        Portmaster users:
        # portmaster databases/postgresql13-server databases/postgresql13-contrib
        # portmaster -a
    
        Portupgrade users:
        # portinstall databases/postgresql13-server databases/postgresql13-contrib
        # portupgrade -a
    
      After installing the new PostgreSQL version you need to convert
      all your databases to new version:
    
      # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data13 -U postgres"
      # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data12/ -B /usr/local/bin/ -D /var/db/postgres/data13/ -U postgres "
    
      Now the migration is finished. You can start PostgreSQL again with:
    
      # service postgresql start
    
      ATTENTION:
      1) The default user changed from "pgsql" to "postgres" in 11. The migration steps above now assume
         the "postgres" database user and FreeBSD user.
      2) See the updating entry 20190829 if you are updating from a release prior to 11.
      3) If you use non-default initdb options, you have to adjust the initdb-command accordingly
    
    
Expand this list (4 items)
  • 2020-09-21
    Affects: users of databases/postgresql* and other software using PostgreSQL to run
    Author: kbowling@FreeBSD.org
    Reason: 
      The default version of PostgreSQL has been switched from 11 to 12.
      The upgrade procedure can use up twice the space the databases
      currently needs. If you have a big amount of stored data take a
      closer look at the manpage of pg_upgrade for avoidance and/or
      speedup of the upgrade.
    
      The upgrade instructions consider a basic usage and do not match
      complex scenarios like replication, sharding, or similar.
    
      Upgrade instructions:
    
      First stop your PostgreSQL, create PostgreSQL-binaries and backup your data.
      If you have another Version of PostgreSQL installed, for example 11.9, your
      files are named according to this.
    
      # service postgresql stop
      # pkg create postgresql11-server postgresql11-contrib
      # mkdir /tmp/pg-upgrade
      # tar xf postgresql11-server-11.9.txz -C /tmp/pg-upgrade
      # tar xf postgresql11-contrib-11.9.txz -C /tmp/pg-upgrade
      # pkg delete -f databases/postgresql11-server databases/postgresql11-contrib databases/postgresql11-client
    
      Now update PostgreSQL:
    
        pkg user:
        # pkg install databases/postgresql12-server databases/postgresql12-contrib
        # pkg upgrade
    
        Portmaster users:
        # portmaster databases/postgresql12-server databases/postgresql12-contrib
        # portmaster -a
    
        Portupgrade users:
        # portinstall databases/postgresql12-server databases/postgresql12-contrib
        # portupgrade -a
    
      After installing the new PostgreSQL version you need to convert
      all your databases to new version:
    
      # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data12 -U postgres"
      # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data11/ -B /usr/local/bin/ -D /var/db/postgres/data12/ -U postgres "
    
      Now the migration is finished. You can start PostgreSQL again with:
    
      # service postgresql start
    
      ATTENTION:
      1) The default user changed from "pgsql" to "postgres" in 11. The migration steps above now assume
         the "postgres" database user and FreeBSD user.
      2) See the updating entry 20190829 if you are updating from a release prior to 11.
      3) If you use non-default initdb options, you have to adjust the initdb-command accordingly
    
    
  • 2019-08-29
    Affects: users of databases/postgresql* and other software using PostgreSQL to run
    Author: tz@FreeBSD.org
    Reason: 
      The default version of PostgreSQL has been switched from 9.5 to 11.
      The upgrade procedure can use up twice the space the databases
      currently needs. If you have a big amount of stored data take a
      closer look at the manpage of pg_upgrade for avoidance and/or
      speedup of the upgrade.
    
      The upgrade instructions consider a basic usage and do not match
      complex scenarios like replication, sharding, or similar.
    
      Upgrade instructions:
    
      First stop your PostgreSQL, create PostgreSQL-binaries and backup your data.
      If you have another Version of PostgreSQL installed, for example 9.5.19, your
      files are named according to this.
    
      # service postgresql stop
      # pkg create postgresql95-server postgresql95-contrib
      # mkdir /tmp/pg-upgrade
      # tar xf postgresql95-server-9.5.19.txz -C /tmp/pg-upgrade
      # tar xf postgresql95-contrib-9.5.19.txz -C /tmp/pg-upgrade
      # pkg delete -f databases/postgresql95-server databases/postgresql95-contrib databases/postgresql95-client
    
      Now update PostgreSQL:
    
        pkg user:
        # pkg install databases/postgresql11-server databases/postgresql11-contrib
        # pkg upgrade
    
        Portmaster users:
        # portmaster databases/postgresql11-server databases/postgresql11-contrib
        # portmaster -a
    
        Portupgrade users:
        # portinstall databases/postgresql11-server databases/postgresql11-contrib
        # portupgrade -a
    
      After installing the new PostgreSQL version you need to convert
      all your databases to new version:
    
      # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data11 -U pgsql"
      # chown -R postgres /usr/local/pgsql/data/
      # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /usr/local/pgsql/data/ -B /usr/local/bin/ -D /var/db/postgres/data11/ -U pgsql "
    
      Now the migration is finished. You can start PostgreSQL again with:
    
      # service postgresql start
    
      ATTENTION:
      1) The default user changed from "pgsql" to "postgres". The migration steps above preserve
         the "pgsql" database user while the database daemon is now executed as the "postgres" FreeBSD user.
      2) The default data dir changed from "/usr/local/pgsql/data/" to "/var/db/postgres/data11/"
      3) If you use non-default initdb options, you have to adjust the initdb-command accordingly
    
    
  • 2017-06-22
    Affects: users of databases/postgresql* and other software using PostgreSQL to run
    Author: tz@FreeBSD.org
    Reason: 
      The default version of PostgreSQL has been switched from 9.3 to 9.5.
      The upgrade procedure can use up twice the space the databases
      currently needs. If you have a big amount of stored data take a
      closer look at the manpage of pg_upgrade for avoidance and/or
      speedup of the upgrade.
    
      The upgrade instructions consider a basic usage and do not match
      complex scenarios like replication, sharding, or similar.
    
      Upgrade instructions:
    
      First stop your PostgreSQL, create PostgreSQL-binaries and backup your data.
      If you have another Version of PostgreSQL installed, for example 9.3.12, your
      files are named according to this.
    
      # service postgresql stop
      # pkg create postgresql93-server postgresql93-contrib
      # mkdir /tmp/pg-upgrade
      # tar xf postgresql93-server-9.3.17.txz -C /tmp/pg-upgrade
      # tar xf postgresql93-contrib-9.3.17.txz -C /tmp/pg-upgrade
      # mv /usr/local/pgsql/data /usr/local/pgsql/data93
      # pkg delete -f databases/postgresql93-server databases/postgresql93-contrib databases/postgresql93-client
    
      Now update PostgreSQL:
    
        pkg user:
        # pkg install databases/postgresql95-server databases/postgresql95-contrib
        # pkg upgrade
    
        Portmaster users:
        # portmaster databases/postgresql95-server databases/postgresql95-contrib
        # portmaster -a
    
        Portupgrade users:
        # portinstall databases/postgresql95-server databases/postgresql95-contrib
        # portupgrade -a
    
      After installing the new PostgreSQL version you need to convert
      all your databases to new version:
    
      # service postgresql initdb
      # su -l pgsql -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /usr/local/pgsql/data93/ -B /usr/local/bin/ -D /usr/local/pgsql/data/"
    
      Now the migration is finished. You can start PostgreSQL again with:
    
      # service postgresql start
    
    
  • 2014-02-11
    Affects: users of lang/php* databases/postgresql* databases/mysql* www/apache*
    Author: mat@FreeBSD.org
    Reason: 
      The default versions of lang/php*, databases/postgresql*,
      databases/mysql* and www/apache* have been changed to support the
      new DEFAULT_VERSIONS variable.
    
      DEFAULT_APACHE_VER, DEFAULT_MYSQL_VER, DEFAULT_PGSQL_VER,
      DEFAULT_FPC_VER and DEFAULT_PHP_VER are now deprecated.  You can use
      the new DEFAULT_VERSIONS variable like this:
    
      DEFAULT_VERSIONS=php=5.5 mysql=5.6 apache=2.4
    
    
  • Collapse this list.

Number of commits found: 7

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
0.8.0
25 Jan 2023 17:00:46
commit hash:880ce9772bb0dee312c984d2d428f7bc51bf22ddcommit hash:880ce9772bb0dee312c984d2d428f7bc51bf22ddcommit hash:880ce9772bb0dee312c984d2d428f7bc51bf22ddcommit hash:880ce9772bb0dee312c984d2d428f7bc51bf22dd files touched by this commit
Mark Felder (feld) search for other commits by this committer
databases/postgresql-promscale: Update to 0.8.0

Changelog:	https://github.com/timescale/promscale_extension/releases/tag/0.8.0

PR:	267851
0.7.0_3
05 Jan 2023 23:25:20
commit hash:abdf96d348b9d60575e7a130691108853f881080commit hash:abdf96d348b9d60575e7a130691108853f881080commit hash:abdf96d348b9d60575e7a130691108853f881080commit hash:abdf96d348b9d60575e7a130691108853f881080 files touched by this commit
Daniel Engberg (diizzy) search for other commits by this committer
databases/postgresql-promscale: Mark as BROKEN

Fails to build using Rust 1.65.0 or newer

PR:		267851
Reported by:	Jony Hudson <bsd@j-star.org>
0.7.0_3
20 Dec 2022 17:37:15
commit hash:ba14e01a5249ee9d2f51183587dde36067be000fcommit hash:ba14e01a5249ee9d2f51183587dde36067be000fcommit hash:ba14e01a5249ee9d2f51183587dde36067be000fcommit hash:ba14e01a5249ee9d2f51183587dde36067be000f files touched by this commit
Mikael Urankar (mikael) search for other commits by this committer
lang/rust: Bump revisions after 1.66.0

PR:		268415
0.7.0_2
03 Dec 2022 18:43:44
commit hash:bb6b6ce9ef2e9df76f92896a9c5458176c42a586commit hash:bb6b6ce9ef2e9df76f92896a9c5458176c42a586commit hash:bb6b6ce9ef2e9df76f92896a9c5458176c42a586commit hash:bb6b6ce9ef2e9df76f92896a9c5458176c42a586 files touched by this commit
Mark Felder (feld) search for other commits by this committer
databases/postgresql-promscale: portlint fixes and defined ONLY_FOR_ARCHES
0.7.0_2
17 Nov 2022 07:06:14
commit hash:9bf6a9996323c016eb295bd6190b0e47ad76fdf4commit hash:9bf6a9996323c016eb295bd6190b0e47ad76fdf4commit hash:9bf6a9996323c016eb295bd6190b0e47ad76fdf4commit hash:9bf6a9996323c016eb295bd6190b0e47ad76fdf4 files touched by this commit
Mikael Urankar (mikael) search for other commits by this committer
lang/rust: Bump revisions after 1.65.0

PR:		267622
0.7.0_1
08 Nov 2022 15:47:47
commit hash:2735159edc4ead9807d366b856ef26e546df849bcommit hash:2735159edc4ead9807d366b856ef26e546df849bcommit hash:2735159edc4ead9807d366b856ef26e546df849bcommit hash:2735159edc4ead9807d366b856ef26e546df849b files touched by this commit
Mark Felder (feld) search for other commits by this committer
databases/postgresql-promscale: Fix build with NLS

PR:	267550
0.7.0
02 Nov 2022 21:48:47
commit hash:47853d04d0c197e38a041fd9740a4946fbb86c32commit hash:47853d04d0c197e38a041fd9740a4946fbb86c32commit hash:47853d04d0c197e38a041fd9740a4946fbb86c32commit hash:47853d04d0c197e38a041fd9740a4946fbb86c32 files touched by this commit
Mark Felder (feld) search for other commits by this committer
databases/postgresql-promscale: add new port

The PostgreSQL Promscale extension provides the required database capability
and PL/pgsql code to support Promscale 0.11.0+

Promscale is API-compatible with Prometheus and stores your metrics in
PostgreSQL
in a highly performant storage format with the help of TimescaleDB.

Number of commits found: 7