Remove deprecated ports:

2020-08-15 archivers/py-backports.lzma: Uses deprecated version of python
2020-08-15 archivers/py-bup: Uses deprecated version of python
2020-08-15 archivers/py-librtfcomp: Uses deprecated version of python
2020-08-15 audio/blop-lv2: Uses deprecated version of python
2020-08-15 audio/bs2b-lv2: Uses deprecated version of python
2020-08-15 audio/py-gmusicproxy: Uses deprecated version of python
2020-08-15 audio/py-karaoke: Uses deprecated version of python
2020-08-15 audio/py-openal: Uses deprecated version of python
2020-08-15 audio/py-py-jack: Uses deprecated version of python
2020-08-15 audio/py-xmms2: Uses deprecated version of python
2020-08-15 audio/triceratops-lv2: Uses deprecated version of python
2020-08-15 biology/py-biom-format: Uses deprecated version of python
2020-08-15 comms/py-bulksms: Uses deprecated version of python

Deprecate a few python 2.7 ports

With hat:	portmgr

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

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

Add PY_FLAVOR to Python module dependencies.

Sponsored by:	Absolight

databases/py-pyPgSQL: Unmark BROKEN, Update MAINTAINER

This port was marked BROKEN/DEPRECATED due to a corrupt patch file. Update the
patch source to fix the issue.  Update MAINTAINER at submitters request.

While here, level up ports / python port compliance:

- Strip shared libraries
- Use option helpers
- Use python autoplist
- Match upstream setup.py metadata (COMMENT)
- Use explicit/canonical python package dependencies
- Unmute INSTALL_* commands

PR:		228119
Submitted by:	Chris Hutchinson <portmaster bsdforge com>
Approved by:	koobs (python, maintainer)

Deprecate ports broken for more than 6 months

pyPgSQL doesn't build with python3

Mark as broken ports with invalid distfiles or no public distfiles

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

With hat:	portmgr
Sponsored by:	Absolight

Remove UNIQUENAME and LATEST_LINK.

UNIQUENAME was never unique, it was only used by USE_LDCONFIG and now,
we won't have conflicts there.

Use PKGBASE instead of LATEST_LINK in PKGLATESTFILE, the *only* consumer
is pkg-devel, and it works just fine without LATEST_LINK as pkg-devel
has the correct PKGNAME anyway.

Now that UNIQUENAME is gone, OPTIONSFILE is too. (it's been called
OPTIONS_FILE now.)

Reviewed by:	antoine, bapt
Exp-run by:	antoine
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D3336

Cleanup plist

Convert to USES=pgsql and USES=python

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)

- Enable stagedir support

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

Convert last python@ ports to new options framework
for both make options work as expected (previous version were missing include
<bsd.port.options.mk>)
for databases/py-pyPgSQL reverse the logic for the option test so that it
actually works as expected

Approved by:	python (crees)

- remove maintainer tags from pkg-descr

Approved by:    portmgr
Approved by:    bapt (mentor)

- Get Rid MD5 support

PostgreSQL 8.3.1 has changed it's bytea encoding.

* in PostgreSQL 8.3.1 Release note
Make encode(bytea, 'escape') convert all high-bit-set byte values into \nnn
octal escape sequences (Tom)

This is necessary to avoid encoding problems when the database encoding is
multi-byte. This change could pose compatibility issues for applications that
are expecting specific results from encode.

but pyPgSQL escape bytea encode as it's own implementments. PostgreSQL says that
it may make failure(see PQescapeBytea documentation).

in PQescapeBytea function documentation:
"The only difference from PQescapeByteaConn is that PQescapeBytea does not take
a PGconn parameter. Because of this, it cannot adjust its behavior depending on
the connection properties (in particular, whether standard-conforming strings
are enabled) and therefore it might give the wrong results. Also, it has no way
to return an error message on failure."

Patch is included upstream already

PR:             ports/122616
Submitted by:   "Choe, Cheng-Dae" <whitekid@gmail.com>

- Switch SourceForge ports to the new File Release System: categories starting
with D

Bump portrevision due to upgrade of devel/gettext.

The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).

PR:             ports/124340
Submitted by:   edwin@
Approved by:    portmgr (pav)

- EXAMPLES should be omitted when NOPORTEXAMPLES is defined

Noticed by:     sat

- Honour PKGNAMEPREFIX [1]
- Use DOCSDIR, EXAMPLESDIR in pkg-plist
- Things under EXAMPLESDIR should not be controlled by NOPORTDOCS
- Minor fix to pet portlint(1)
- Grab maintainership for python@
- Bump PORTREVISION

PR:             ports/113876 [1]
Submitted by:   Greg Skafte <skafte AT trollkarl.net>

- Update to 2.5.1

Approved by:    delphij (mentor, implicit)

- Add SHA256

Reset maintainer on request. Thanks to Gerhard for maintaining the
ports so far!

PR:             ports/78088

Split the postgresql ports into a server and a client part.

All ports depending on postgresql shall use the USE_PGSQL=yes knob
defined in Mk/bsd.ports.mk. Bumping portrevisions where needed.

PR:             75344
Approved by:    portmgr@ (kris), ade & sean (mentors)

SIZEify (maintainer timeout)

Bump PORTREVISION on all ports that depend on gettext to aid with upgrading.

(Part 2)

update databases/py-pyPgSQL: 2.3 -> 2.4

PR:             55084
Submitted by:   Gerhard Haering <gh@ghaering.de>

De-pkg-comment.

Missed configure scripts in libpq version bump: chase lib version.

upgrade to 2.3

PR:             46099
Submitted by:   maintainer

Respect LOCALBASE and remove py-mx-base as a build dependency.
Use tab in place of whitespace as well.

PR:             ports/43570
Submitted by:   maintainer

- update port to pyPgSQL 2.2
- updated maintainer email address
- use REINPLACE instead of PERL

PR:             42560
Submitted by:   maintainer

Update to 2.1

--
also make a cosmetic change
space -> tabs
INSTALL_MAN -> INSTALL_DATA for installing port docs
perl -> ${PERL}

PR:             39051
Submitted by:   maintainer

use USE_PYDISTUTILS

Update to work with PostgreSQL 7.2.

PR:             36102
Submitted by:   maintainer

Update of the py-pyPGSQL port to version 2.0.    

Add pyPgSQL, a Python DB-API 2 compliant library for using PostgreSQL  
databases