diff --git a/requirements-test.txt b/requirements-test.txt
index 86283cba..6727e3d8 100644
--- a/requirements-test.txt
+++ b/requirements-test.txt
@@ -1,13 +1,13 @@
 pytest < 7.0.0  # v7.0.0 removed _pytest.tmpdir.TempdirFactory, which is used by some of the pytest plugins we use
 pytest-django
 pytest-mock
 swh.scheduler[testing]
 swh.loader.core[testing]
-pytest-postgresql >= 2.1.0, < 3.0
+pytest-postgresql >=3, < 4.0.0  # version 4.0 depends on psycopg 3. https://github.com/ClearcodeHQ/pytest-postgresql/blob/main/CHANGES.rst#400
 requests_mock
 django-stubs
 djangorestframework-stubs >= 1.4
 django-test-migrations
 
 types-requests
 types-pyyaml