Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 15 Apr 2023 13:17:56 GMT
From:      Muhammad Moinur Rahman <bofh@FreeBSD.org>
To:        ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org
Subject:   git: a40c0e7d8311 - main - */*: Remove pointers to EOLed pgsql versions
Message-ID:  <202304151317.33FDHufS080021@gitrepo.freebsd.org>

next in thread | raw e-mail | index | archive | help
The branch main has been updated by bofh:

URL: https://cgit.FreeBSD.org/ports/commit/?id=a40c0e7d8311e72078684f0a7ee388966a6adaf9

commit a40c0e7d8311e72078684f0a7ee388966a6adaf9
Author:     Muhammad Moinur Rahman <bofh@FreeBSD.org>
AuthorDate: 2023-04-15 11:43:44 +0000
Commit:     Muhammad Moinur Rahman <bofh@FreeBSD.org>
CommitDate: 2023-04-15 13:14:58 +0000

    */*: Remove pointers to EOLed pgsql versions
    
    - Remove dotted pgsql versions
    
    Approved by:    portmgr
---
 Mk/Uses/pgsql.mk                         | 12 ++++++------
 databases/lua-pgsql/Makefile             |  2 +-
 databases/pg_ed25519/Makefile            |  2 +-
 databases/pg_hashids/Makefile            |  2 +-
 databases/pg_partman/Makefile            | 14 ++------------
 databases/pg_partman/pkg-plist           |  8 ++++----
 databases/pg_qualstats/Makefile          |  2 +-
 databases/pg_repack/Makefile             |  2 +-
 databases/pg_similarity/Makefile         |  2 +-
 databases/pg_stat_kcache/Makefile        |  2 +-
 databases/pgadmin3/Makefile              |  2 +-
 databases/pgpool-II-40/Makefile          |  2 +-
 databases/pgpool-II-41/Makefile          |  2 +-
 databases/pgpool-II-42/Makefile          |  2 +-
 databases/pgpool-II-43/Makefile          |  2 +-
 databases/pgrouting/Makefile             |  2 +-
 databases/plpgsql_check/Makefile         |  2 +-
 databases/postgis30/Makefile             |  2 +-
 databases/postgis31/Makefile             |  2 +-
 databases/postgis32/Makefile             |  2 +-
 databases/postgis33/Makefile             |  2 +-
 databases/postgresql-cstore_fdw/Makefile |  2 +-
 databases/postgresql-mysql_fdw/Makefile  |  2 +-
 databases/postgresql-ogr_fdw/Makefile    |  2 +-
 databases/postgresql-orafce/Makefile     |  2 +-
 databases/postgresql-prefix/Makefile     |  2 +-
 databases/postgresql-rum/Makefile        |  2 +-
 databases/postgresql-tds_fdw/Makefile    |  2 +-
 databases/postgresql-zhparser/Makefile   |  2 +-
 databases/powa-archivist/Makefile        |  2 +-
 databases/py-aiopg/Makefile              |  2 +-
 databases/py-asyncpg/Makefile            |  2 +-
 databases/timescaledb/Makefile           |  2 +-
 devel/bugzilla50/Makefile                |  2 +-
 devel/root/Makefile                      |  2 +-
 net-mgmt/netmagis-common/Makefile        |  2 +-
 36 files changed, 45 insertions(+), 55 deletions(-)

diff --git a/Mk/Uses/pgsql.mk b/Mk/Uses/pgsql.mk
index b858792d8159..2755cf03649e 100644
--- a/Mk/Uses/pgsql.mk
+++ b/Mk/Uses/pgsql.mk
@@ -5,13 +5,13 @@
 #
 # version 	Maintainer can set versions required. You can set this to
 #		[min]-[max] or min+ or -max or as an explicit version
-#		(eg. 9.3-9.6 for [min]-[max], 9.5+ or 9.6-
-#		for min+ and max-, 9.4 for an explicit version). Example:
+#		(eg. 11-14 for [min]-[max], 11+ or 12-
+#		for min+ and max-, 13 for an explicit version). Example:
 #
-#		    USES=pgsql:9.4		# Only use PostgreSQL 9.4
-#		    USES=pgsql:9.3+		# Use PostgreSQL 9.3 or newer
-#		    USES=pgsql:9.3-9.6	# Use PostgreSQL between 9.3 & 9.6
-#		    USES=pgsql:9.6-		# Use any PostgreSQL up to 9.6
+#		    USES=pgsql:13		# Only use PostgreSQL 13
+#		    USES=pgsql:11+		# Use PostgreSQL 11 or newer
+#		    USES=pgsql:11-14	# Use PostgreSQL between 11 & 14 inclusive
+#		    USES=pgsql:12-		# Use any PostgreSQL up to 12
 #		    USES=pgsql		# Use the default PostgreSQL
 #
 #		WANT_PGSQL=	server[:fetch] plperl plpython pltcl
diff --git a/databases/lua-pgsql/Makefile b/databases/lua-pgsql/Makefile
index 147fadab6d31..0ea50700499e 100644
--- a/databases/lua-pgsql/Makefile
+++ b/databases/lua-pgsql/Makefile
@@ -9,7 +9,7 @@ WWW=		https://github.com/arcapos/luapgsql
 
 LICENSE=	BSD3CLAUSE
 
-USES=		lua pgsql:9.5+
+USES=		lua pgsql:11+
 WANT_PGSQL=	client
 
 USE_GITHUB=	yes
diff --git a/databases/pg_ed25519/Makefile b/databases/pg_ed25519/Makefile
index a840cc158884..fe16a38ee3a6 100644
--- a/databases/pg_ed25519/Makefile
+++ b/databases/pg_ed25519/Makefile
@@ -8,7 +8,7 @@ WWW=		https://gitlab.com/dwagin/pg_ed25519
 
 LICENSE=	MIT
 
-USES=		gmake pgsql:9.4+
+USES=		gmake pgsql:11+
 LLD_UNSAFE=	yes
 WANT_PGSQL=	server
 
diff --git a/databases/pg_hashids/Makefile b/databases/pg_hashids/Makefile
index a672de3b9c80..426cbd50a387 100644
--- a/databases/pg_hashids/Makefile
+++ b/databases/pg_hashids/Makefile
@@ -8,7 +8,7 @@ WWW=		https://github.com/iCyberon/pg_hashids
 
 LICENSE=	MIT
 
-USES=		gmake pgsql:9.6+
+USES=		gmake pgsql:11+
 WANT_PGSQL=	server
 
 USE_GITHUB=	yes
diff --git a/databases/pg_partman/Makefile b/databases/pg_partman/Makefile
index 59206390f658..32224873b7ec 100644
--- a/databases/pg_partman/Makefile
+++ b/databases/pg_partman/Makefile
@@ -12,7 +12,7 @@ LICENSE_FILE=	${WRKSRC}/LICENSE.txt
 
 RUN_DEPENDS=	${PYTHON_SITELIBDIR}/psycopg2/__init__.py:databases/py-psycopg2
 
-USES=		cpe gmake pgsql:9.4+ python uidfix shebangfix
+USES=		cpe gmake pgsql:11+ python uidfix shebangfix
 CPE_VENDOR=	pgxn
 
 USE_GITHUB=	yes
@@ -25,16 +25,6 @@ LLD_UNSAFE=	yes
 
 OPTIONS_DEFINE=	DOCS
 
-.include <bsd.port.pre.mk>
-
-# With PG11+ some scripts are only installed when they are common to
-# all PG versions.
-.if ${PGSQL_VER:R} < 11
-PLIST_SUB+=	OLDPG=""
-.else
-PLIST_SUB+=	OLDPG="@comment "
-.endif
-
 post-install:
 	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pg_partman_bgw.so
 
@@ -47,4 +37,4 @@ post-install-DOCS-on:
 post-install-DOCS-off:
 	${RM} -r ${STAGEDIR}${PREFIX}/share/doc/postgresql
 
-.include <bsd.port.post.mk>
+.include <bsd.port.mk>
diff --git a/databases/pg_partman/pkg-plist b/databases/pg_partman/pkg-plist
index 76c7d626b893..461344a04b92 100644
--- a/databases/pg_partman/pkg-plist
+++ b/databases/pg_partman/pkg-plist
@@ -1,10 +1,10 @@
 bin/check_unique_constraint.py
 bin/dump_partition.py
-%%OLDPG%%bin/partition_data.py
-%%OLDPG%%bin/reapply_constraints.py
-%%OLDPG%%bin/reapply_foreign_keys.py
+bin/partition_data.py
+bin/reapply_constraints.py
+bin/reapply_foreign_keys.py
 bin/reapply_indexes.py
-%%OLDPG%%bin/undo_partition.py
+bin/undo_partition.py
 bin/vacuum_maintenance.py
 lib/postgresql/pg_partman_bgw.so
 %%PORTDOCS%%%%DOCSDIR%%/migrate_to_native.md
diff --git a/databases/pg_qualstats/Makefile b/databases/pg_qualstats/Makefile
index 549eaaada573..e23a78781868 100644
--- a/databases/pg_qualstats/Makefile
+++ b/databases/pg_qualstats/Makefile
@@ -11,7 +11,7 @@ LICENSE=	PostgreSQL
 USE_GITHUB=	yes
 GH_ACCOUNT=	powa-team
 
-USES=		gmake pgsql:9.4+
+USES=		gmake pgsql:11+
 LLD_UNSAFE=	yes
 WANT_PGSQL=	server
 
diff --git a/databases/pg_repack/Makefile b/databases/pg_repack/Makefile
index 74c400b3e7cb..7bdbb3c4be9b 100644
--- a/databases/pg_repack/Makefile
+++ b/databases/pg_repack/Makefile
@@ -10,7 +10,7 @@ WWW=		https://github.com/reorg/pg_repack
 
 LICENSE=	BSD3CLAUSE
 
-USES=		gettext-runtime gmake pgsql:9.4+
+USES=		gettext-runtime gmake pgsql:11+
 LLD_UNSAFE=	yes
 USE_GITHUB=	yes
 GH_ACCOUNT=	reorg
diff --git a/databases/pg_similarity/Makefile b/databases/pg_similarity/Makefile
index 9eac01dd236d..e13b392657d0 100644
--- a/databases/pg_similarity/Makefile
+++ b/databases/pg_similarity/Makefile
@@ -10,7 +10,7 @@ WWW=		http://pgsimilarity.projects.pgfoundry.org
 
 LICENSE=	BSD3CLAUSE
 
-USES=		gmake pgsql:9.1+
+USES=		gmake pgsql:11+
 USE_GITHUB=	yes
 GH_ACCOUNT=	eulerto
 GH_TAGNAME=	be1a8b0
diff --git a/databases/pg_stat_kcache/Makefile b/databases/pg_stat_kcache/Makefile
index 9efe2307539e..7c8880b0a950 100644
--- a/databases/pg_stat_kcache/Makefile
+++ b/databases/pg_stat_kcache/Makefile
@@ -9,7 +9,7 @@ WWW=		https://github.com/dalibo/pg_stat_kcache
 
 LICENSE=	PostgreSQL
 
-USES=		gmake pgsql:9.6+
+USES=		gmake pgsql:11+
 LLD_UNSAFE=	yes
 WANT_PGSQL=	server contrib
 
diff --git a/databases/pgadmin3/Makefile b/databases/pgadmin3/Makefile
index 64ca7039f014..0f0be75033d1 100644
--- a/databases/pgadmin3/Makefile
+++ b/databases/pgadmin3/Makefile
@@ -13,7 +13,7 @@ LICENSE=	PostgreSQL
 
 BUILD_DEPENDS=	sphinx-build:textproc/py-sphinx
 
-USES=		compiler:c++11-lib gettext gmake gnome pgsql:9.0+ ssl
+USES=		compiler:c++11-lib gettext gmake gnome pgsql:11+ ssl
 USE_GNOME=	libxml2 libxslt
 USE_WX=		3.0
 USE_CXXSTD=	c++11
diff --git a/databases/pgpool-II-40/Makefile b/databases/pgpool-II-40/Makefile
index 5cc3fa54ee99..24c2247598cd 100644
--- a/databases/pgpool-II-40/Makefile
+++ b/databases/pgpool-II-40/Makefile
@@ -11,7 +11,7 @@ WWW=		https://pgpool.net/
 LICENSE=	MIT
 LICENSE_FILE=	${WRKSRC}/COPYING
 
-USES=		gmake libtool pgsql:9.6+
+USES=		gmake libtool pgsql:11+
 USE_LDCONFIG=	yes
 USE_RC_SUBR=	pgpool
 
diff --git a/databases/pgpool-II-41/Makefile b/databases/pgpool-II-41/Makefile
index 6abd9e98558a..5fb5f66e6465 100644
--- a/databases/pgpool-II-41/Makefile
+++ b/databases/pgpool-II-41/Makefile
@@ -11,7 +11,7 @@ WWW=		https://pgpool.net/
 LICENSE=	MIT
 LICENSE_FILE=	${WRKSRC}/COPYING
 
-USES=		gmake libtool pgsql:9.6+
+USES=		gmake libtool pgsql:11+
 USE_LDCONFIG=	yes
 USE_RC_SUBR=	pgpool
 
diff --git a/databases/pgpool-II-42/Makefile b/databases/pgpool-II-42/Makefile
index 5d2bad365f93..cc5430ae67d3 100644
--- a/databases/pgpool-II-42/Makefile
+++ b/databases/pgpool-II-42/Makefile
@@ -13,7 +13,7 @@ LICENSE_FILE=	${WRKSRC}/COPYING
 
 PORTSCOUT=	limit:^4.2.[0-9]*
 
-USES=		gmake libtool pgsql:9.6+
+USES=		gmake libtool pgsql:11+
 USE_LDCONFIG=	yes
 USE_RC_SUBR=	pgpool
 
diff --git a/databases/pgpool-II-43/Makefile b/databases/pgpool-II-43/Makefile
index 0f4a068598b2..6b3f6d5eca37 100644
--- a/databases/pgpool-II-43/Makefile
+++ b/databases/pgpool-II-43/Makefile
@@ -11,7 +11,7 @@ WWW=		https://pgpool.net/
 LICENSE=	MIT
 LICENSE_FILE=	${WRKSRC}/COPYING
 
-USES=		gmake libtool pgsql:9.6+
+USES=		gmake libtool pgsql:11+
 USE_LDCONFIG=	yes
 USE_RC_SUBR=	pgpool
 
diff --git a/databases/pgrouting/Makefile b/databases/pgrouting/Makefile
index 483149cc4610..e6e2cd509cc4 100644
--- a/databases/pgrouting/Makefile
+++ b/databases/pgrouting/Makefile
@@ -13,7 +13,7 @@ LICENSE_FILE=	${WRKSRC}/LICENSE
 LIB_DEPENDS=	libboost_system.so:devel/boost-libs
 RUN_DEPENDS=	${LOCALBASE}/share/postgresql/extension/postgis.control:databases/postgis33
 
-USES=		compiler:c++14-lang cmake localbase perl5 pgsql:10+ pkgconfig
+USES=		compiler:c++14-lang cmake localbase perl5 pgsql:11+ pkgconfig
 WANT_PGSQL=	lib server
 USE_LDCONFIG=	yes
 USE_GITHUB=	yes
diff --git a/databases/plpgsql_check/Makefile b/databases/plpgsql_check/Makefile
index f3b2609d6a39..66af0a3b271c 100644
--- a/databases/plpgsql_check/Makefile
+++ b/databases/plpgsql_check/Makefile
@@ -13,7 +13,7 @@ LICENSE_NAME=	postcardware
 LICENSE_FILE=	${WRKSRC}/LICENSE
 LICENSE_PERMS=	auto-accept dist-mirror dist-sell pkg-mirror pkg-sell
 
-USES=		compiler:c11 gmake pgsql:10+
+USES=		compiler:c11 gmake pgsql:11+
 
 LLD_UNSAFE=	yes
 MAKE_ARGS=	CC="${CC}"
diff --git a/databases/postgis30/Makefile b/databases/postgis30/Makefile
index a605d2c24895..ac47536b0f94 100644
--- a/databases/postgis30/Makefile
+++ b/databases/postgis30/Makefile
@@ -18,7 +18,7 @@ LIB_DEPENDS=	libproj.so:graphics/proj \
 		libgdal.so:graphics/gdal
 
 USES=		alias compiler:c++11-lang cpe gmake gnome iconv:wchar_t libtool:keepla \
-		localbase perl5 pkgconfig pgsql:9.5+ shebangfix
+		localbase perl5 pkgconfig pgsql:11+ shebangfix
 USE_GNOME=	libxml2
 USE_PERL5=	build
 
diff --git a/databases/postgis31/Makefile b/databases/postgis31/Makefile
index 3df0fb4d32bb..f6952114c422 100644
--- a/databases/postgis31/Makefile
+++ b/databases/postgis31/Makefile
@@ -18,7 +18,7 @@ LIB_DEPENDS=	libproj.so:graphics/proj \
 		libgdal.so:graphics/gdal
 
 USES=		alias compiler:c++11-lang cpe gmake gnome iconv:wchar_t libtool:keepla \
-		localbase perl5 pkgconfig pgsql:9.5+ shebangfix
+		localbase perl5 pkgconfig pgsql:11+ shebangfix
 USE_GNOME=	libxml2
 USE_PERL5=	build
 
diff --git a/databases/postgis32/Makefile b/databases/postgis32/Makefile
index 8d807fea7c9d..a8bb727f18f4 100644
--- a/databases/postgis32/Makefile
+++ b/databases/postgis32/Makefile
@@ -18,7 +18,7 @@ LIB_DEPENDS=	libproj.so:graphics/proj \
 		libgdal.so:graphics/gdal
 
 USES=		alias compiler:c++11-lang cpe gmake gnome iconv:wchar_t libtool:keepla \
-		localbase perl5 pkgconfig pgsql:9.5+ shebangfix
+		localbase perl5 pkgconfig pgsql:11+ shebangfix
 USE_GNOME=	libxml2
 USE_PERL5=	build
 
diff --git a/databases/postgis33/Makefile b/databases/postgis33/Makefile
index 5c8e1debbba6..9aa9cd6b4e26 100644
--- a/databases/postgis33/Makefile
+++ b/databases/postgis33/Makefile
@@ -19,7 +19,7 @@ LIB_DEPENDS=	libproj.so:graphics/proj \
 		libpcre2-8.so:devel/pcre2
 
 USES=		alias compiler:c++11-lang cpe gmake gnome iconv:wchar_t libtool:keepla \
-		localbase perl5 pkgconfig pgsql:9.5+ shebangfix
+		localbase perl5 pkgconfig pgsql:11+ shebangfix
 USE_GNOME=	libxml2
 USE_PERL5=	build
 
diff --git a/databases/postgresql-cstore_fdw/Makefile b/databases/postgresql-cstore_fdw/Makefile
index b69dee1c8e37..1391bc387b8d 100644
--- a/databases/postgresql-cstore_fdw/Makefile
+++ b/databases/postgresql-cstore_fdw/Makefile
@@ -16,7 +16,7 @@ LICENSE_FILE=	${WRKSRC}/LICENSE
 
 LIB_DEPENDS=	libprotobuf-c.so:devel/protobuf-c
 
-USES=		gmake pgsql:9.3+
+USES=		gmake pgsql:11+
 
 SUB_FILES=	pkg-message
 
diff --git a/databases/postgresql-mysql_fdw/Makefile b/databases/postgresql-mysql_fdw/Makefile
index 93331056151d..30d005e44bb9 100644
--- a/databases/postgresql-mysql_fdw/Makefile
+++ b/databases/postgresql-mysql_fdw/Makefile
@@ -11,7 +11,7 @@ WWW=		https://github.com/EnterpriseDB/mysql_fdw
 LICENSE=	PostgreSQL
 LICENSE_FILE=	${WRKSRC}/LICENSE
 
-USES=		gmake mysql pgsql:10+
+USES=		gmake mysql pgsql:11+
 WANT_PGSQL=	server
 USE_GITHUB=	yes
 GH_ACCOUNT=	EnterpriseDB
diff --git a/databases/postgresql-ogr_fdw/Makefile b/databases/postgresql-ogr_fdw/Makefile
index f68273612e6b..dba46d15a085 100644
--- a/databases/postgresql-ogr_fdw/Makefile
+++ b/databases/postgresql-ogr_fdw/Makefile
@@ -13,7 +13,7 @@ LICENSE_FILE=	${WRKSRC}/LICENSE.md
 
 LIB_DEPENDS=	libgdal.so:graphics/gdal
 
-USES=		gmake pgsql:9.3+
+USES=		gmake pgsql:11+
 WANT_PGSQL=	server
 USE_GITHUB=	yes
 GH_ACCOUNT=	pramsey
diff --git a/databases/postgresql-orafce/Makefile b/databases/postgresql-orafce/Makefile
index f6ebb540f335..ce43b8087d25 100644
--- a/databases/postgresql-orafce/Makefile
+++ b/databases/postgresql-orafce/Makefile
@@ -13,7 +13,7 @@ LICENSE_NAME=	Zero-Clause BSD / Free Public License 1.0.0
 LICENSE_FILE=	${WRKSRC}/COPYRIGHT.orafce
 LICENSE_PERMS=	dist-mirror dist-sell pkg-mirror pkg-sell auto-accept
 
-USES=		gmake pgsql:9.5+
+USES=		gmake pgsql:11+
 USE_GITHUB=	yes
 LLD_UNSAFE=	yes
 
diff --git a/databases/postgresql-prefix/Makefile b/databases/postgresql-prefix/Makefile
index b5f03607e33f..6df4eb918570 100644
--- a/databases/postgresql-prefix/Makefile
+++ b/databases/postgresql-prefix/Makefile
@@ -10,7 +10,7 @@ WWW=		https://github.com/dimitri/prefix
 
 LICENSE=	PostgreSQL
 
-USES=		gmake pgsql:9.1+
+USES=		gmake pgsql:11+
 WANT_PGSQL=	server
 USE_GITHUB=	yes
 GH_ACCOUNT=	dimitri
diff --git a/databases/postgresql-rum/Makefile b/databases/postgresql-rum/Makefile
index 20f54afd1e95..c10ff224a6d5 100644
--- a/databases/postgresql-rum/Makefile
+++ b/databases/postgresql-rum/Makefile
@@ -10,7 +10,7 @@ WWW=		https://github.com/postgrespro/rum
 
 LICENSE=	PostgreSQL
 
-USES=		gmake pgsql:9.6+
+USES=		gmake pgsql:11+
 
 LLD_UNSAFE=	yes
 USE_GITHUB=	yes
diff --git a/databases/postgresql-tds_fdw/Makefile b/databases/postgresql-tds_fdw/Makefile
index 04a179add64d..8654640438e7 100644
--- a/databases/postgresql-tds_fdw/Makefile
+++ b/databases/postgresql-tds_fdw/Makefile
@@ -12,7 +12,7 @@ LICENSE=	PostgreSQL
 
 LIB_DEPENDS=	libsybdb.so:databases/freetds
 
-USES=		gmake pgsql:9.6+
+USES=		gmake pgsql:11+
 
 USE_GITHUB=	yes
 GH_ACCOUNT=	tds-fdw
diff --git a/databases/postgresql-zhparser/Makefile b/databases/postgresql-zhparser/Makefile
index 504faec02fcf..eee545b3af01 100644
--- a/databases/postgresql-zhparser/Makefile
+++ b/databases/postgresql-zhparser/Makefile
@@ -13,7 +13,7 @@ LICENSE=	PostgreSQL
 
 LIB_DEPENDS=	libscws.so:textproc/scws
 
-USES=		gmake pgsql:9.2+
+USES=		gmake pgsql:11+
 LLD_UNSAFE=	yes
 USE_GITHUB=	yes
 GH_ACCOUNT=	amutu
diff --git a/databases/powa-archivist/Makefile b/databases/powa-archivist/Makefile
index 98e38f82a909..b77cc8bb9730 100644
--- a/databases/powa-archivist/Makefile
+++ b/databases/powa-archivist/Makefile
@@ -15,7 +15,7 @@ RUN_DEPENDS=	${LOCALBASE}/lib/postgresql/pg_stat_kcache.so:databases/pg_stat_kca
 USE_GITHUB=	yes
 GH_ACCOUNT=	powa-team
 
-USES=		gmake pgsql:9.4+
+USES=		gmake pgsql:11+
 WANT_PGSQL=	server contrib
 
 pre-patch:
diff --git a/databases/py-aiopg/Makefile b/databases/py-aiopg/Makefile
index 8c5c824598ee..169e5f4a4bf6 100644
--- a/databases/py-aiopg/Makefile
+++ b/databases/py-aiopg/Makefile
@@ -14,7 +14,7 @@ LICENSE_FILE=	${WRKSRC}/LICENSE
 RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}psycopg2>=2.7.0:databases/py-psycopg2@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}async_timeout>=3.0.0:devel/py-async_timeout@${PY_FLAVOR}
 
-USES=		pgsql:9.2+ python:3.4+
+USES=		pgsql:11+ python:3.4+
 USE_PYTHON=	autoplist concurrent distutils
 NO_ARCH=	yes
 
diff --git a/databases/py-asyncpg/Makefile b/databases/py-asyncpg/Makefile
index d98680a3fdf1..229a6539f8e5 100644
--- a/databases/py-asyncpg/Makefile
+++ b/databases/py-asyncpg/Makefile
@@ -11,7 +11,7 @@ WWW=		https://github.com/MagicStack/asyncpg/
 LICENSE=	APACHE20
 LICENSE_FILE=	${WRKSRC}/LICENSE
 
-USES=		cpe pgsql:9.2+ python:3.6+
+USES=		cpe pgsql:11+ python:3.6+
 CPE_VENDOR=	magic
 USE_PYTHON=	autoplist concurrent cython distutils
 
diff --git a/databases/timescaledb/Makefile b/databases/timescaledb/Makefile
index 067d376974be..295254e90b6b 100644
--- a/databases/timescaledb/Makefile
+++ b/databases/timescaledb/Makefile
@@ -13,7 +13,7 @@ LICENSE_FILE_APACHE20=	${WRKSRC}/LICENSE-APACHE
 LICENSE_FILE_TSL=	${WRKSRC}/tsl/LICENSE-TIMESCALE
 LICENSE_PERMS_TSL=	dist-mirror pkg-mirror auto-accept
 
-USES=		compiler:c11 cmake gettext-runtime cpe pgsql:12,13,14,15
+USES=		compiler:c11 cmake gettext-runtime cpe pgsql:12-15
 
 USE_GITHUB=	YES
 GH_ACCOUNT=	timescale
diff --git a/devel/bugzilla50/Makefile b/devel/bugzilla50/Makefile
index d98749921708..dde7813709c2 100644
--- a/devel/bugzilla50/Makefile
+++ b/devel/bugzilla50/Makefile
@@ -49,7 +49,7 @@ EMPTY_DIRS_LIST=data graphs contrib lib t xt
 MODPERL_USES=		apache:run
 MYSQL_USES=		mysql
 MYSQL_RUN_DEPENDS=	p5-DBD-mysql>=4.0001:databases/p5-DBD-mysql
-PGSQL_USES=		pgsql:9.1+
+PGSQL_USES=		pgsql:11+
 PGSQL_RUN_DEPENDS=	p5-DBD-Pg>=3.4.2:databases/p5-DBD-Pg
 SQLITE_USES=		sqlite
 SQLITE_RUN_DEPENDS=	p5-DBD-SQLite>=1.29:databases/p5-DBD-SQLite \
diff --git a/devel/root/Makefile b/devel/root/Makefile
index 2f954fbc8a17..f4d8da59547c 100644
--- a/devel/root/Makefile
+++ b/devel/root/Makefile
@@ -35,7 +35,7 @@ LIB_DEPENDS=	libAfterImage.so:graphics/libafterimage \
 		libzstd.so:archivers/zstd
 
 USES=		blaslapack:openblas cmake compiler:c++17-lang desktop-file-utils \
-		gettext-runtime gl gnome iconv jpeg mysql:57 pgsql:13.0+ python:3.9+ \
+		gettext-runtime gl gnome iconv jpeg mysql:57 pgsql:13+ python:3.9+ \
 		shebangfix sqlite ssl xorg
 USE_GL=		glew glu opengl
 USE_GNOME=	cairo gdkpixbuf2 glib20 librsvg2 libxml2
diff --git a/net-mgmt/netmagis-common/Makefile b/net-mgmt/netmagis-common/Makefile
index 0e24ff8c6eb6..f685cf038738 100644
--- a/net-mgmt/netmagis-common/Makefile
+++ b/net-mgmt/netmagis-common/Makefile
@@ -17,7 +17,7 @@ LICENSE_PERMS=	dist-mirror dist-sell pkg-mirror pkg-sell auto-accept
 RUN_DEPENDS+=	dtplite:devel/tcllib
 
 NO_ARCH?=	yes
-USES+=		pgsql:9.1+ tcl
+USES+=		pgsql:11+ tcl
 WANT_PGSQL+=	pgtcl
 
 SLAVEDIRS=	net-mgmt/netmagis-common \



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?202304151317.33FDHufS080021>