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
Port details
pg_cron Cron-based job scheduler for PostgreSQL that runs inside the database
1.6.5 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 Package not present on quarterly.This port was created during this quarter. It will be in the next quarterly branch but not the current one.
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2024-10-28 22:57:07
Last Update: 2024-12-16 12:40:23
Commit Hash: ddee4c9
License: PostgreSQL
WWW:
https://github.com/citusdata/pg_cron
Description:
pg_cron is a simple cron-based job scheduler for PostgreSQL (10 or higher) that runs inside the database as an extension. It uses the same syntax as regular cron, but it allows you to schedule PostgreSQL commands directly from the database. You can also use '[1-59] seconds' to schedule a job based on an interval.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (16 items)
Collapse this list.
  1. /usr/local/share/licenses/pg_cron-1.6.5/catalog.mk
  2. /usr/local/share/licenses/pg_cron-1.6.5/LICENSE
  3. /usr/local/share/licenses/pg_cron-1.6.5/PostgreSQL
  4. lib/postgresql/pg_cron.so
  5. share/postgresql/extension/pg_cron--1.0--1.1.sql
  6. share/postgresql/extension/pg_cron--1.0.sql
  7. share/postgresql/extension/pg_cron--1.1--1.2.sql
  8. share/postgresql/extension/pg_cron--1.2--1.3.sql
  9. share/postgresql/extension/pg_cron--1.3--1.4.sql
  10. share/postgresql/extension/pg_cron--1.4--1.4-1.sql
  11. share/postgresql/extension/pg_cron--1.4-1--1.5.sql
  12. share/postgresql/extension/pg_cron--1.5--1.6.sql
  13. share/postgresql/extension/pg_cron.control
  14. @owner
  15. @group
  16. @mode
Collapse this list.
Dependency lines:
  • pg_cron>0:databases/pg_cron
To install the port:
cd /usr/ports/databases/pg_cron/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pg_cron
  • pkg install pg_cron
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: pg_cron
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1734275448 SHA256 (citusdata-pg_cron-v1.6.5_GH0.tar.gz) = 0118080f995fec67e25e58d44c66953e7b2bf5a47bb0602fd2ad147ea646d808 SIZE (citusdata-pg_cron-v1.6.5_GH0.tar.gz) = 55919

Packages (timestamps in pop-ups are UTC):
pg_cron
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest1.6.51.6.5-1.6.51.6.5---
FreeBSD:13:quarterly1.6.51.6.5-1.6.51.6.5---
FreeBSD:14:latest1.6.51.6.5-1.6.51.6.5---
FreeBSD:14:quarterly1.6.51.6.5-1.6.51.6.5---
FreeBSD:15:latest1.6.51.6.5n/a1.6.5n/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.4.1 : devel/gmake
  2. postgres : databases/postgresql16-server
Runtime dependencies:
  1. postgres : databases/postgresql16-server
This port is required by:
for Run
  1. databases/pg_incremental

Configuration Options:
No options to configure
Options name:
databases_pg_cron
USES:
gmake pgsql:10+
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/citusdata/pg_cron/tar.gz/v1.6.5?dummy=/
Collapse this list.

Number of commits found: 2

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
1.6.5
16 Dec 2024 12:40:23
commit hash: ddee4c905dec056beeda4b91d05c29c2c7a39378commit hash: ddee4c905dec056beeda4b91d05c29c2c7a39378commit hash: ddee4c905dec056beeda4b91d05c29c2c7a39378commit hash: ddee4c905dec056beeda4b91d05c29c2c7a39378 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
databases/pg_cron: Upgrade from 1.6.4 to 1.6.5

  Changelog:

    * Fix superuser check before adding job to CronJobHash
    * Fix leap year scheduling problem
    * Fix possible buffer underflow issue in cron parsing
    * Fix compilation warnings

  Taken from:

    https://github.com/citusdata/pg_cron/blob/main/CHANGELOG.md
1.6.4
28 Oct 2024 22:53:44
commit hash: b3ac13fbfd42c69b67bf2736f97b4e67ea624053commit hash: b3ac13fbfd42c69b67bf2736f97b4e67ea624053commit hash: b3ac13fbfd42c69b67bf2736f97b4e67ea624053commit hash: b3ac13fbfd42c69b67bf2736f97b4e67ea624053 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
databases/pg_cron: New port

  pg_cron is a simple cron-based job scheduler for PostgreSQL (10 or higher)
that
  runs inside the database as an extension. It uses the same syntax as regular
  cron, but it allows you to schedule PostgreSQL commands directly from the
  database.

Sponsored by:	Bounce Commerce

Number of commits found: 2