git: b3ac13fbfd42 - main - databases/pg_cron: New port

The branch main has been updated by tz:

URL: https://cgit.FreeBSD.org/ports/commit/?id=b3ac13fbfd42c69b67bf2736f97b4e67ea624053

commit b3ac13fbfd42c69b67bf2736f97b4e67ea624053
Author:     Torsten Zuehlsdorff <tz@FreeBSD.org>
AuthorDate: 2024-10-28 22:53:44 +0000
Commit:     Torsten Zuehlsdorff <tz@FreeBSD.org>
CommitDate: 2024-10-28 22:53:44 +0000

    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
---
 databases/Makefile          |  1 +
 databases/pg_cron/Makefile  | 22 ++++++++++++++++++++++
 databases/pg_cron/distinfo  |  3 +++
 databases/pg_cron/pkg-descr |  5 +++++
 databases/pg_cron/pkg-plist | 10 ++++++++++
 5 files changed, 41 insertions(+)

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