git: a3381d5c2f0e - main - databases/pg_store_plans: New port

The branch main has been updated by wen:

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

commit a3381d5c2f0e57045e766bef1d46e2f4f403de79
Author:     Wen Heping <wen@FreeBSD.org>
AuthorDate: 2025-03-07 06:31:10 +0000
Commit:     Wen Heping <wen@FreeBSD.org>
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 <bsd.port.mk>
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