databases/pgbouncer: Upgrade to 1.22.1

Release notes:	https://www.pgbouncer.org/2024/03/pgbouncer-1-22-1
Approved by:	submitter is maintainer

databases/pgbouncer: Moved man to share/man

Approved by:    portmgr (blanket)

databases/pgbouncer: Update version 1.20.1=>1.21.0

Changelog: https://www.pgbouncer.org/changelog.html#pgbouncer-121x

PR:		275180
Approved by:	submitter is maintainer

databases/pgbouncer: Update to 1.20.1

ChangeLog: https://www.pgbouncer.org/changelog.html#pgbouncer-120x

PR:		273197
Reported by:	dmitry.wagin@ya.ru (maintainer)

databases/pgbouncer: update to 1.19.1

Changelog: https://www.pgbouncer.org/changelog.html#pgbouncer-119x

PR:		271828
MFH:		2023Q2

databases/pgbouncer: add a graceful stop command to rc script

The user can now terminate pgbouncer both with gracefulstop
(sends SIGINT) and with stop (sends SIGTERM).

PR:		271023

databases/pgbouncer: Update to 1.18.0

Maintainer yields maintainership in favor of submitter, already maintainer of
several ports.

ChangeLog: https://www.pgbouncer.org/changelog.html#pgbouncer-118x

 * Add application_name to SHOW CLIENTS/SERVERS/SOCKETS output
 * Add information about cancel requests to SHOW CLIENTS/SERVERS/POOLS output
 * Fail sbuf_send_pending operation if destination socket is closed
 * Fix a few possible crashes
 * Fix for overflow bug in comma-separated host list feature, causing
   connection to get re-routed to Unix socket
 * Don’t evict connections to achieve min_pool_size
 * Fix SHOW HELP with PostgreSQL 15
 * Fix race condition in query cancelation handling. It was possible that a
   query cancellation for one client canceled a query for another one. This
   could happen when a cancel request was received by PgBouncer when the query
   it was meant to cancel already completed by itself.
 * Various CI updates

PR:		269499
Reported by:	dmitry.wagin@ya.ru
Approved by:	m.tsatsenko@gmail.com (maintainer)

Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)

Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>

databases/pgbouncer: Update version 1.16.1=>1.17.0

- Pet portclippy/portfmt

PR:		264916
Approved by:	m.tsatsenko@gmail.com (maintainer)
Relnotes: https://www.pgbouncer.org/changelog.html#pgbouncer-117x
Sponsored by:	Bounce Experts

databases/pgbouncer: Update version 1.16.0=>1.16.1

- Add OVERRIDE for variables [1]

PR:		259714
Reported by:	drtr0jan@yandex.ru [1]
Approved by:	m.tsatsenko@gmail.com (maintainer)

databases/pgbouncer: Fix config file

- No need to replace pgbouncer.log as the config mentions the absolute path
  /var/log/pgbouncer/pgbouncer.log now
- No need to replace pgbouncer.pid as the config mentions the absolute path
  /var/run/pgbouncer/pgbouncer.log now
- References to other files in /etc/ is changed with ${PREFIX}/etc specially
  pgbouncer.users which had a reference to /etc directory
- No longer requires gsed so removed the BUILD_DEPENDS
- There was a pkg-message.in file which was not called using SUB_FILES; added
  accordingly

PR: 259474
Approved by: m.tsatsenko@gmail.com (maintainer)
Sponsored by: Bounce Experts

databases/pgbouncer: update to 1.16.0

- Update to 1.16.0
- Remove an unneeded patch (merged upstream)

Submitted by: m.tsatsenko@gmail.com (maintainer)

databases/pgbouncer: Add CPE information

Approved by:	portmgr (blanket)

all: Remove all other $FreeBSD keywords.

Remove # $FreeBSD$ from Makefiles.

databases/pgbouncer: fix usage SO_REUSEPORT_LB

PR:		247956
Submitted by:	Dmitry Wagin <dmitry.wagin@ya.ru>
Approved by:	m.tsatsenko@gmail.com (maintainer)

- Update to 1.14.0

PR:		247362
Submitted by:	maintainer

databases/pgbouncer: Update to 1.12.0

- update to 1.12.0
- add USE=pkgconfig for libevent

Changes: https://github.com/pgbouncer/pgbouncer/releases/tag/pgbouncer_1_12_0

PR:		241331
Submitted by:	Loic Bartoletti <lbartoletti@tuxfamily.org>
Approved by:	m.tsatsenko@gmail.com (maintainer), araujo (mentor)
Differential Revision:	https://reviews.freebsd.org/D22097

Convert to UCL & cleanup pkg-message (categories d)

devel/libevent2: update to 2.1.11

Changes:	https://github.com/libevent/libevent/releases/tag/release-2.1.11-stable
ABI:		https://abi-laboratory.pro/tracker/timeline/libevent/
PR:		239599
Reported by:	GitHub (watch releases)
Approved by:	zeising (maintainer)
MFH:		2019Q3 (maybe security, partially restores 2.1.8 ABI)
Differential Revision:	https://reviews.freebsd.org/D21133

databases/pgbouncer: update to 1.9.0

PR:		235924
Submitted by:	m.tsatsenko@gmail.com (maintainer)

databases/pgbouncer builds fine with OpenSSL 1.1.1 after r467201

http://beefy12.nyi.freebsd.org/data/head-amd64-default/p485718_s340864/logs/pgbouncer-1.8.1.log

security/openssl-devel was removed, but there is a security/openssl111 now.

Update to version 1.8.1

PR:		227462
Release notes:	https://pgbouncer.github.io/changelog.html#pgbouncer-18x

BROKEN_SSL: Add REASON for breakage

Reported by:	matwq

security/openssl-devel: Mark broken databases cat

databases/pgbouncer: Add patch for LibreSSL 2.5 support

PR:		219018
Submitted by:	Tom Hurst <tom@hur.st>
Approved by:	m.tsatsenko@gmail.com (maintainer)

Add CARES option

- Bump PORTREVISION for package change

PR:		218499
Submitted by:	Mikhail Tsatsenko <m.tsatsenko@gmail.com> (maintainer)

Remove all USE_OPENSSL occurrences.

Sponsored by:	Absolight

devel/libevent2: drop historical suffix after r362796

PR:		216777
Approved by:	mm (maintainer)

devel/libevent2: update to 2.1.8 and cleanup

- DEFAULT_VERSIONS += ssl=openssl-devel is now supported
- devel/py-event and devel/p5-Event-Lib are marked BROKEN

Changes:	https://github.com/libevent/libevent/raw/release-2.1.8-stable/whatsnew-2.1.txt
Changes:	https://github.com/libevent/libevent/raw/release-2.1.8-stable/ChangeLog
PR:		216527
Exp-run by:	antoine
Approved by:	mm (maintainer)

- Remove always-true/false conditions after FreeBSD 9, 10.1, 10.2 EOL

Approved by:	portmgr blanket

Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight

Update to 1.7.2.

PR:		207538
Submitted by:	cmt
Approved by:	m.tsatsenko@gmail.com (maintainer)

.Fix build on 9.x.

Setting WITH_OPENSSL_PORT after including bsd.ports.pre.mk is a no-op, include
bsd.port.options.mk instead.

The 2016Q1 is unaffected by this bug.

PR:		207382
Submitted by:	m.tsatsenko@gmail.com (maintainer)

Update to 1.7
  - Adds the ability to connect via TLS

PR:		206365
Submitted by:	m.tsatsenko@gmail.com (maintainer)

databases/pgbouncer: update 1.5.5 -> 1.6.1

While here, add HTTP mirror to address portlint

PR:		202957
Submitted by:	m.tsatsenko@gmail.com (maintainer)
Approved by:	feld (mentor)

Security update to 1.5.5, while there also move the
upstream to github.

PR:		200537
Approved by:	maintainer
MFH:		2015Q2 (test)

databases category: Remove $PTHREAD_LIBS

Note: virtuoso did not pass check-plist from before, so it was fixed.

approved by:	PTHREAD blanket

Fix yet another typo

Fix packaging

Fix typo

Cleanup plist

databases/pgbouncer: Remove unnecessary dependency xmlto

It turns out that xmlto is not needed for documentation at all now.
The man pages are pregenerated and provided in the tarball.

PR:		192507
Reported by:	dmitry2004 (yandex.ru)

databases/pgbouncer: Unconditionally install man pages

This port had a couple of issues besided installing man pages as a
function of the DOCS option selection.  It also was using <pre> and <post>
inclusions with <options>, _DEPENDS were in multiple places.

I regrouped the *_DEPENDS, I moved the options to just above the make
targets (their conventional location) and I utilized <option>_*_DEPENDS
as well after fixing the man pages.

PR:		192507
Reported by:	dmitry2004 (yandex.ru)
Approved by:	Just Fix It (maintainer in copy)

Only use libevent2

Remove libevent as libevent2 is providing a good compatibility interface as well
as providing better performances.
Remove custom patches from libevent2 and install libevent2 the regular way
Mark ports abusing private fields of the libevent1 API as broken
Import a patch from fedora to have honeyd working with libevent2
Remove most of the patches necessary to find the custom installation we used to
have for libevent2

With hat:	portmgr

Fix substitution in files/pgbounce.in.

PR:		191698
Submitted by:	oleg@mamontov.net
Approved by:	m.tsatsenko@gmail.com (maintainer)

- Fix minor issue from previous commit by changing from SUB_LIST to PLIST_SUB

PR:		189787
Reported by:	Mikhail Tatsenko <m.tsatsenko@gmail.com> (maintainer)
Pointyhat to:	swills

- Add STAGE support
- Depend on xmlto to generate man pages. Add DOCS option

PR:		ports/189787
Submitted by:	"Mikhail T." <m.tsatsenko@gmail.com> (maintainer)

Fix LIB_DEPENDS

In preparation for making libtool generate libraries with a sane name, fix all
LIB_DEPENDS in databases

- Switch to libevent2
- Bump PORTREVISION
- Pet portlint

PR:		ports/182446
Submitted by:	"Mikhail T." <m.tsatsenko@gmail.com> (maintainer)

Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)

Update to 1.5.4.

PR:		ports/176640
Submitted by:	Mikhail Tsatsenko <m.tsatsenko@gmail.com> (maintainer)

- pass maintainer to Mikhail Tsatsenko <m.tsatsenko@gmail.com>
  requested here:
  http://lists.freebsd.org/pipermail/freebsd-ports/2013-April/082988.html

Reassign skv@ ports to the heap

Feature safe:	yes

Move the rc.d scripts of the form *.sh.in to *.in

Where necessary add $FreeBSD$ to the file

No PORTREVISION bump necessary because this is a no-op

* Update to 1.5.2 [1]
* Add patch to use TCP_KEEP{CNT, IDLE, INTVL, ALIVE} [2]

Changes:        http://pgfoundry.org/forum/forum.php?forum_id=1885
PR:             ports/169463 [1]
Submitted by:   Dmitry <dmitry2004@yandex.ru> [1],
                Oleg A. Mamontov <oleg@mamontov.net> [2]

Update to 1.5.1

Changes:        http://pgfoundry.org/frs/shownotes.php?release_id=1936

Update to 1.5

Changes:        http://pgfoundry.org/frs/shownotes.php?release_id=1920
PR:             ports/164566
Submitted by:   "Mikhail T." <m.tsatsenko@gmail.com>
Feature safe:   yes

In the rc.d scripts, change assignments to rcvar to use the
literal name_enable wherever possible, and ${name}_enable
when it's not, to prepare for the demise of set_rcvar().

In cases where I had to hand-edit unusual instances also
modify formatting slightly to be more uniform (and in
some cases, correct). This includes adding some $FreeBSD$
tags, and most importantly moving rcvar= to right after
name= so it's clear that one is derived from the other.

Update to 1.4.2

Changes:        http://pgfoundry.org/frs/shownotes.php?release_id=1863
PR:             ports/158657
Submitted by:   "Mikhail T." <m.tsatsenko@gmail.com>

Update to 1.4.1

Changes:        http://pgfoundry.org/frs/shownotes.php?release_id=1795
PR:             ports/157702
Submitted by:   mm

- Update to 1.4
- Fix lib/usual/endian.h
- Modify rc file - allow setting a custom configuration file

PR:             ports/153932
Approved by:    skv@FreeBSD.org (maintainer, private e-mail)
Feature safe:   yes

- Update to 1.3.4

PR:             ports/150518
Approved by:    maintainer (timeout)

Update libevent to 1.4.14b

PR:             ports/147723
Approved by:    maintainer (timeout)

Update to 1.3.3

Changes:        http://pgfoundry.org/frs/shownotes.php?release_id=1645

Begin the process of deprecating sysutils/rc_subr by
s#. %%RC_SUBR%%#. /etc/rc.subr#

Update to 1.3.2

Changes:        http://pgfoundry.org/frs/shownotes.php?release_id=1605

- Update to 1.3.1

PR:     ports/137290
Submitted by:   ismail yenigul <ismail.yenigul@endersys.com>
Approved by:    maintainer (implicit)

Fix a few "bad example" problems in the rc.d scripts that have been
propogated by copy and paste.

1. Primarily the "empty variable" default assignment, which is mostly
${name}_flags="", but fix a few others as well.
2. Where they are not already documented, add the existence of the _flags
(or other deleted empties) option to the comments, and in some cases add
comments from scratch.
3. Replace things that look like:
prefix=%%PREFIX%%
command=${prefix}/sbin/foo
to just use %%PREFIX%%. In many cases the $prefix variable is only used
once, and in some cases it is not used at all.
4. In a few cases remove ${name}_flags from command_args
5. Remove a long-stale comment about putting the port's rc.d script in
/etc/rc.d (which is no longer necessary).

No PORTREVISION bumps because all of these changes are noops.

Update to 1.3

Changes:        http://pgfoundry.org/frs/shownotes.php?release_id=1315
PR:             ports/132003
Submitted by:   mm

- Update libevent dependency and bump PORTREVISION

- Update pgbouncer to 1.2.3
- Add new UID and GID for pgbouncer
- Improve handling of example configuration files
- Add support for the reload rc command
- Other minor enhancements

PR:             ports/126454
Submitted by:   mm
Approved by:    skv (maintainer)

- Bump PORTREVISION since devel/libevent are updated.

Update to 1.1.2

PR:             ports/117639
Submitted by:   Vivek Khera <vivek xx khera.org>

- Change libevent lib and bump PORTREVISION since devel/libevent are updated.

Add pgbouncer 1.0.8, lightweight connection pooler for PostgreSQL.