From nobody Mon Oct 28 22:55:14 2024 X-Original-To: dev-commits-ports-main@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4Xcpcz0Rj8z5bsyG; Mon, 28 Oct 2024 22:55:15 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R10" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4Xcpcy5v4Nz575p; Mon, 28 Oct 2024 22:55:14 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1730156114; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=H15kZFKXTLnB4kc6/6sPk0UuxohiWGmqkqQXXPrwPcc=; b=plYPipx1Pg5jo4j+a+TrKgheC+yYeBqNbSlVkXm0P4XY2X+lb//ZKGaQ2pgSddYn4ei2UL X4XniMFphe9UCzbPeJQ/WoQdJXTLcxLmiH3Vhdxii/ZzT0hHhWoGA07QbXW/0gMpT25nJb 33XnJtrPd2/95LVZOmcJPk37i/cxk0Pmcju+o+jSz84YYpmT2vtOzDYTLu8eqXqjKHz+TN 3AYpqWleO7Mkv7BuIlhNnMbfyTLUNBFzrNizm9cXGoxObbjV5We0txTJGBwK252SFfdy4B z7ZxBob4VjNp7m7k57ghNBNQz9Rb0wXjq2ItfMpsG2RnJTAOCDlsOD0JdDbB1g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1730156114; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=H15kZFKXTLnB4kc6/6sPk0UuxohiWGmqkqQXXPrwPcc=; b=GYkA+3GpGam4pNFAFm6Z47GykTPA0WxbmyKvSa9skLYJzHj3nPFproAzxix2ZFryJ8i3/U NVVGZDMphTI0XmswV0vkKRjc3iiD9Wv0QBX+BMPrK8czSG/nv8btpO3iUs7q11QgyCZx0Q rSYT6iPDa3co5RgXAn9CwKFF/SJc/gKwWVcSk1aPuqgzey6Kay0kEi/JchZRCe4xUu6L8o i6EJ2L1S7VEHwItXrMjLTBixMa/fiSh2GYq+K+982kq2aSX3UhxwI06aTXP63AHbzCOCs4 8xnwEmkCjWo/LY+IaaDtqrA9GLCWqDI15zxVYDIgLeAOFvrQ4jSPr3urilWTSg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1730156114; a=rsa-sha256; cv=none; b=MEGo/JgHKiyyHvqy+JFSckjg9DPiCuNuODX4QvQex8Lw9ODML60xIDcbOqHrdET5OYEBUn AmhHIYLxrQia20sch8BOjXcagUhO+WOYPGLD6kbk8hm50cvWlcHYMJBGd36P5tya+2o/W/ uFwaWkifEpMlLIlt8zu/tJ9fitpWfuKmxlXWPCE0sqSJ+x30KEDyOAACaAUy4dYnte33vC xYFCSJqUHaCcjpJrDIek75CFKtsYH12X1DaeE6xhhFq2+HfyUcoVXbcY84Hamc1vs6vs6x j4eISqxVwwiHlEeeiCaoQ+WN6CWQd1FXLDs9uDzXnyXTtTI/VAgR4fWoBSDfrw== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4Xcpcy5TDQzyWy; Mon, 28 Oct 2024 22:55:14 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.18.1/8.18.1) with ESMTP id 49SMtEE8005048; Mon, 28 Oct 2024 22:55:14 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.18.1/8.18.1/Submit) id 49SMtE7t005045; Mon, 28 Oct 2024 22:55:14 GMT (envelope-from git) Date: Mon, 28 Oct 2024 22:55:14 GMT Message-Id: <202410282255.49SMtE7t005045@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Torsten Zuehlsdorff Subject: git: b3ac13fbfd42 - main - databases/pg_cron: New port List-Id: Commits to the main branch of the FreeBSD ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-main List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: dev-commits-ports-main@freebsd.org Sender: owner-dev-commits-ports-main@FreeBSD.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: tz X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: b3ac13fbfd42c69b67bf2736f97b4e67ea624053 Auto-Submitted: auto-generated The branch main has been updated by tz: URL: https://cgit.FreeBSD.org/ports/commit/?id=b3ac13fbfd42c69b67bf2736f97b4e67ea624053 commit b3ac13fbfd42c69b67bf2736f97b4e67ea624053 Author: Torsten Zuehlsdorff AuthorDate: 2024-10-28 22:53:44 +0000 Commit: Torsten Zuehlsdorff 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 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