From nobody Fri Mar 07 06:33:31 2025 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 4Z8GhF0XhXzt4NX; Fri, 07 Mar 2025 06:33:33 +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 4Z8GhD04HJz3Rbk; Fri, 07 Mar 2025 06:33:32 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1741329212; 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=OzALg10R4UHkP8AG9VPVE2zrmXU9u556SQ2sWZIKtFI=; b=ZL57l7zEJtquBFHMEVQORDzmWwyskTTSytJO2aIyLGRwhwsFmUrVE1aDddEkECo52y2fS7 I3O2mS6g/qcqZnKLjWatPuXAw6GVt4sG6JwazuPqXl2YWs5kBU6/DvkHmutdr7vQMaFkgZ K7+3JY++vcUObW0rmhYdTphv85s6YpRvKhE9pHTTWe12O/hc0MLw4FJNk1tCixkNiSDzkw 2U4Nko3bjvJ1Kkt3DxcCXJQiRuUdXX95Yc/9FrsPqUPn694AWpn6HgnBFnZr9PZKzOteOk MjjY1m9TXu1kDkfg4jaXLj/n/N6zgsdqg1/XZAEtcDd/C2MlBRHKDjaLtwTAEg== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1741329212; a=rsa-sha256; cv=none; b=mcQwrqKInGMUl8pVqNjHYf8k4XLHfC4Hf0a6IyTp3dRzMsvEKMF/olieWI/q/H5OtI0HDL iW6phOQVx8H3CorNzowxfPKBvH1mb69NVpdceaQMIt3gMh/UtiVXnf2JLHBfracm/Mxzbm jrFXo0v/OfWguanKjrjPweN3cXE6XksJUCq5x9UDWnEOLJFkKweMUBsjI+uBrWHsfPP9im NK9tH7BUV33wyfVlgBdOtkiKPeblUAk028vF0WZ8cYoiyLm8i6d3I4RmquqQVDegY4aDp/ jcEfYVcl52dvSXXYrNYAWXBasrdZ7wBIPZMwL8PHpguMjAQMAYh4KDDFyEeqZA== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1741329212; 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=OzALg10R4UHkP8AG9VPVE2zrmXU9u556SQ2sWZIKtFI=; b=FLZXUzgOnRWyh88BnRkOmacL1BvpN/B/jbK4RzZdtfEkYvkXG+Thmys/WAow41o0lrs3ZR afDuRG1F09jPoUctRC3IJ5IJUV/0RpU/Pk9UANjcFc94RVDgEYLMGHMrFcjksCZVuVBIKN 0v+fiLOrYb3i89ciP2KatjT3phHXn6xaZ0AYMIRJ3Jho+UHKC8DQ0lVIhbpZHqyZWKBWAs mAywS+gpuZvOhFowrI6+T1C5C3ZaStjWRqDcqa7Ypg7Oz4Gn/YDXX5x0K0SVOarhGJUw2/ AeZBne3/X0rb07ad83fW+OwNG3dsY7cNhzehpqSGBPTBXR7X2FfJ1WYIzsrcHQ== 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 4Z8GhC6TJYz9VK; Fri, 07 Mar 2025 06:33:31 +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 5276XVs7010493; Fri, 7 Mar 2025 06:33:31 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.18.1/8.18.1/Submit) id 5276XV2K010490; Fri, 7 Mar 2025 06:33:31 GMT (envelope-from git) Date: Fri, 7 Mar 2025 06:33:31 GMT Message-Id: <202503070633.5276XV2K010490@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Wen Heping Subject: git: a3381d5c2f0e - main - databases/pg_store_plans: 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: wen X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: a3381d5c2f0e57045e766bef1d46e2f4f403de79 Auto-Submitted: auto-generated The branch main has been updated by wen: URL: https://cgit.FreeBSD.org/ports/commit/?id=a3381d5c2f0e57045e766bef1d46e2f4f403de79 commit a3381d5c2f0e57045e766bef1d46e2f4f403de79 Author: Wen Heping AuthorDate: 2025-03-07 06:31:10 +0000 Commit: Wen Heping CommitDate: 2025-03-07 06:32:38 +0000 databases/pg_store_plans: New port The pg_store_plans module provides a means for tracking execution plan statistics of all SQL statements executed by a server. PR: 283560 Reported by: joseph@2egos.de --- databases/Makefile | 1 + databases/pg_store_plans/Makefile | 21 +++++++++++++++++++++ databases/pg_store_plans/distinfo | 3 +++ databases/pg_store_plans/pkg-descr | 2 ++ databases/pg_store_plans/pkg-plist | 3 +++ 5 files changed, 30 insertions(+) diff --git a/databases/Makefile b/databases/Makefile index 03f32ad50efd..ebe46100e150 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -557,6 +557,7 @@ SUBDIR += pg_repack SUBDIR += pg_similarity SUBDIR += pg_stat_kcache + SUBDIR += pg_store_plans SUBDIR += pg_tileserv SUBDIR += pgaccess SUBDIR += pgadmin3 diff --git a/databases/pg_store_plans/Makefile b/databases/pg_store_plans/Makefile new file mode 100644 index 000000000000..7fcfe0aea4b1 --- /dev/null +++ b/databases/pg_store_plans/Makefile @@ -0,0 +1,21 @@ +PORTNAME= pg_store_plans +DISTVERSION= 1.8 +CATEGORIES= databases + +MAINTAINER= joseph@2egos.de +COMMENT= Enables Postgresql to store query execution plans in the Instance +WWW= https://github.com/ossc-db/pg_store_plans + +LICENSE= Custom +LICENSE_NAME= Custom +LICENSE_FILE= ${WRKSRC}/LICENSE +LICENSE_PERMS= auto-accept + +USE_GITHUB= yes +GH_ACCOUNT= ossc-db + +USES= gmake pgsql:15+ +WANT_PGSQL= server +MAKE_ARGS= USE_PGXS=YES + +.include diff --git a/databases/pg_store_plans/distinfo b/databases/pg_store_plans/distinfo new file mode 100644 index 000000000000..1b26378bf304 --- /dev/null +++ b/databases/pg_store_plans/distinfo @@ -0,0 +1,3 @@ +TIMESTAMP = 1741163719 +SHA256 (ossc-db-pg_store_plans-1.8_GH0.tar.gz) = 1ca9ad08d9840c71634913171576001ea7ea5ca9c69cee2bb3521088d048faa7 +SIZE (ossc-db-pg_store_plans-1.8_GH0.tar.gz) = 86481 diff --git a/databases/pg_store_plans/pkg-descr b/databases/pg_store_plans/pkg-descr new file mode 100644 index 000000000000..2e78df78c569 --- /dev/null +++ b/databases/pg_store_plans/pkg-descr @@ -0,0 +1,2 @@ +The pg_store_plans module provides a means for tracking execution +plan statistics of all SQL statements executed by a server. diff --git a/databases/pg_store_plans/pkg-plist b/databases/pg_store_plans/pkg-plist new file mode 100644 index 000000000000..e17389eb7400 --- /dev/null +++ b/databases/pg_store_plans/pkg-plist @@ -0,0 +1,3 @@ +lib/postgresql/pg_store_plans.so +share/postgresql/extension/pg_store_plans--1.8.sql +share/postgresql/extension/pg_store_plans.control