pip-installation of 1.14.0-pre3 fails in certain situations

[k9ert]

Describe the bug

$ pip3 install cryptoadvance.specter --upgrade --pre
Collecting attrs==22.1.0
  Downloading attrs-22.1.0-py2.py3-none-any.whl (58 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 58.8/58.8 KB 2.1 MB/s eta 0:00:00
Collecting psycopg2-binary==2.9.5
  Downloading psycopg2-binary-2.9.5.tar.gz (384 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 384.4/384.4 KB 7.4 MB/s eta 0:00:00
  Preparing metadata (setup.py) ... error
  error: subprocess-exited-with-error
  
  × python setup.py egg_info did not run successfully.
  │ exit code: 1
  ╰─> [23 lines of output]
      running egg_info
      creating /tmp/pip-pip-egg-info-ey5du6ac/psycopg2_binary.egg-info
      writing /tmp/pip-pip-egg-info-ey5du6ac/psycopg2_binary.egg-info/PKG-INFO
      writing dependency_links to /tmp/pip-pip-egg-info-ey5du6ac/psycopg2_binary.egg-info/dependency_links.txt
      writing top-level names to /tmp/pip-pip-egg-info-ey5du6ac/psycopg2_binary.egg-info/top_level.txt
      writing manifest file '/tmp/pip-pip-egg-info-ey5du6ac/psycopg2_binary.egg-info/SOURCES.txt'
      
      Error: pg_config executable not found.
      
      pg_config is required to build psycopg2 from source.  Please add the directory
      containing pg_config to the $PATH or specify the full executable path with the
      option:
      
          python setup.py build_ext --pg-config /path/to/pg_config build ...
      
      or with the pg_config option in 'setup.cfg'.
      
      If you prefer to avoid building psycopg2 from source, please install the PyPI
      'psycopg2-binary' package instead.
      
      For further information please check the 'doc/src/install.rst' file (also at
      <https://www.psycopg.org/docs/install.html>).
      
      [end of output]
  
  note: This error originates from a subprocess, and is likely not a problem with pip.
error: metadata-generation-failed

× Encountered error while generating package metadata.
╰─> See above for output.

note: This is an issue with the package mentioned above, not pip.
hint: See above for details.
WARNING: You are using pip version 22.0.4; however, version 22.3.1 is available.
You should consider upgrading via the '/home/specter/.env/bin/python -m pip install --upgrade pip' command.
$

Additional context

• python 3.8.13 on arm (buster/sid)

[k9ert]

See this as a solution:
https://stackoverflow.com/questions/35104097/how-to-install-psycopg2-with-pg-config-error?noredirect=1

in short, one of:

• sudo apt install libpq-dev python-dev
• pip install psycopg2-binary

Which way should we go?

• Add the debian package to the description of pre-requisites
• Add the package to the requirement.txt

[aphex3k]

The same error is produced when building the docker image for several different architectures like linux/s390x or linux/arm/v7.

Which way should we go?

My vote is on adding it to the list in requirement.txt.

Once the requirements (or prerequisites) are modified, it allows for building the same set of platforms supported by the base image:

• linux/386
• linux/amd64
• linux/arm/v5
• linux/arm/v7
• linux/arm64/v8
• linux/ppc64le
• linux/s390x
• linux/mips64le