diff options
| author | Torsten Zuehlsdorff <tz@FreeBSD.org> | 2024-10-28 22:53:44 +0000 |
|---|---|---|
| committer | Torsten Zuehlsdorff <tz@FreeBSD.org> | 2024-10-28 22:53:44 +0000 |
| commit | b3ac13fbfd42c69b67bf2736f97b4e67ea624053 (patch) | |
| tree | 34fb3a1af904cfd6a6cef7a7ce1f3f8b1ff07a88 | |
| parent | f4a07165f882cff41521c6ce701d97dcbd9bff80 (diff) | |
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
| -rw-r--r-- | databases/Makefile | 1 | ||||
| -rw-r--r-- | databases/pg_cron/Makefile | 22 | ||||
| -rw-r--r-- | databases/pg_cron/distinfo | 3 | ||||
| -rw-r--r-- | databases/pg_cron/pkg-descr | 5 | ||||
| -rw-r--r-- | databases/pg_cron/pkg-plist | 10 |
5 files changed, 41 insertions, 0 deletions
diff --git a/databases/Makefile b/databases/Makefile index f32a9c522a02..106852ffeeed 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -550,6 +550,7 @@ SUBDIR += pgFormatter SUBDIR += pg_activity SUBDIR += pg_citus + SUBDIR += pg_cron SUBDIR += pg_dirtyread SUBDIR += pg_ed25519 SUBDIR += pg_filedump diff --git a/databases/pg_cron/Makefile b/databases/pg_cron/Makefile new file mode 100644 index 000000000000..ff5ae29ed45c --- /dev/null +++ b/databases/pg_cron/Makefile @@ -0,0 +1,22 @@ +PORTNAME= pg_cron +PORTVERSION= 1.6.4 +DISTVERSIONPREFIX= v +CATEGORIES= databases + +MAINTAINER= tz@FreeBSD.org +COMMENT= Cron-based job scheduler for PostgreSQL that runs inside the database +WWW= https://github.com/citusdata/pg_cron + +LICENSE= PostgreSQL + +USES= gmake pgsql:10+ + +WANT_PGSQL= server + +USE_GITHUB= yes +GH_ACCOUNT= citusdata + +INSTALL_TARGET= install-strip +MAKE_ARGS= INSTALL="${INSTALL} -c" + +.include <bsd.port.mk> diff --git a/databases/pg_cron/distinfo b/databases/pg_cron/distinfo new file mode 100644 index 000000000000..2d17b646cbd2 --- /dev/null +++ b/databases/pg_cron/distinfo @@ -0,0 +1,3 @@ +TIMESTAMP = 1730153844 +SHA256 (citusdata-pg_cron-v1.6.4_GH0.tar.gz) = 52d1850ee7beb85a4cb7185731ef4e5a90d1de216709d8988324b0d02e76af61 +SIZE (citusdata-pg_cron-v1.6.4_GH0.tar.gz) = 55141 diff --git a/databases/pg_cron/pkg-descr b/databases/pg_cron/pkg-descr new file mode 100644 index 000000000000..5e06430c5626 --- /dev/null +++ b/databases/pg_cron/pkg-descr @@ -0,0 +1,5 @@ +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. diff --git a/databases/pg_cron/pkg-plist b/databases/pg_cron/pkg-plist new file mode 100644 index 000000000000..be453454fa3b --- /dev/null +++ b/databases/pg_cron/pkg-plist @@ -0,0 +1,10 @@ +lib/postgresql/pg_cron.so +share/postgresql/extension/pg_cron--1.0--1.1.sql +share/postgresql/extension/pg_cron--1.0.sql +share/postgresql/extension/pg_cron--1.1--1.2.sql +share/postgresql/extension/pg_cron--1.2--1.3.sql +share/postgresql/extension/pg_cron--1.3--1.4.sql +share/postgresql/extension/pg_cron--1.4--1.4-1.sql +share/postgresql/extension/pg_cron--1.4-1--1.5.sql +share/postgresql/extension/pg_cron--1.5--1.6.sql +share/postgresql/extension/pg_cron.control |