Remove expired ports:

2020-03-29 security/w3af: Uses deprecated version of Python
2020-03-30 sysutils/duplicity-devel: Obsolete now, use sysutils/duplicity
instead
2020-03-31 net-mgmt/tornova: Use EOL'd Python 2.7
2020-03-31 audio/py-ogg: Unmaintained, uses EOLed python27
2020-03-31 net-mgmt/onionlauncher: Use EOL'd Python 2.7
2020-03-31 databases/mongodb34: EOL January 2020; See
https://www.mongodb.com/support-policy
2020-03-31 graphics/sane-frontends: Unmaintained upstream, no consumers left
2020-03-31 lang/ruby24: Move to a new version (lang/ruby26 or above). Ruby 2.4
is in security maintenance phase and planned for EOL on March 31, 2020
2020-03-31 databases/pgpool: Reached EOL at 2019-10-31, please use pgpool-II-35
or higher
2020-03-31 net/pygopherd: Unmaintained, uses EOLed python27
databases/mongodb34-tools: Part of expired MongoDB 3.4

databases/pgpool: Update from 3.4.25 to 3.4.26 and deprecated the port

Enhancements

    * Import some of memory manager debug facilities from PostgreSQL. (Tatsuo
Ishii)

    * Use pg_get_expr() instead of pg_attrdef.adsrc to support for PostgreSQL
12. (Bo Peng)

    * Enhance shutdown script of pgpool_setup. (Tatsuo Ishii)

        * Make shutdownall to wait for completion of shutdown of Pgpool-II.

        * If environment variable CHECK_TIME_WAIT is set to true, use netstat
command to confirm usage of the TCP/IP port while executing shutdown script.

    * Deal pgpool_adm extension with PostgreSQL 12. (Tatsuo Ishii)

databases/pgpool: Update from 3.4.24 to 3.4.25

Changelog:

    Enhancements:
    - Import some of memory manager debug facilities from PostgreSQL. (Tatsuo
Ishii)
    - Use pg_get_expr() instead of pg_attrdef.adsrc to support for PostgreSQL
12. (Bo Peng)
    - Enhance shutdown script of pgpool_setup. (Tatsuo Ishii)
        - Make shutdownall to wait for completion of shutdown of Pgpool-II.
        - If environment variable CHECK_TIME_WAIT is set to true, use netstat
command to confirm usage of the TCP/IP port while executing shutdown script.
    - Deal pgpool_adm extension with PostgreSQL 12. (Tatsuo Ishii)

    Bug fixes:
    - Fix pgpool_setup to produce correct follow master command. (Tatsuo Ishii)
    - Fix query cache module so that it checks oid array's bound. (Tatsuo Ishii)
    - Fix off-by-one error in query cache module. (Tatsuo Ishii)
    - Fix segfault when samenet is specified in pool_hba.conf. (Tatsuo Ishii)
    - Fix to deal with backslashes according to the config of
standard_conforming_strings in native replication mode. (bug 467) (Bo Peng)
    - Fix memory leaks. (Tatsuo Ishii)

MFH:		2019Q3

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

Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330

databases/pgpool: Upgrade from 3.4.23 to 3.4.24

Changelog:

  Enhancements

    - Speed up failover when all of backends are down. (Tatsuo Ishii)
    - pgpool-recovery extension and pgpool_setup is now ready for the next major
release PostgreSQL 12. (Tatsuo Ishii)

  Bug fixes

    - Fix the wrong error message "ERROR: connection cache is full", when all
backend nodes are down. (bug 487) (Bo Peng)
    - Avoid exit/fork storm of pool_worker_child process. (Tatsuo Ishii)
    - Fix black_function_list's broken default value. (Tatsuo Ishii)
    - Fix "not enough space in buffer" error. (bug 499) (Tatsuo Ishii)
    - The error occurred while processing error message returned from backend
and the cause is that the query string in question is too big. Problem is, the
buffer is in fixed size (8192 bytes). Eliminate the fixed size buffer and use
palloced buffer instead. This also saves some memory copy work.
    - Fix DROP DATABASE failure. (Tatsuo Ishii)
    - Fix wrong variable in read_status_file() function. (bug 493) (Takuma
Hoshiai)
    - Fix compiler warnings. (Tatsuo Ishii)

Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-3-4-24.html

databases/pgpool: Update from 3.4.22 to 3.4.23

Changelog:

Enhancements

    * Add new configuration option ssl_prefer_server_ciphers. (Muhammad Usama)

      Add the new setting ssl_prefer_server_ciphers to let users configure if
they want client's or server's cipher order to take preference.

      The default for this parameter is off, which prioritize the client's
cipher order as usual. However this is just for keeping backward compatibility,
and it is possible that a malicious client uses weak ciphers. For this reason we
recommend to set this parameter to on at all times.

    * Allow to set a client cipher list. (Tatsuo Ishii)

      For this purpose new parameter ssl_ciphers, which specifies the cipher
list to be accepted by Pgpool-II, is added. This is already implemented in
PostgreSQL and useful to enhance security when SSL is enabled.

Bug fixes

    * Fix unnecessary fsync() to pgpool_status file. (Tatsuo Ishii)

      Whenever new connections are created to PostgreSQL backend, fsync() was
issued to pgpool_status file, which could generate excessive I/O in certain
conditions. So reduce the chance of issuing fsync() so that it is issued only
when backend status is changed.

Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-3-4-23.html

MFH:		2019Q2

databases/pgpool: Upgrade from 3.4.21 to 3.4.22

Changelog:
- Doc: Fix configuration change timing regarding memory_cache_enabled.
- Fix online recovery failed due to client_idle_limit_in_recovery in certain
cases. (bug 431)
- Fix corner case bug when strip_quote() handle a empty query string. (bug 458)
- Fix Pgpool child segfault if failover occurs when trying to establish a
connection.
- Fix Pgpool-II hang when idle_in_transaction_session_timeout = on.

MFH:		2019Q1

Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590

databases/pgpool: Upgrade from 3.4.20 to 3.4.21

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-21.html

databases/pgpool-II-* build fine with OpenSSL 1.1.1 too

http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-3.4.20.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II35-3.5.17.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II36-3.6.13.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II37-3.7.6.log

Fix WWW

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH

Update to 3.4.20

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-20.html

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH

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

databases/pgpool: Update from 3.4.18 to 3.4.19

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-19.html

databases/pgpool: Update from 3.4.17 to 3.4.18

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-18.html

databases/pgpool: Update from 3.4.16 to 3.4.17

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-17.html

databases/pgpool: Upgrade from 3.4.11 to 3.4.16

Changelogs:
- http://www.pgpool.net/docs/latest/en/html/release-3-4-12.html
- http://www.pgpool.net/docs/latest/en/html/release-3-4-13.html
- http://www.pgpool.net/docs/latest/en/html/release-3-4-14.html
- http://www.pgpool.net/docs/latest/en/html/release-3-4-15.html
- http://www.pgpool.net/docs/latest/en/html/release-3-4-16.html

BROKEN_SSL: Add REASON for breakage

Reported by:	matwq

security/openssl-devel: Mark broken databases cat

databases/pgpool: Limit PORTSCOUT to 3.4.x

Future pgpool version of 3.5 and 3.6 will get an own port,
therefore limiting the PORTSCOUT check to actual branch

PR: 206839

databases/pgpool: Update from 3.4.9 to 3.4.11

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-10.html
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-11.html

PR: 206839

Remove all _USE=openssl occurrences.

Sponsored by:	Absolight

databases/pgpool: Add options DOCS and SSL

Reintegrate DOCS and SSL options already used in previous
versions in the ports-tree.

Submitted by: Adam Schumacher <adam.schumacher@flightaware.com>

databases/pgpool: Update from 3.4.3 to 3.4.9

Changelog: http://www.pgpool.net/docs/pgpool-II-3.4.8/NEWS.txt
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-9.html

PR:           206839
Submitted by: Felix Hanley <felix@userspace.com.au>

Change MAINTAINER from ports@toco-domains.de to tz@FreeBSD.org

Approved by:	junovitch (mentor)

- Add forgotten pkg-message

PR:		203769
Submitted by:	ports@toco-domains.de

- Update to 3.4.3
- Pass maintainership to submitter
- Update MASTERSITE and www
- Strip library

PR:		203769
Submitted by:	ports@toco-domains.de

The pgpool license is actually an old minimal variant of the MIT license

Submitted by:	antoine

Update "BSD" licenses in databases category

Cleanup plist

Nuke NOPORTDOCS. While, here, correct a couple offenders who label examples
with PORTDOCS. And, fix a couple WITH_foo invocations.

Stagify.

Approved by:	portmgr@

Remove indefinite articles and trailing periods from COMMENT, plus
minor COMMENT typos and surrounding whitespace fixes. Categories D-F.

CR:		D196
Approved by:	portmgr (bapt)

- Convert gmake, bzip to USES

Approved by:	portmgr

Fix properties on pkg-plist

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

Style: tab -> space.

Most contributors copy an existing port when writing their own so reduce the
number of bad examples in the tree.

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.

- Get Rid MD5 support

- Upgrade to 3.0 after repocopied to pgpool-II-23.

PR:             ports/150907
Submitted by:   Mikhail Tsatsenko <m.tsatsenko@mail.ru>

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

- Fix plist

Pointy hat to:  nork

Fix MASTER_SITES.

Pointy hat to:  myself

Mark BROKEN: size mismatch.

Update to 3.4.1.

- Add pgpool-II 1.0.2 after repocopy from databases/pgpool.

Fix build on 4.x.

Obtained from:  PostgreSQL Japanese Mailing List

Update to 3.2.

- Update to 3.1.2

PR:             ports/106668
Submitted by:   Robert Gogolok<gogo@cs.uni-sb.de>
Approved by:    maintainer

Reset whitekid@gmail.com after timeouts and no response to email.

Hat:            portmgr

- Update to 3.1.1

PR:             ports/100788
Submitted by:   Robert Gogolok <gogo(at)cs.uni-sb.de>
Approved by:    krion (mentor), maintainer timeout

- Update to version 3.1.

PR:             ports/100125
Submitted by:   Robert Gogolok <gogo_AT_cs dot uni-sb dot de>
Approved by:    maintainer (Choe, Cheng-Dae)

Update to 3.0.1.
Run as 'nobody' rather than root.

PR:             ports/96637
Submitted by:   Vivek Khera <vivek@khera.org>
Approved by:    Choe, Cheng-Dae <whitekid@gmail.com> (maintainer)

- Add rc.d script.
- Bump PORTREVISION

PR:             94137
Submitted by:   Chris St Denis <chris___ctgameinfo.com>
Approved by:    maintainer timeout, 39 days

SHA256ify

Approved by:    krion@

pgpool is a connection pool server for PostgreSQL. pgpool runs between
PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL client can
connect to pgpool as if it were a standard PostgreSQL server.

pgpool caches the connection to PostgreSQL server to reduce the overhead to
establish the connection to it.

WWW:    http://pgpool.projects.postgresql.org/

PR:             87701
Submitted by:   Choe, Cheng-Dae <whitekid@gmail.com>