From nobody Thu Aug 17 18:34:25 2023 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 4RRYZ96brqz4mWWR; Thu, 17 Aug 2023 18:34:25 +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 "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4RRYZ963Tvz3Sl2; Thu, 17 Aug 2023 18:34:25 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1692297265; 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=rEPSZK+FhO2xx5czU6BBjvZ8xQlF4diH8DNSPrj6MDo=; b=XgOb6sQZVfNpxCtc13nTNgJYAVWvtswA1p51nTmN/YDWoHKzLJ9KyjH8bSUSATQtnmNx13 3EdeRQ4swCVHTGDEP3nw9BSPT4MRUGpwQxVG0GPOneJn/sMK7hd3P8jNr3YmkVvuIpQKEN N37X9Qb3/zfc3YqWnzJOlWTloWROSLevvxULu/Dwp+DhSc1j5HTEAOyL1am3WVdU7X0+oH PeUDZkjWi3BtxZULX76eeScYcHCGGrjndSi3lLIOKDXqP2M1i/wlwQzSchiYsdV2l3UpPU +m6X9458aWCXt3Z6PeMnmH8XteTr09MDrs54EaEXoZEq5CKgjThmrg1AOhVqZw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1692297265; 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=rEPSZK+FhO2xx5czU6BBjvZ8xQlF4diH8DNSPrj6MDo=; b=given8R5y0lil7XG4o9z6LNaObPHA2ksKIUyncutUdQQkieDBQFTn/BaR/QBygfuL5C91y 8/HK20yNHpCvSChFUr5zvTl2kqL+y6acpfrMR6vPdkCgIyLx9W8Irau99AiUB81EkiFVzJ hgkdnUQwynlXC6v8Nrlhsqiw6ZQDGmrjXLd4tCfZaO+j2SD6VqSo3zaGcMtvtvmbKPsPIc mhqydEM48XxOqint0az6im1fPESRyt0jRnaJRT9d7xL/plJJiDMACUgO3q/XOzmYC4UYke Gd4A0h5qTdBf/NGhsWqRMV082ASAAv27oOArCYU1LDBdrXD5qu8VFe3udZnQwQ== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1692297265; a=rsa-sha256; cv=none; b=xlWGF0SR3vS/E8tcut9g4XW98OktX7I8FR45pWGbTaH4lLmPU2hNI+2HVgkzoOtEbBKLON V0KX44Tnc3OXjCgnHrjrszpM2FruzKXIfo1l2VqasnbJkme8b7LRhESDdc0Y0UCii/vlR5 08k5P8YrPnt+exY9YiBKhMUv3ACbQflgwJ+qSxBmqMychkjuOundgh3Tmll+7fI4WFN10m c8AuSeub9KRfjFZLnFlS7ARObMrSHSYLNSRkMe6BbEiDY2rQvwL3zAY4QtdLFMjczOvEoq 0FalXiMbc3WxClA3HBv3Pm9PxKvqekhetLxS6wCPFxDdnkIFBUqT2cfS5a9+vg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none 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 4RRYZ955nxzl9h; Thu, 17 Aug 2023 18:34:25 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.17.1/8.17.1) with ESMTP id 37HIYPrx046423; Thu, 17 Aug 2023 18:34:25 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.17.1/8.17.1/Submit) id 37HIYPDV046419; Thu, 17 Aug 2023 18:34:25 GMT (envelope-from git) Date: Thu, 17 Aug 2023 18:34:25 GMT Message-Id: <202308171834.37HIYPDV046419@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Muhammad Moinur Rahman Subject: git: 4198c9636207 - main - databases/pgpool-II-44: 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: Sender: owner-dev-commits-ports-main@freebsd.org X-BeenThere: dev-commits-ports-main@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: bofh X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 4198c9636207dd2ddb81db7e1106a4e766583dd1 Auto-Submitted: auto-generated The branch main has been updated by bofh: URL: https://cgit.FreeBSD.org/ports/commit/?id=4198c9636207dd2ddb81db7e1106a4e766583dd1 commit 4198c9636207dd2ddb81db7e1106a4e766583dd1 Author: Muhammad Moinur Rahman AuthorDate: 2023-08-17 04:41:11 +0000 Commit: Muhammad Moinur Rahman CommitDate: 2023-08-17 18:34:18 +0000 databases/pgpool-II-44: New port pgpool is a connection pool server for PostgreSQL. pgpool runs between PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL client can connect to pgpool as if it were a standard PostgreSQL server. pgpool caches the connection to PostgreSQL server to reduce the overhead to establish the connection to it. --- databases/Makefile | 1 + databases/pgpool-II-44/Makefile | 50 ++++++++++++++++++++++++++++++++++ databases/pgpool-II-44/distinfo | 3 ++ databases/pgpool-II-44/files/pgpool.in | 48 ++++++++++++++++++++++++++++++++ databases/pgpool-II-44/pkg-descr | 6 ++++ databases/pgpool-II-44/pkg-message | 15 ++++++++++ databases/pgpool-II-44/pkg-plist | 43 +++++++++++++++++++++++++++++ 7 files changed, 166 insertions(+) diff --git a/databases/Makefile b/databases/Makefile index e3a82f4c95f6..c2fbd027c490 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -581,6 +581,7 @@ SUBDIR += pgpool-II-41 SUBDIR += pgpool-II-42 SUBDIR += pgpool-II-43 + SUBDIR += pgpool-II-44 SUBDIR += pgreplay SUBDIR += pgroonga SUBDIR += pgrouting diff --git a/databases/pgpool-II-44/Makefile b/databases/pgpool-II-44/Makefile new file mode 100644 index 000000000000..75452190e1c6 --- /dev/null +++ b/databases/pgpool-II-44/Makefile @@ -0,0 +1,50 @@ +PORTNAME= pgpool-II +PORTVERSION= 4.4.4 +CATEGORIES= databases +MASTER_SITES= http://www.pgpool.net/mediawiki/images/ +PKGNAMESUFFIX= -44 + +MAINTAINER= bofh@FreeBSD.org +COMMENT= Connection pool server for PostgreSQL (4.4.X branch) +WWW= https://pgpool.net/ + +LICENSE= MIT +LICENSE_FILE= ${WRKSRC}/COPYING + +USES= gmake libtool pgsql:11+ +USE_LDCONFIG= yes +USE_RC_SUBR= pgpool + +GNU_CONFIGURE= yes + +CONFLICTS_INSTALL= pgpool-II-[0-9][0-9] pgpool-II[0-9][0-9] # etc/escalation.sh.sample etc/failover.sh.sample etc/pcp.conf.sample + +PORTSCOUT= limit:^4.4.[0-9]* + +PORTDOCS= * + +OPTIONS_DEFINE= DOCS MEMCACHED PAM SSL +OPTIONS_DEFAULT= SSL + +MEMCACHED_DESC= Use memcached for in memory query cache +PAM_DESC= Build with PAM support +SSL_DESC= Build with OpenSSL support + +MEMCACHED_LIB_DEPENDS= libmemcached.so:databases/libmemcached +MEMCACHED_CONFIGURE_ON= --with-memcached=${LOCALBASE}/include +PAM_CONFIGURE_ON= --with-pam +SSL_USES= ssl +SSL_CONFIGURE_WITH= openssl + +post-install: + @${MKDIR} ${STAGEDIR}/var/run/pgpool + ${INSTALL_LIB} ${WRKSRC}/src/libs/pcp/.libs/libpcp.so.2.0.0 ${STAGEDIR}${PREFIX}/lib + +post-install-DOCS-on: + @${MKDIR} ${STAGEDIR}${DOCSDIR} + cd ${WRKSRC} && ${COPYTREE_SHARE} doc ${STAGEDIR}${DOCSDIR} "-not -name Makefile.\*" +.for f in AUTHORS ChangeLog NEWS TODO + ${INSTALL_DATA} ${WRKSRC}/$f ${STAGEDIR}${DOCSDIR} +.endfor + +.include diff --git a/databases/pgpool-II-44/distinfo b/databases/pgpool-II-44/distinfo new file mode 100644 index 000000000000..d6ab812f6308 --- /dev/null +++ b/databases/pgpool-II-44/distinfo @@ -0,0 +1,3 @@ +TIMESTAMP = 1692246912 +SHA256 (pgpool-II-4.4.4.tar.gz) = 10bed66f8197c74dcb00a0e73f618066d5d5e0adc878865c2fcfa1c945e68f4f +SIZE (pgpool-II-4.4.4.tar.gz) = 4973024 diff --git a/databases/pgpool-II-44/files/pgpool.in b/databases/pgpool-II-44/files/pgpool.in new file mode 100644 index 000000000000..cb76557e2e57 --- /dev/null +++ b/databases/pgpool-II-44/files/pgpool.in @@ -0,0 +1,48 @@ +#!/bin/sh + +# PROVIDE: pgpool +# REQUIRE: LOGIN +# KEYWORD: shutdown +# +# Add the following lines to /etc/rc.conf.local or /etc/rc.conf +# to enable this service: +# +# pgpool_enable (bool): Set to NO by default. +# Set it to YES to enable pgpool. +# pgpool_conf (file): Set location of your config. +# Default is "%%PREFIX%%/etc/pgpool.conf" +# pgpool_hba (file): Set location of your pool hba file. +# Default is "%%PREFIX%%/etc/pool_hba.conf" +# pgpool_pcp (file): Set location of your pcp conf file. +# Default is "%%PREFIX%%/etc/pcp.conf" +# pgpool_user (uid): User ID to run as (default nobody) +# pgpool_stop_mode (string): Shutdown mode +# Default is "smart" +# Possibilities are "smart", "fast", or "immediate" +# + +. /etc/rc.subr + +name=pgpool +rcvar=pgpool_enable + +load_rc_config $name + +: ${pgpool_enable="NO"} +: ${pgpool_conf="%%PREFIX%%/etc/pgpool.conf"} +: ${pgpool_hba="%%PREFIX%%/etc/pool_hba.conf"} +: ${pgpool_pcp="%%PREFIX%%/etc/pcp.conf"} +: ${pgpool_user="nobody"} +: ${pgpool_stop_mode="smart"} + +command="%%PREFIX%%/bin/pgpool" +command_args="-f ${pgpool_conf} -a ${pgpool_hba} -F ${pgpool_pcp}" +stop_cmd="${command} -m ${pgpool_stop_mode} ${command_args} stop" +reload_cmd="${command} ${command_args} reload" +extra_commands="reload" + +required_files="${pgpool_conf}" + + +run_rc_command "$1" + diff --git a/databases/pgpool-II-44/pkg-descr b/databases/pgpool-II-44/pkg-descr new file mode 100644 index 000000000000..59d385596b8e --- /dev/null +++ b/databases/pgpool-II-44/pkg-descr @@ -0,0 +1,6 @@ +pgpool is a connection pool server for PostgreSQL. pgpool runs between +PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL client can +connect to pgpool as if it were a standard PostgreSQL server. + +pgpool caches the connection to PostgreSQL server to reduce the overhead to +establish the connection to it. diff --git a/databases/pgpool-II-44/pkg-message b/databases/pgpool-II-44/pkg-message new file mode 100644 index 000000000000..1df287cd433a --- /dev/null +++ b/databases/pgpool-II-44/pkg-message @@ -0,0 +1,15 @@ +[ +{ type: install + message: <