db.pytest_plugin: Make pytest-postgresql an optional runtime dependency

Currently, this pulls the postgresql installation when installing swh.core which is not something wanted. That bypasses the current production pinning done in puppet and installs the latest postgresql-13 for example.

That particular dependency should be installed alongside swh modules which needs the core db pytest-plugin for their tests.

As impacts, i expected current packages needing this to break a bit but those already declares the pytest-postgresql as test requirements (i probably forgot to remove them). So, nothing to do, their builds will stay green:

• swh.scheduler
• swh.storage
• swh.vault

Related to swh/infra/sysadm-environment#2746 (closed)

Test Plan

tox

---

Migrated from D4376 (view on Phabricator)

swh/core/db/pytest_plugin.py

@@ -10,11 +10,17 @@ from typing import Optional, Set, Union
 
 import psycopg2
 import pytest
-from pytest_postgresql import factories
-from pytest_postgresql.janitor import DatabaseJanitor, Version
 
 from swh.core.utils import numfile_sortkey as sortkey
 
+try:
+    from pytest_postgresql import factories
+    from pytest_postgresql.janitor import DatabaseJanitor, Version
+except ImportError:
+    error_msg = "The module pytest_plugin requires dependency pytest-postgresql module"
+    raise EnvironmentError(error_msg)
+
+
 logger = logging.getLogger(__name__)