2 files changed, 62 insertions, 0 deletions
diff --git a/dev-python/psycopg/Manifest b/dev-python/psycopg/Manifest
index b114acdfdc69..9231f0126230 100644
--- a/dev-python/psycopg/Manifest
+++ b/dev-python/psycopg/Manifest
@@ -1,3 +1,4 @@
 DIST psycopg-3.3.4.gh.tar.gz 611451 BLAKE2B 5c15f36c1fd291d1ef58c22fbb6af2c4da0a38e5c05cb40b50e06471b834924a7c55d322e335457f3a017cd31b3900ec5bd1694b6e293e5e3c740be68a9aa66c SHA512 4cfeeb118088d704c6ebd17f42916b77825e89827411116a5e9ad813e756b71969c800179aa7337a1fcb379efde937c8d33c828b87305d5bb63ef06e66185b83
 DIST psycopg-3.3.5.gh.tar.gz 759446 BLAKE2B f565b31d28dc555f28e508ab9046f83ac39a264a0ee135b147bb7949a8a505fca24492fdfec84dfd15d783e33b0d66dba696b77bebfcab0a86a1fa48f71e1c58 SHA512 bc47fdd05060ea56e068f424ff90d41df8fb1d4f052805d41c9f5ef4bf4e37f61776ff371119f46a7702af857d782c72645d234cf6f118355c191cc81450650a
 DIST psycopg2-2.9.12.tar.gz 379683 BLAKE2B bb5e5cdee0fef649c46d414b916d6f49096c27571897cfe1ecbaa9416c8c4f8c79eeff94a3475421981e3659a123e8e8852442968539d084e7cc46c54829c946 SHA512 0d37b51408298baad8b2b095af24b1c0d0b67ba99a2532ed7344a931c6f4d431be9c21c94811eace1b4418899f070f80e80266bfe0386aac2e64289ab1b8862e
+DIST psycopg2-2.9.13.tar.gz 378068 BLAKE2B 68e904c1976835b77282fde1bf29df202c25479b96896e1c98c88235eb87788911264193420a7ba2ce17b7358439614d2611bd16b3eb58df2fe61d23517778f7 SHA512 7aebcf55161b1ad60af4b64fef64f676cdf68ee1597c8c1107350c367f1eafafe37b736716d191e3a3ba4d4ea6d436d22cb606f44655b4aebc8613d4314dbc15
diff --git a/dev-python/psycopg/psycopg-2.9.13.ebuild b/dev-python/psycopg/psycopg-2.9.13.ebuild
new file mode 100644
index 000000000000..1ad3f91a9ac1
--- /dev/null
+++ b/dev-python/psycopg/psycopg-2.9.13.ebuild
@@ -0,0 +1,61 @@
+# Copyright 1999-2026 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_EXT=1
+DISTUTILS_USE_PEP517=setuptools
+PYPI_PN="psycopg2"
+PYTHON_COMPAT=( python3_{13..14} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="PostgreSQL database adapter for Python"
+HOMEPAGE="
+	https://www.psycopg.org/
+	https://github.com/psycopg/psycopg2/
+	https://pypi.org/project/psycopg2/
+"
+
+LICENSE="LGPL-3+"
+SLOT="2"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~x64-macos"
+IUSE="test"
+RESTRICT="!test? ( test )"
+
+RDEPEND=">=dev-db/postgresql-8.1:*"
+DEPEND="${RDEPEND}"
+BDEPEND="
+	test? ( >=dev-db/postgresql-8.1[server] )
+"
+
+python_prepare_all() {
+	distutils-r1_python_prepare_all
+
+	# fix for py3.13
+	sed -e 's:_PyInterpreterState_Get:PyInterpreterState_Get:' \
+		-i psycopg/utils.c || die
+	# broken by different encoding of IPv4-mapped addresses
+	sed -e 's:test_\(cidr\|inet\)_adapt:_&:' \
+		-i tests/test_ipaddress.py || die
+}
+
+src_test() {
+	initdb -D "${T}"/pgsql || die
+	# TODO: random port
+	pg_ctl -w -D "${T}"/pgsql start \
+		-o "-h '' -k '${T}'" || die
+	createdb -h "${T}" psycopg2_test || die
+
+	local -x PSYCOPG2_TESTDB_HOST="${T}"
+	distutils-r1_src_test
+
+	pg_ctl -w -D "${T}"/pgsql stop || die
+}
+
+python_test() {
+	"${EPYTHON}" -c "
+import tests
+tests.unittest.main(defaultTest='tests.test_suite')
+" --verbose || die "Tests fail with ${EPYTHON}"
+}