because this later is not yet available on debian, and we do not use new
API features anyway in test_cookers.py

Should fix deb packaging.

pytest-postgresql 3.1.3 and pytest-redis 2.4.0 added support for
pytest >= 7 so we can now drop the pytest pinning.

Related to T3916

Related to T1410

It's already pulled from swh.core[db] which is a runtime dependency.

Related to T2746

And remove pytest-aiohttp test dependency to avoid error related to double
loading of the plugin when pytest is invoked.

Related to T1410

Fixes build [1]

[1] https://jenkins.softwareheritage.org/job/DVAU/job/tests/807/console

RPCClient can handle it properly by reraising, instead of a
generic RemoteException.

pifpaf is not needed any more.

required to pull storage's test dependencies (like hypothesis).