Index: databases/pgpool-II-43/Makefile =================================================================== --- databases/pgpool-II-43/Makefile +++ databases/pgpool-II-43/Makefile @@ -1,5 +1,6 @@ PORTNAME= pgpool-II PORTVERSION= 4.3.2 +PORTREVISION= 1 CATEGORIES= databases MASTER_SITES= http://www.pgpool.net/mediawiki/images/ PKGNAMESUFFIX= -43 @@ -22,11 +23,13 @@ PORTDOCS= * -OPTIONS_DEFINE= DOCS MEMCACHED PAM SSL +OPTIONS_DEFINE= DOCS MEMCACHED PAM SQLEXT SSL OPTIONS_DEFAULT= SSL +OPTIONS_SUB= yes MEMCACHED_DESC= Use memcached for in memory query cache PAM_DESC= Build with PAM support +SQLEXT_DESC= Build PostgreSQL extensions SSL_DESC= Build with OpenSSL support MEMCACHED_LIB_DEPENDS= libmemcached.so:databases/libmemcached @@ -35,6 +38,9 @@ SSL_USES= ssl SSL_CONFIGURE_WITH= openssl +do-build-SQLEXT-on: + (cd ${WRKSRC}/src/sql && ${SETENV} ${GMAKE}) + post-install: @${MKDIR} ${STAGEDIR}/var/run/pgpool ${INSTALL_LIB} ${WRKSRC}/src/libs/pcp/.libs/libpcp.so.2.0.0 ${STAGEDIR}${PREFIX}/lib @@ -46,4 +52,14 @@ ${INSTALL_DATA} ${WRKSRC}/$f ${STAGEDIR}${DOCSDIR} .endfor +post-install-SQLEXT-on: + @${MKDIR} ${STAGEDIR}${PREFIX}/lib/postgresql + @${MKDIR} ${STAGEDIR}${PREFIX}/share/postgresql/extension +.for f in pgpool_adm pgpool-recovery pgpool-regclass + (cd ${WRKSRC}/src/sql/$f && \ + ${COPYTREE_SHARE} . ${STAGEDIR}${PREFIX}/share/postgresql/extension "( ! -name uninstall_*\.sql ) -a -name *\.sql -o -name *\.control" && \ + ${INSTALL_LIB} $f.so ${STAGEDIR}${PREFIX}/lib/postgresql && \ + ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/$f.so) +.endfor + .include Index: databases/pgpool-II-43/files/pgpool.in =================================================================== --- databases/pgpool-II-43/files/pgpool.in +++ databases/pgpool-II-43/files/pgpool.in @@ -16,6 +16,7 @@ # 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_group (gid): Group ID to run as (default nobody) # pgpool_stop_mode (string): Shutdown mode # Default is "smart" # Possibilities are "smart", "fast", or "immediate" @@ -33,10 +34,15 @@ : ${pgpool_hba="%%PREFIX%%/etc/pool_hba.conf"} : ${pgpool_pcp="%%PREFIX%%/etc/pcp.conf"} : ${pgpool_user="nobody"} +: ${pgpool_group="nobody"} : ${pgpool_stop_mode="smart"} +_piddir="/var/run/pgpool" +pidfile="${_piddir}/pgpool.pid" + command="%%PREFIX%%/bin/pgpool" command_args="-f ${pgpool_conf} -a ${pgpool_hba} -F ${pgpool_pcp}" +start_precmd="install -d -o ${pgpool_user} -g ${pgpool_group} -m 755 $_piddir" stop_cmd="${command} -m ${pgpool_stop_mode} ${command_args} stop" reload_cmd="${command} ${command_args} reload" extra_commands="reload" Index: databases/pgpool-II-43/pkg-plist =================================================================== --- databases/pgpool-II-43/pkg-plist +++ databases/pgpool-II-43/pkg-plist @@ -38,4 +38,29 @@ lib/libpcp.so.2.0.0 %%DATADIR%%/insert_lock.sql %%DATADIR%%/pgpool.pam +%%SQLEXT%%lib/postgresql/pgpool-recovery.so +%%SQLEXT%%lib/postgresql/pgpool-regclass.so +%%SQLEXT%%lib/postgresql/pgpool_adm.so +%%SQLEXT%%share/postgresql/extension/pgpool-recovery.sql +%%SQLEXT%%share/postgresql/extension/pgpool-regclass.sql +%%SQLEXT%%share/postgresql/extension/pgpool_adm--1.0--1.1.sql +%%SQLEXT%%share/postgresql/extension/pgpool_adm--1.0.sql +%%SQLEXT%%share/postgresql/extension/pgpool_adm--1.1--1.2.sql +%%SQLEXT%%share/postgresql/extension/pgpool_adm--1.1.sql +%%SQLEXT%%share/postgresql/extension/pgpool_adm--1.2--1.3.sql +%%SQLEXT%%share/postgresql/extension/pgpool_adm--1.2.sql +%%SQLEXT%%share/postgresql/extension/pgpool_adm--1.3--1.4.sql +%%SQLEXT%%share/postgresql/extension/pgpool_adm--1.3.sql +%%SQLEXT%%share/postgresql/extension/pgpool_adm--1.4.sql +%%SQLEXT%%share/postgresql/extension/pgpool_adm.control +%%SQLEXT%%share/postgresql/extension/pgpool_recovery--1.1--1.2.sql +%%SQLEXT%%share/postgresql/extension/pgpool_recovery--1.1.sql +%%SQLEXT%%share/postgresql/extension/pgpool_recovery--1.2--1.3.sql +%%SQLEXT%%share/postgresql/extension/pgpool_recovery--1.2.sql +%%SQLEXT%%share/postgresql/extension/pgpool_recovery--1.3--1.4.sql +%%SQLEXT%%share/postgresql/extension/pgpool_recovery--1.3.sql +%%SQLEXT%%share/postgresql/extension/pgpool_recovery--1.4.sql +%%SQLEXT%%share/postgresql/extension/pgpool_recovery.control +%%SQLEXT%%share/postgresql/extension/pgpool_regclass--1.0.sql +%%SQLEXT%%share/postgresql/extension/pgpool_regclass.control @dir /var/run/pgpool