Hi, Small diff to update pgbouncer to it's latest version. Tested on @amd64.
Regards, -- Pierre-Emmanuel André <pea at raveland.org> GPG key: 0x7AE329DC
Index: Makefile =================================================================== RCS file: /cvs/ports/databases/pgbouncer/Makefile,v retrieving revision 1.16 diff -u -p -r1.16 Makefile --- Makefile 22 Apr 2012 11:41:55 -0000 1.16 +++ Makefile 6 Jun 2012 08:45:32 -0000 @@ -2,8 +2,7 @@ COMMENT = lightweight connection pooler for PostgreSQL -DISTNAME = pgbouncer-1.5 -REVISION = 0 +DISTNAME = pgbouncer-1.5.2 CATEGORIES = databases @@ -19,7 +18,7 @@ PERMIT_DISTFILES_CDROM =Yes WANTLIB = c event -MASTER_SITES = http://pgfoundry.org/frs/download.php/3197/ +MASTER_SITES = http://pgfoundry.org/frs/download.php/3293/ BUILD_DEPENDS = devel/libeventextra Index: distinfo =================================================================== RCS file: /cvs/ports/databases/pgbouncer/distinfo,v retrieving revision 1.4 diff -u -p -r1.4 distinfo --- distinfo 17 Jan 2012 13:57:24 -0000 1.4 +++ distinfo 6 Jun 2012 08:45:32 -0000 @@ -1,5 +1,5 @@ -MD5 (pgbouncer-1.5.tar.gz) = YXn9x/fjxwL+g01lVnbeTA== -RMD160 (pgbouncer-1.5.tar.gz) = 57p+s+4DQZHLsbq0J+nrGl5Pars= -SHA1 (pgbouncer-1.5.tar.gz) = vrsCsk1ggzmMZYd928E7QusyaYA= -SHA256 (pgbouncer-1.5.tar.gz) = QIkk1UeU/NY80xKE+hOiEmay/DPGtea+HrHZFRImH+4= -SIZE (pgbouncer-1.5.tar.gz) = 411488 +MD5 (pgbouncer-1.5.2.tar.gz) = 214Mt0E0Q3mcJBaIuXLmPw== +RMD160 (pgbouncer-1.5.2.tar.gz) = 7ZYvqEUvcfNMHm8a2fVlcRLhPS4= +SHA1 (pgbouncer-1.5.2.tar.gz) = 2eeWsXXhAj71dPdopxHn3NYLUBY= +SHA256 (pgbouncer-1.5.2.tar.gz) = 8X6/Hf403Uw5wt2GHVtY8Izs7yK+O3TaJW0l6hXUUfg= +SIZE (pgbouncer-1.5.2.tar.gz) = 335338 Index: patches/patch-etc_pgbouncer_ini =================================================================== RCS file: /cvs/ports/databases/pgbouncer/patches/patch-etc_pgbouncer_ini,v retrieving revision 1.2 diff -u -p -r1.2 patch-etc_pgbouncer_ini --- patches/patch-etc_pgbouncer_ini 17 Jan 2012 13:57:24 -0000 1.2 +++ patches/patch-etc_pgbouncer_ini 6 Jun 2012 08:45:32 -0000 @@ -1,34 +1,21 @@ $OpenBSD: patch-etc_pgbouncer_ini,v 1.2 2012/01/17 13:57:24 pea Exp $ ---- etc/pgbouncer.ini.orig Mon Dec 12 18:09:54 2011 -+++ etc/pgbouncer.ini Wed Jan 11 10:02:47 2012 -@@ -27,8 +27,8 @@ nondefaultdb = pool_size=50 reserve_pool=10 - ;;; Administrative settings - ;;; - --logfile = pgbouncer.log --pidfile = pgbouncer.pid -+logfile = /var/log/pgbouncer/pgbouncer.log -+pidfile = /var/run/pgbouncer/pgbouncer.pid - - ;;; - ;;; Where to wait for clients -@@ -47,16 +47,16 @@ listen_port = 6432 +--- etc/pgbouncer.ini.orig Wed Jun 6 10:41:02 2012 ++++ etc/pgbouncer.ini Wed Jun 6 10:41:26 2012 +@@ -50,7 +50,7 @@ listen_port = 6432 ;;; ; any, trust, plain, crypt, md5 -auth_type = trust +auth_type = md5 - ;auth_file = 8.0/main/global/pg_auth --auth_file = etc/userlist.txt -+auth_file = /etc/pgbouncer/userlist.txt + ;auth_file = /8.0/main/global/pg_auth + auth_file = /etc/pgbouncer/userlist.txt - ;;; - ;;; Users allowed into database 'pgbouncer' +@@ -59,7 +59,7 @@ auth_file = /etc/pgbouncer/userlist.txt ;;; ; comma-separated list of users, who are allowed to change settings --admin_users = user2, someadmin, otheradmin +-;admin_users = user2, someadmin, otheradmin +admin_users = admin, pgbouncer ; comma-separated list of users who are just allowed to use SHOW command - stats_users = stats, root + ;stats_users = stats, root
