Attachment #162283 for bug #203769




# $FreeBSD$

PORTNAME=	pgpool
PORTVERSION=	3.4.3
PORTREVISION=	1
CATEGORIES=	databases
MASTER_SITES=	http://www.pgpool.net/mediawiki/images/
DISTNAME=	${PORTNAME}-II-${PORTVERSION}

MAINTAINER=	ports@toco-domains.de
COMMENT=	Connection pool server for PostgreSQL

LICENSE=	MIT

USES=		gmake libtool pgsql:9.3+
GNU_CONFIGURE=	yes
USE_LDCONFIG=	yes

USE_RC_SUBR=	pgpool
CONFLICTS=	pgpool-II-*

PORTDOCS=	AUTHORS ChangeLog NEWS TODO

OPTIONS_DEFINE=	DOCS

post-install:
	${MKDIR} ${STAGEDIR}${DOCSDIR}
.for f in ${PORTDOCS}
	${INSTALL_DATA} ${WRKSRC}/$f ${STAGEDIR}${DOCSDIR}
.endfor
	${MKDIR} ${STAGEDIR}/var/run/pgpool
	${INSTALL_LIB} ${WRKSRC}/src/libs/pcp/.libs/libpcp.so.0.0.0 ${STAGEDIR}${PREFIX}/lib

.include <bsd.port.mk>

Lines 1-2 Link Here

(-)distinfo (-2 / +2 lines)
1	SHA256 (pgpool-3.4.1.tar.gz) = 39d6229acfdd30616207de997ac2a221dd962361bb0bd532ddb15ecc3f04118d	1	SHA256 (pgpool-II-3.4.3.tar.gz) = b030d1a0dfb919dabb90987f429b03a67b22ecdbeb0ec1bd969ebebe690006e4
2	SIZE (pgpool-3.4.1.tar.gz) = 201509	2	SIZE (pgpool-II-3.4.3.tar.gz) = 2152319

Lines 5-8 Link Here

(-)pkg-descr (-1 / +1 lines)
5	pgpool caches the connection to PostgreSQL server to reduce the overhead to	5	pgpool caches the connection to PostgreSQL server to reduce the overhead to
6	establish the connection to it.	6	establish the connection to it.
7		7
8	WWW: http://pgpool.projects.postgresql.org/	8	WWW: http://pgpool.net/




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.
yes
native
text/plain




bin/pcp_attach_node
bin/pcp_detach_node
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_stop_pgpool
bin/pcp_systemdb_info
bin/pcp_watchdog_info
bin/pg_md5
bin/pgpool
@sample etc/pcp.conf.sample
@sample etc/pgpool.conf.sample
etc/pgpool.conf.sample-master-slave
etc/pgpool.conf.sample-replication
etc/pgpool.conf.sample-stream
@sample etc/pool_hba.conf.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.0
lib/libpcp.so.0.0.0
man/man8/pgpool.8.gz
share/pgpool-II/insert_lock.sql
share/pgpool-II/pgpool.pam
share/pgpool-II/system_db.sql
@dir /var/run/pgpool

Return to bug 203769

Lines 2-31 Link Here

(-)Makefile (-8 / +11 lines)
2	# $FreeBSD$	2	# $FreeBSD$
3		3
4	PORTNAME= pgpool	4	PORTNAME= pgpool
5	PORTVERSION= 3.4.1	5	PORTVERSION= 3.4.3
6	PORTREVISION= 1
7	CATEGORIES= databases	6	CATEGORIES= databases
8	MASTER_SITES= http://pgfoundry.org/frs/download.php/1446/	7	MASTER_SITES= http://www.pgpool.net/mediawiki/images/
		8	DISTNAME= ${PORTNAME}-II-${PORTVERSION}
9		9
10	MAINTAINER= ports@FreeBSD.org	10	MAINTAINER= ports@toco-domains.de
11	COMMENT= Connection pool server for PostgreSQL	11	COMMENT= Connection pool server for PostgreSQL
12		12
13	LICENSE= MIT	13	LICENSE= MIT
14		14
15	USES= gmake	15	USES= gmake libtool pgsql:9.3+
16	GNU_CONFIGURE= yes	16	GNU_CONFIGURE= yes
		17	USE_LDCONFIG= yes
17		18
18	USE_RC_SUBR= pgpool	19	USE_RC_SUBR= pgpool
19	CONFLICTS= pgpool-II-*	20	CONFLICTS= pgpool-II-*
20		21
21	PORTDOCS= README AUTHORS COPYING ChangeLog INSTALL NEWS TODO README.euc_jp	22	PORTDOCS= AUTHORS ChangeLog NEWS TODO
22		23
23	OPTIONS_DEFINE= DOCS	24	OPTIONS_DEFINE= DOCS
24		25
25	post-install:	26	post-install:
26	@${MKDIR} ${STAGEDIR}${DOCSDIR}	27	${MKDIR} ${STAGEDIR}${DOCSDIR}
27	.for f in ${PORTDOCS}	28	.for f in ${PORTDOCS}
28	${INSTALL_MAN} ${WRKSRC}/$f ${STAGEDIR}${DOCSDIR}	29	${INSTALL_DATA} ${WRKSRC}/$f ${STAGEDIR}${DOCSDIR}
29	.endfor	30	.endfor
		31	${MKDIR} ${STAGEDIR}/var/run/pgpool
		32	${INSTALL_LIB} ${WRKSRC}/src/libs/pcp/.libs/libpcp.so.0.0.0 ${STAGEDIR}${PREFIX}/lib
30		33
31	.include <bsd.port.mk>	34	.include <bsd.port.mk>

Line 0 Link Here

(-)pkg-message (+12 lines)
	1	In order to start pgpool you need some more configuration:
	2
	3	# sysrc -f /etc/rc.conf pgpool_enable="YES"
	4	# sysrc -f /etc/rc.conf pgpool_user="root"
	5
	6	Please consider the usage of another user. The user is
	7	required to have read/write access to /var/run/pgpool.
	8
	9	Using the root user is - as always - an security issue.
	10	yes
	11	native
	12	text/plain

Lines 1-5 Link Here

(-)pkg-plist (-3 / +31 lines)
		1	bin/pcp_attach_node
		2	bin/pcp_detach_node
		3	bin/pcp_node_count
		4	bin/pcp_node_info
		5	bin/pcp_pool_status
		6	bin/pcp_proc_count
		7	bin/pcp_proc_info
		8	bin/pcp_promote_node
		9	bin/pcp_recovery_node
		10	bin/pcp_stop_pgpool
		11	bin/pcp_systemdb_info
		12	bin/pcp_watchdog_info
		13	bin/pg_md5
1	bin/pgpool	14	bin/pgpool
2	etc/pgpool.conf.sample	15	@sample etc/pcp.conf.sample
3	etc/pool_hba.conf.sample	16	@sample etc/pgpool.conf.sample
		17	etc/pgpool.conf.sample-master-slave
		18	etc/pgpool.conf.sample-replication
		19	etc/pgpool.conf.sample-stream
		20	@sample etc/pool_hba.conf.sample
		21	include/libpcp_ext.h
		22	include/pcp.h
		23	include/pool_process_reporting.h
		24	include/pool_type.h
		25	lib/libpcp.a
		26	lib/libpcp.so
		27	lib/libpcp.so.0
		28	lib/libpcp.so.0.0.0
4	man/man8/pgpool.8.gz	29	man/man8/pgpool.8.gz
5	share/pgpool/pgpool.pam	30	share/pgpool-II/insert_lock.sql
		31	share/pgpool-II/pgpool.pam
		32	share/pgpool-II/system_db.sql
		33	@dir /var/run/pgpool