Date: Fri, 4 Jun 2021 21:20:40 GMT From: Torsten Zuehlsdorff <tz@FreeBSD.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org Subject: git: c167b0329e65 - main - databases/pgpool-II-42: New port Message-ID: <202106042120.154LKeWb080456@gitrepo.freebsd.org>
next in thread | raw e-mail | index | archive | help
The branch main has been updated by tz: URL: https://cgit.FreeBSD.org/ports/commit/?id=c167b0329e65dd5bd69f4ae4e46eab05160b0661 commit c167b0329e65dd5bd69f4ae4e46eab05160b0661 Author: Torsten Zuehlsdorff <tz@FreeBSD.org> AuthorDate: 2021-06-04 21:19:06 +0000 Commit: Torsten Zuehlsdorff <tz@FreeBSD.org> CommitDate: 2021-06-04 21:19:06 +0000 databases/pgpool-II-42: 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. WWW: https://pgpool.net/ PR: 256128 Submitted by: Mike Jakubik <mike.jakubik@swiftsmsgateway.com> --- databases/Makefile | 1 + databases/pgpool-II-42/Makefile | 51 ++++++++++++++++++++++++++++++++++ databases/pgpool-II-42/distinfo | 3 ++ databases/pgpool-II-42/files/pgpool.in | 48 ++++++++++++++++++++++++++++++++ databases/pgpool-II-42/pkg-descr | 8 ++++++ databases/pgpool-II-42/pkg-message | 15 ++++++++++ databases/pgpool-II-42/pkg-plist | 46 ++++++++++++++++++++++++++++++ 7 files changed, 172 insertions(+) diff --git a/databases/Makefile b/databases/Makefile index 4cafbc2bd14a..8d19611241b2 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -591,6 +591,7 @@ SUBDIR += pgpool-II-37 SUBDIR += pgpool-II-40 SUBDIR += pgpool-II-41 + SUBDIR += pgpool-II-42 SUBDIR += pgreplay SUBDIR += pgroonga SUBDIR += pgrouting diff --git a/databases/pgpool-II-42/Makefile b/databases/pgpool-II-42/Makefile new file mode 100644 index 000000000000..dbdd86f33c2c --- /dev/null +++ b/databases/pgpool-II-42/Makefile @@ -0,0 +1,51 @@ +PORTNAME= pgpool-II +PORTVERSION= 4.2.3 +CATEGORIES= databases +MASTER_SITES= http://www.pgpool.net/mediawiki/images/ +PKGNAMESUFFIX= 42 + +MAINTAINER= mike.jakubik@swiftsmsgateway.com +COMMENT= Connection pool server for PostgreSQL + +LICENSE= MIT +LICENSE_FILE= ${WRKSRC}/COPYING + +PORTSCOUT= limit:^4.2.[0-9]* + +USES= gmake libtool pgsql:9.6+ +USE_LDCONFIG= yes +USE_RC_SUBR= pgpool + +GNU_CONFIGURE= yes + +CONFLICTS= pgpool-II-[0-9]* + +PORTDOCS= * + +PAM_DESC= Build with PAM support +SSL_DESC= Build with OpenSSL support +MEMCACHED_DESC= Use memcached for in memory query cache + +OPTIONS_DEFINE= DOCS SSL PAM MEMCACHED +OPTIONS_DEFAULT= SSL + +MEMCACHED_CONFIGURE_ON= --with-memcached=${LOCALBASE}/include +MEMCACHED_LIB_DEPENDS= libmemcached.so:databases/libmemcached + +PAM_CONFIGURE_ON= --with-pam + +SSL_CONFIGURE_WITH= openssl +SSL_USES= ssl + +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 <bsd.port.mk> diff --git a/databases/pgpool-II-42/distinfo b/databases/pgpool-II-42/distinfo new file mode 100644 index 000000000000..f113343ee9ba --- /dev/null +++ b/databases/pgpool-II-42/distinfo @@ -0,0 +1,3 @@ +TIMESTAMP = 1621536839 +SHA256 (pgpool-II-4.2.3.tar.gz) = 1cd3a9100aab6711050b291e94e4805287182054ce7811a697bc05723150d6cc +SIZE (pgpool-II-4.2.3.tar.gz) = 4751944 diff --git a/databases/pgpool-II-42/files/pgpool.in b/databases/pgpool-II-42/files/pgpool.in new file mode 100644 index 000000000000..cb76557e2e57 --- /dev/null +++ b/databases/pgpool-II-42/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-42/pkg-descr b/databases/pgpool-II-42/pkg-descr new file mode 100644 index 000000000000..474bcbe9a30e --- /dev/null +++ b/databases/pgpool-II-42/pkg-descr @@ -0,0 +1,8 @@ +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. + +WWW: https://pgpool.net/ diff --git a/databases/pgpool-II-42/pkg-message b/databases/pgpool-II-42/pkg-message new file mode 100644 index 000000000000..1df287cd433a --- /dev/null +++ b/databases/pgpool-II-42/pkg-message @@ -0,0 +1,15 @@ +[ +{ type: install + message: <<EOM +In order to start pgpool you need some more configuration: + +# sysrc -f /etc/rc.conf pgpool_enable="YES" +# sysrc -f /etc/rc.conf pgpool_user="root" + +Please consider the usage of another user. The user is +required to have read/write access to /var/run/pgpool. + +Using the root user is - as always - an security issue. +EOM +} +] diff --git a/databases/pgpool-II-42/pkg-plist b/databases/pgpool-II-42/pkg-plist new file mode 100644 index 000000000000..bb0782c7ce97 --- /dev/null +++ b/databases/pgpool-II-42/pkg-plist @@ -0,0 +1,46 @@ +bin/pcp_attach_node +bin/pcp_detach_node +bin/pcp_health_check_stats +bin/pcp_node_count +bin/pcp_node_info +bin/pcp_pool_status +bin/pcp_proc_count +bin/pcp_proc_info +bin/pcp_promote_node +bin/pcp_recovery_node +bin/pcp_reload_config +bin/pcp_stop_pgpool +bin/pcp_watchdog_info +bin/pg_enc +bin/pg_md5 +bin/pgpool +bin/pgpool_setup +bin/pgproto +bin/watchdog_setup +bin/wd_cli +@sample etc/escalation.sh.sample +@sample etc/failover.sh.sample +@sample etc/follow_primary.sh.sample +@sample etc/pcp.conf.sample +@sample etc/pgpool.conf.sample +@sample etc/pgpool_remote_start.sample +@sample etc/pool_hba.conf.sample +etc/pgpool.conf.sample-logical +etc/pgpool.conf.sample-raw +etc/pgpool.conf.sample-replication +etc/pgpool.conf.sample-stream +etc/pgpool.conf.sample-slony +etc/pgpool.conf.sample-snapshot +etc/recovery_1st_stage.sample +etc/recovery_2nd_stage.sample +include/libpcp_ext.h +include/pcp.h +include/pool_process_reporting.h +include/pool_type.h +lib/libpcp.a +lib/libpcp.so +lib/libpcp.so.2 +lib/libpcp.so.2.0.0 +%%DATADIR%%/insert_lock.sql +%%DATADIR%%/pgpool.pam +@dir /var/run/pgpool
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?202106042120.154LKeWb080456>