ports/96637: upgrade databases/pgpool to latest

[Vivek Khera]

>Number:         96637
>Category:       ports
>Synopsis:       upgrade databases/pgpool to latest
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          update
>Submitter-Id:   current-users
>Arrival-Date:   Tue May 02 02:30:18 GMT 2006
>Closed-Date:
>Last-Modified:
>Originator:     Vivek Khera
>Release:        FreeBSD 6.1-PRERELEASE amd64
>Organization:
>Environment:
System: FreeBSD yertle.int.kciLink.com 6.1-PRERELEASE FreeBSD 6.1-PRERELEASE #4: Thu Mar 2 13:53:40 EST 2006 khera at yertle.int.kciLink.com:/usr/obj/usr/src/sys/KCI64 amd64


	
>Description:
	

pgpool doesn't seem to have been updated over the last 4 or 5 versions (over 8
months now).

>How-To-Repeat:
	

>Fix:

	

The patch below brings it up to the latest release and fixes missing man page
from the plist.  it also runs the daemon as user "nobody" since running as
root is not necessary and is normally just a bad idea.

diff -Pru pgpool.old/Makefile pgpool/Makefile
--- pgpool.old/Makefile	Fri Apr 14 14:40:59 2006
+++ pgpool/Makefile	Mon May  1 22:22:37 2006
@@ -6,10 +6,9 @@
 #
 
 PORTNAME=	pgpool
-PORTVERSION=	2.6.3
-PORTREVISION=	1
+PORTVERSION=	3.0.1
 CATEGORIES=	databases
-MASTER_SITES=	http://pgfoundry.org/frs/download.php/426/
+MASTER_SITES=	http://pgfoundry.org/frs/download.php/733/
 
 MAINTAINER=	whitekid at gmail.com
 COMMENT=	A connection pool server for PostgreSQL
@@ -20,6 +19,8 @@
 USE_RC_SUBR=	pgpool
 
 PORTDOCS=	README AUTHORS COPYING ChangeLog INSTALL NEWS TODO README.euc_jp
+
+MAN8=		pgpool.8
 
 post-install:
 .if !defined(NOPORTDOCS)
diff -Pru pgpool.old/distinfo pgpool/distinfo
--- pgpool.old/distinfo	Sun Jan 22 03:23:33 2006
+++ pgpool/distinfo	Mon May  1 22:15:30 2006
@@ -1,3 +1,3 @@
-MD5 (pgpool-2.6.3.tar.gz) = fb301c1f42f67357dd72c9a20042c2ba
-SHA256 (pgpool-2.6.3.tar.gz) = a1aeab14412447f487012dfa8b8c29ff609a938ac9c215c00d30acee0841011e
-SIZE (pgpool-2.6.3.tar.gz) = 150829
+MD5 (pgpool-3.0.1.tar.gz) = 939e8c94a45196a38278822b4471897f
+SHA256 (pgpool-3.0.1.tar.gz) = ad848317abe0fe1b126ec2c9ad2edd220ed4c86127c548b6a137c1724cc9ac3f
+SIZE (pgpool-3.0.1.tar.gz) = 156281
diff -Pru pgpool.old/files/pgpool.in pgpool/files/pgpool.in
--- pgpool.old/files/pgpool.in	Fri Apr 14 14:40:59 2006
+++ pgpool/files/pgpool.in	Mon May  1 22:18:46 2006
@@ -13,6 +13,7 @@
 #				Set it to YES to enable pgpool.
 # pgpool_conf (file):		Set location of your config.
 #				Default is "%%PREFIX%%/etc/pgpool.conf"
+# pgpool_user (uid):		User ID to run as (default nobody)
 #
 
 . %%RC_SUBR%%
@@ -24,6 +25,7 @@
 
 : ${pgpool_enable="NO"}
 : ${pgpool_conf="%%PREFIX%%/etc/pgpool.conf"}
+: ${pgpool_user="nobody"}
 
 command="%%PREFIX%%/bin/pgpool"
 command_args="-f ${pgpool_conf}"

>Release-Note:
>Audit-Trail:
>Unformatted: