As 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 photos
All times are UTCnotbug
Remember
I remember
Menu ☰ Menu
Searches without login should now work. You must get asked to click a button.
Some translations wanted please.
New RSS 2.0 and Atom feeds are here. The old /backend/ feeds still work, but will be redirected later, so please update your subscriptions. Details.
Port details
pg_cron Cron-based job scheduler for PostgreSQL that runs inside the database
1.6.7 databases Σ=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. upstream: v1.6.8A newer version was found upstream by portscout, first on 2026-09-09.
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2024-10-28 22:57:07
Last Update: 2025-10-07 21:14:13
Commit Hash: 3c1aef7
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
Packages (timestamps in pop-ups are UTC): #
pg_cron
ABIaarch64amd64armv6armv7i386
FreeBSD:14:latest1.6.71.6.7-1.6.51.6.7
FreeBSD:14:quarterly1.6.71.6.7-1.6.51.6.7
FreeBSD:15:latest1.6.71.6.7n/a1.6.5n/a
FreeBSD:15:quarterly1.6.71.6.7n/a-n/a
FreeBSD:16:latest1.6.71.6.7n/a-n/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/postgresql17-server
Runtime dependencies: #
  1. postgres : databases/postgresql17-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+
pkg-message: #
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: 3 #

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:13
commit hash: 3c1aef704298a11b806692fd7a7760e75bc81043commit hash: 3c1aef704298a11b806692fd7a7760e75bc81043commit hash: 3c1aef704298a11b806692fd7a7760e75bc81043commit hash: 3c1aef704298a11b806692fd7a7760e75bc81043 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
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: 3

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
Security Policy
Privacy
Blog
Contact

Latest Vulnerabilities
apache24Nov 11
conduitNov 11
gitlabNov 11
immichNov 11
immich-cliNov 11
libresslNov 11
libressl-develNov 11
mbedtls4Nov 11
sqlite3*Nov 11
chromiumNov 10
gitNov 10
git-cvsNov 10
git-guiNov 10
git-p4Nov 10
git-svnNov 10

79 vulnerabilities affecting 679 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2026-11-11 22:16:55 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 35557
Broken 62
Deprecated 354
Ignore 184
Forbidden 0
Restricted 1
No CDROM 1
Vulnerable 52
Expired 11
Set to expire 273
Interactive 0
new 24 hours 28
new 48 hours40
new 7 days192
new fortnight264
new month395
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2026 Dan Langille. All rights reserved.