Hi, had to backport pgbouncer 1.7 to 6.2 ( i need auth_type = hba) and then i realized upstream released 1.8 and 1.8.1 (which i'm already running on debian), see https://pgbouncer.github.io/changelog.html#pgbouncer-18x
easy diff, only build-tested :) Landry
Index: Makefile =================================================================== RCS file: /cvs/ports/databases/pgbouncer/Makefile,v retrieving revision 1.25 diff -u -r1.25 Makefile --- Makefile 11 Jan 2018 19:27:01 -0000 1.25 +++ Makefile 19 Jan 2018 14:36:21 -0000 @@ -2,9 +2,8 @@ COMMENT = lightweight connection pooler for PostgreSQL -V = 1.7.2 +V = 1.8.1 DISTNAME = pgbouncer-${V} -REVISION = 0 CATEGORIES = databases Index: distinfo =================================================================== RCS file: /cvs/ports/databases/pgbouncer/distinfo,v retrieving revision 1.10 diff -u -r1.10 distinfo --- distinfo 19 Dec 2017 08:58:15 -0000 1.10 +++ distinfo 19 Jan 2018 14:36:21 -0000 @@ -1,2 +1,2 @@ -SHA256 (pgbouncer-1.7.2.tar.gz) = 3jazGP5KLyCl9g0cXqYsHKMx9oE9LEhIZuy1kmWhYLo= -SIZE (pgbouncer-1.7.2.tar.gz) = 462374 +SHA256 (pgbouncer-1.8.1.tar.gz) = +oveKi0sjIDVOoWfjki8ZxPPEn4xx32PeHu8HWc+jcg= +SIZE (pgbouncer-1.8.1.tar.gz) = 465930 Index: patches/patch-etc_pgbouncer_ini =================================================================== RCS file: /cvs/ports/databases/pgbouncer/patches/patch-etc_pgbouncer_ini,v retrieving revision 1.4 diff -u -r1.4 patch-etc_pgbouncer_ini --- patches/patch-etc_pgbouncer_ini 19 Dec 2017 13:44:35 -0000 1.4 +++ patches/patch-etc_pgbouncer_ini 19 Jan 2018 14:36:21 -0000 @@ -2,16 +2,16 @@ Index: etc/pgbouncer.ini --- etc/pgbouncer.ini.orig +++ etc/pgbouncer.ini -@@ -98,7 +98,7 @@ listen_port = 6432 +@@ -103,7 +103,7 @@ listen_port = 6432 ;;; - ; any, trust, plain, crypt, md5 + ; any, trust, plain, crypt, md5, cert, hba, pam -auth_type = trust +auth_type = md5 ;auth_file = /8.0/main/global/pg_auth auth_file = /etc/pgbouncer/userlist.txt -@@ -114,7 +114,7 @@ auth_file = /etc/pgbouncer/userlist.txt +@@ -119,7 +119,7 @@ auth_file = /etc/pgbouncer/userlist.txt ;;; ; comma-separated list of users, who are allowed to change settings Index: patches/patch-lib_usual_tls_tls_c =================================================================== RCS file: /cvs/ports/databases/pgbouncer/patches/patch-lib_usual_tls_tls_c,v retrieving revision 1.1 diff -u -r1.1 patch-lib_usual_tls_tls_c --- patches/patch-lib_usual_tls_tls_c 19 Dec 2017 08:58:15 -0000 1.1 +++ patches/patch-lib_usual_tls_tls_c 19 Jan 2018 14:36:21 -0000 @@ -3,7 +3,7 @@ Index: lib/usual/tls/tls.c --- lib/usual/tls/tls.c.orig +++ lib/usual/tls/tls.c -@@ -287,7 +287,7 @@ tls_info_callback(const SSL *ssl, int where, int rc) +@@ -350,7 +350,7 @@ tls_info_callback(const SSL *ssl, int where, int rc) { struct tls *ctx = SSL_get_app_data(ssl);