databases/pgadmin3: remove version requirements for pgsql

Supports all supported versions of PostgreSQL

databases/pgadmin3: change upstream and get maintainership

* Change upstream to pgadmin3-lts (based on BigSQL fork of the original
pgAdmin3) with support for modern PostreSQL
* Get maintainership
* While here sort out Makefile

PR:	265294

*/*: Remove pointers to EOLed pgsql versions

- Remove dotted pgsql versions

Approved by:	portmgr

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/pgadmin3: unbreak build (+)

Adjust condition to apply keywords patch, PgSQL 13.7 release is not switched to
the new scheme yet.

Thanks to amdmi3 to catch this.

databases/pgadmin3: mark BROKEN

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/pgadmin3: unbreak build with PgSQL 13+

PR:	264306
MFH:	2022Q3

textproc/libxml2: bump all LIB_DEPENDS consumers

This is a separate commit to facilitate easier cherry-picking for
quarterly.

PR: 262853, 262940, 262877, 263126
Approved by: fluffy (mentor)

textproc/libxml2: bump all dependencies

This should make sure that all dependent ports will pick
up the new version commited with a13ec21cd733f67a9fc0dc00ab45268bdc236246

all: return fjoe's ports to the pool

fjoe's ports bit got safekept.

INSTALLS_ICONS: retire the macro and rework the related dependencies

While here, make sure gtk-update-icon-cache is only on run dependency
where added as a dependency
Enforce gtk3 to depend on gtk-update-icon-cache (previously it was
inheriting the dependency)

x11-toolkits/wxgtk31: Update 3.1.4 -> 3.1.5

Bump 43 ports that either depend on wxgtk31 or potentially depend on it.

Reported by: portscout

Remove # $FreeBSD$ from Makefiles.

x11-toolkits/wxgtk30: Update to 3.0.5.1

Changelog:
  -
https://raw.githubusercontent.com/wxWidgets/wxWidgets/v3.0.5/docs/changes.txt

PR:	 246218
Approved by:	tcberner (mentor)
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D24808

- Add support for PostgreSQL 10 [1]
- Add support for PostgreSQL 11 [2]
- Fix query tool window crash [2]
- Bump PORTREVISION

PR:		236572, 238135
Submitted by:	kirill@ironlogic.ru [2]
Obtained from:	Debian [1]

databases: Add missing USES={gnome,php}

databases/pgadmin3: unbreak with clang 9

ld: error: utils/sshTunnel.o: unable to find library from dependent library
specifier: Ws2_32.lib

Reported by:	antoine (via bug 240629 exp-run)
Regressed by:	https://reviews.llvm.org/rL360984

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

wxGTK3.0: switch to gtk3 and webkit2

Discussed with:	portmgr

- Fix build with OpenSSL 1.1

PR:		232375

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

- Update to 1.22.2
- Add explicit missing dependency on SSL
- Fix portlint warnings

PR:		231454, 225953
Submitted by:	Rainer Hurling, Bernard Spil

Bump PORTREVISION for ports depending on the canonical version of GCC
in the ports tree (via Mk/bsd.default-versions.mk and lang/gcc) which
has now moved from GCC 6 to GCC 7 by default.

This includes ports
 - featuring USE_GCC=yes or USE_GCC=any,
 - featuring USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and those
 - with USES=compiler specifying one of openmp, nestedfct, c11, c++0x,
   c++11-lib, c++11-lang, c++14-lang, c++17-lang, or gcc-c++11-lib.

PR:		222542

databases/pgadmin3: Correct the mistake in wxrc substitution

${WXRC_CMD} is what should be used to make it compatible with
future wxWidgets versions.

While here, change WWW to https.

Approved by:	portmgr blanket

Bump PORTREVISION for ports depending on the canonical version of GCC
(via Mk/bsd.default-versions.mk and lang/gcc) which has moved from
GCC 5.4 to GCC 6.4 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, c++11-lib, c++11-lang,
   c++14-lang, c++0x, c11, or gcc-c++11-lib.

PR:		219275

Bump PORTREVISIONs for ports depending on the canonical version of GCC and
lang/gcc which have moved from GCC 4.9.4 to GCC 5.4 (at least under some
circumstances such as versions of FreeBSD or platforms).

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using using Mk/bsd.octave.mk which in turn has USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c++11-lib, c++14-lang,
   c++11-lang, c++0x, c11, or gcc-c++11-lib.

PR:		216707

- Use INSTALLS_ICONS=yes
- Bump PORTREVISION

PR:		213024

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

With hat:	portmgr
Sponsored by:	Absolight

Unbreak on FreeBSD 9.

- Switch to wxWidgets 3.0.
- Bump PORTREVISION.

- Install pgadmin3.desktop desktop entry and icons
(16x16 and 32x32 that are present in src tarball)
- Bump PORTREVISION to reflect package changes.

PR:		207399
Submitted by:	Dmitri Goutnik

Update to 1.22.1

PR:		206340

Remove ansi version fo wxGTK 2.8 and only keep the unicode version

All applications in the ports tree works correctly with unicode version of wxGTK

Newer version of wxGTK are unicode only (3.0+)

Note that now WX_UNICODE macro is noop

While pgsql:9.0+ is broken somehow, pgsql alone is needed here.

Sponsored by:	Absolight

Revert to IGNORE_WITH_PGSQL until
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=200569
is fixed (otherwise the build breaks if non-default postgresql-client is
installed).

Update to 1.20.0

PR:		200536
Submitted by:	Rainer Hurling

MASTER_SITES cleanup.

- Replace ${MASTER_SITE_FOO} with FOO.
- Merge MASTER_SITE_SUBDIR into MASTER_SITES when possible. (This means 99.9%
  of the time.)
- Remove occurrences of MASTER_SITE_LOCAL when no subdirectory was present and
  no hint of what it should be was present.
- Fix some logic.
- And generally, make things more simple and easy to understand.

While there, add magic values to the FESTIVAL, GENTOO, GIMP, GNUPG, QT and
SAMBA macros.

Also, replace some EXTRACT_SUFX occurences with USES=tar:*.

Checked by:	make fetch-urlall-list
With hat:	portmgr
Sponsored by:	Absolight

Update the default version of GCC in the Ports Collection from GCC 4.7.4
to GCC 4.8.3.

Part II, Bump PORTREVISIONs.

PR:		192025
Tested by:	antoine (-exp runs)
Approved by:	portmgr (implicit)

Support LIBS like LDFLAGS.

- Add LIBS="${LIBS}" to MAKE_ENV and CONFIGURE_ENV.
- Add an option helper for LIBS.
- Adjust all ports that already use LIBS.  Also remove references to
  PTHREAD_CFLAGS and PTHREAD_LIBS while here.
- Some ports did not support having a LIBS environment variable and
  required additional patches.

Somewhat simplified a linker command line looks like:

${CC} ${src_LDFLAGS} ${LDFLAGS} ${src_LIBS} ${LIBS}

where src_LDFLAGS and src_LIBS are controlled by upstream and LDFLAGS and
LIBS can be controlled by us.  If possible -L and -l flags need to be

Convert to USES=pgsql

While here:
- stage support for pg_rman
- stage support for pgagent
- stage support for hashtypes

The FreeBSD x11@ and graphics team proudly presents
a zeising, kwm production, with help from dumbbell, bdrewery:

NEW XORG ON FREEBSD 9-STABLE AND 10-STABLE

This update switches over to use the new xorg stack by default on FreeBSD 9
and 10 stable, on osversions where vt(9) is available.
It is still possible to use the old stack by specifying WITHOUT_NEW_XORG in
/etc/make.conf .
FreeBSD 8-STABLE and released versions of FreeBSD still use
the old version.
A package repository with binary packages for new xorg will
be available soon.

This patch also contains updates of libxcb and related ports, pixman, as well

Fix installation.

PR:		185006, 185068

- Update to 1.18.1 [1]
- Convert to stage

PR:		184049 [1]
Submitted by:	Marc Peters

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

- Remove MAKE_JOBS_SAFE variable

Approved by:	portmgr (bdrewery)

- Update to 1.16.1
- Enable database designer

PR:		179075
Submitted by:	Rainer Hurling

- Convert USE_GETTEXT to USES (part 3)

Approved by:	portmgr (bapt)

- Build and install docs
- Bump PORTREVISION

Feature safe:	yes

Do not build documentation, even if sphinx-build is installed.

- Update to 1.16.0
- Remove pkg-plist

PR:		171696
Submitted by:	nemysis (partially)

- update png to 1.5.10

Update to 1.14.2

PR:             166516
Submitted by:   Douglas Carmichael
Feature safe:   yes

Rename to match actual patched file name (which was moved since original PR
was filed).

- update to latest stable release (1.14.0)
- remove CONFLICTS (it's now conflicts with itself :)), because we have no
another versions of pgadmin3 in the tree anymore
- update IGNORE_WITH_PGSQL - we doesn't have any of them < 82
- remove DEFAULT_PGSQL_VER. It's ok to use ports tree default (84),
because according to INSTALL file it now needs 8.4+ for building
- hold distfile in distfiles/postgresql
- remove WX_CONF_ARGS to avoid this warning:
configure: WARNING: unrecognized options: --with-wx-config
- add 'PostGIS Shapefile and DBF loader' menu item [2]

PR:             161952
Submitted by:   Ruslan Mahmatkhanov
PR:             158599 [2]
Submitted by:   Rainer Hurling

- Add LDFLAGS to CONFIGURE_ENV and MAKE_ENV (as it was done with LDFLAGS)
- Fix all ports that add {CPP,LD}FLAGS to *_ENV to modify flags instead

PR:             157936
Submitted by:   myself
Exp-runs by:    pav
Approved by:    pav

- Get Rid MD5 support

Update to 1.12.0.

This port still does not build if ports/security/krb5 port is installed
but I commit it to provide PostgreSQL 9.0 support for users that
do not have Kerberos port installed as I do not have spare time right now
to sort out those problems.

PR:             150902

Bounce PORTREVISION for gettext-related ports.  Have fun, ya'll.

- update to 1.4.1
Reviewed by:    exp8 run on pointyhat
Supported by:   miwi

- update to jpeg-8

This port now requires postgresql-client >= 8.3

Update to 1.10.1

Fix pgsql console plugin launch.

Submitted by:   Juergen Lock

Update to 1.10.0.

- bump all port that indirectly depends on libjpeg and have not yet been bumped
or updated
Requested by:   edwin

- Remove conditional checks relevant only on FreeBSD 5.x and older

Update CONFIGURE_ARGS for how we pass CONFIGURE_TARGET to configure script.
Specifically, newer autoconf (> 2.13) has different semantic of the
configure target. In short, one should use --build=CONFIGURE_TARGET
instead of CONFIGURE_TARGET directly. Otherwise, you will get a warning
and the old semantic may be removed in later autoconf releases.

To workaround this issue, many ports hack the CONFIGURE_TARGET variable
so that it contains the ``--build='' prefix.

To solve this issue, under the fact that some ports still have
configure script generated by the old autoconf, we use runtime detection
in the do-configure target so that the proper argument can be used.

Changes to Mk/*:
 - Add runtime detection magic in bsd.port.mk

Update to 1.8.4

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)

Fix ${OSVERSION} condition.

Pointed out by: Gergely CZUCZY

Update to 1.8.0.

Update to 1.6.3

- Update to 1.6.2.
- Respect CFLAGS.

Submitted by:   acm

- Update to 1.6.2.
- Respect CFLAGS.

Submitted by:   acm

Previous commit was actually commit for PR 106356.

Update to 1.6.1.

PR:             105156
Submitted by:   Robert Gogolok

Mark as ignored with postgresql-client74. Needs 8.0+.

Remove post-install section.

Update to 1.6.0.

- Use features of bsd.wx.mk, especially USE_WX

PR:             ports/101613
Submitted by:   alepulver

Update to 1.4.3.

PR:             102038
Submitted by:   Robert Gogolok

Use bsd.wx.mk.

Change all bogus uses of BROKEN to IGNORE.  See CHANGES 20060705.

PR:             ports/92445
Hat:            portmgr

Fix some portlint -A errors.

PR:             97353 (partially)
Submitted by:   Martin Wilke

Remove USE_REINPLACE from all categories starting with D

Update to 1.4.2

Update to 1.4.1.

- Update to 1.4.0.

This version no longer support FreeBSD 4.x (requires wchar_t support).
Use pgadmin3-12 port for FreeBSD < 5.0.

Bump PORTREVISION to chase the glib20 shared library update.

Update to 1.2.2.

PR:             86990

s/older/newer/

Submitted by:   Palle Girgensohn

- Fix build with wxgtk 2.6.0
- Bump PORTREVISION

Submitted by:   Yuri Bushmelev

Finish repo-move of wxgtk2*-devel ports to wxgtk26* and update to the
latest stable release wxWidgets 2.6.0.

Bump PORTREVISION to chase the glib20 shared lib version change.

Document that __FreeBSD_version 503105 is ok for unicode-enabled build.

- Fix build on 4.x: non-unicode version does not have pkg-message.
- Bump PORTREVISION.

- Provide a patch that allows to build working non-Unicode version.
- Add back 4.x support (non-Unicode version only).
- Bump PORTREVISION.

- Unbreak.
- Remove ability to build non-unicode version which is not supported by pgadmin3
developers.
- Bump PORTREVISION.