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
I started running short on disk space for the non-production FreshPorts hosts. This time, I have decided to ask for donations. See my recent blog post which points to my Patreon account.
Port details on branch 2025Q4
pg_cron Cron-based job scheduler for PostgreSQL that runs inside the database
1.6.7 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 1.6.7Version of this port present on the latest quarterly branch.
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2025-10-07 21:15:03
Last Update: 2025-10-07 21:14:40
Commit Hash: 791c065
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.7/catalog.mk
  2. /usr/local/share/licenses/pg_cron-1.6.7/LICENSE
  3. /usr/local/share/licenses/pg_cron-1.6.7/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.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
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 = 1759850257 SHA256 (citusdata-pg_cron-v1.6.7_GH0.tar.gz) = d950bc29155f31017567e23a31d268ff672e98276c0e9d062512fb7870351f03 SIZE (citusdata-pg_cron-v1.6.7_GH0.tar.gz) = 56790

No package information for this port in our database
Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link: pkg-fallout
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/postgresql17-server
Runtime dependencies:
  1. postgres : databases/postgresql17-server
There are no ports dependent upon this port

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.7?dummy=/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
1.6.7
07 Oct 2025 21:14:40
commit hash: 791c065c1250332893170256e9e6fcc8d5c6a055commit hash: 791c065c1250332893170256e9e6fcc8d5c6a055commit hash: 791c065c1250332893170256e9e6fcc8d5c6a055commit hash: 791c065c1250332893170256e9e6fcc8d5c6a055 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
databases/pg_cron: Update from 1.6.5 to 1.6.7

  Changes:

    Postgres 18 support
    Stop logging notices and repeating log messages
    Fixes a possible crash for unavailable cron jobs
    Fix build issue FreeBSD 14.3
    Fix type mismatch in dsm_attach() argument by using DatumGetUInt32()
    Fix compile errors on newer versions of GCC

  Taken from:
    https://github.com/citusdata/pg_cron/releases/tag/v1.6.6
    https://github.com/citusdata/pg_cron/releases/tag/v1.6.7

(cherry picked from commit 3c1aef704298a11b806692fd7a7760e75bc81043)

Number of commits found: 1