pip install -r requirements.txt fails with pg_config executable not found.

[quincy451]

Steps to reproduce

pip install -r requirements.txt

Expected result

successful install of packages

Actual result

Collecting aiohttp==3.8.3
Using cached aiohttp-3.8.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.0 MB)
Collecting aiosignal==1.3.1
Using cached aiosignal-1.3.1-py3-none-any.whl (7.6 kB)
Collecting appnope==0.1.3
Using cached appnope-0.1.3-py2.py3-none-any.whl (4.4 kB)
Collecting asttokens==2.2.1
Using cached asttokens-2.2.1-py2.py3-none-any.whl (26 kB)
Collecting async-timeout==4.0.2
Using cached async_timeout-4.0.2-py3-none-any.whl (5.8 kB)
Collecting attrs==22.2.0
Using cached attrs-22.2.0-py3-none-any.whl (60 kB)
Collecting backcall==0.2.0
Using cached backcall-0.2.0-py2.py3-none-any.whl (11 kB)
Collecting beautifulsoup4==4.11.1
Using cached beautifulsoup4-4.11.1-py3-none-any.whl (128 kB)
Collecting blobfile==2.0.1
Using cached blobfile-2.0.1-py3-none-any.whl (73 kB)
Collecting bs4==0.0.1
Using cached bs4-0.0.1.tar.gz (1.1 kB)
Preparing metadata (setup.py): started
Preparing metadata (setup.py): finished with status 'done'
Collecting certifi==2022.12.7
Using cached certifi-2022.12.7-py3-none-any.whl (155 kB)
Collecting charset-normalizer==2.1.1
Using cached charset_normalizer-2.1.1-py3-none-any.whl (39 kB)
Collecting comm==0.1.2
Using cached comm-0.1.2-py3-none-any.whl (6.5 kB)
Collecting contourpy==1.0.7
Using cached contourpy-1.0.7-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (300 kB)
Collecting cycler==0.11.0
Using cached cycler-0.11.0-py3-none-any.whl (6.4 kB)
Collecting debugpy==1.6.5
Using cached debugpy-1.6.5-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (3.0 MB)
Collecting decorator==5.1.1
Using cached decorator-5.1.1-py3-none-any.whl (9.1 kB)
Collecting docopt==0.6.2
Using cached docopt-0.6.2.tar.gz (25 kB)
Preparing metadata (setup.py): started
Preparing metadata (setup.py): finished with status 'done'
Collecting entrypoints==0.4
Using cached entrypoints-0.4-py3-none-any.whl (5.3 kB)
Collecting executing==1.2.0
Using cached executing-1.2.0-py2.py3-none-any.whl (24 kB)
Collecting filelock==3.9.0
Using cached filelock-3.9.0-py3-none-any.whl (9.7 kB)
Collecting fonttools==4.38.0
Using cached fonttools-4.38.0-py3-none-any.whl (965 kB)
Collecting frozenlist==1.3.3
Using cached frozenlist-1.3.3-cp310-cp310-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (149 kB)
Collecting html==1.13
Using cached html-1.13.tar.gz (6.7 kB)
Preparing metadata (setup.py): started
Preparing metadata (setup.py): finished with status 'done'
Collecting huggingface-hub==0.11.1
Using cached huggingface_hub-0.11.1-py3-none-any.whl (182 kB)
Requirement already satisfied: idna==3.4 in ./env/lib/python3.10/site-packages (from -r requirements.txt (line 26)) (3.4)
Collecting ipykernel==6.20.1
Using cached ipykernel-6.20.1-py3-none-any.whl (149 kB)
Collecting ipython==8.8.0
Using cached ipython-8.8.0-py3-none-any.whl (775 kB)
Collecting jedi==0.18.2
Using cached jedi-0.18.2-py2.py3-none-any.whl (1.6 MB)
Collecting joblib==1.2.0
Using cached joblib-1.2.0-py3-none-any.whl (297 kB)
Collecting jupyter_client==7.4.8
Using cached jupyter_client-7.4.8-py3-none-any.whl (133 kB)
Collecting jupyter_core==5.1.3
Using cached jupyter_core-5.1.3-py3-none-any.whl (93 kB)
Collecting kiwisolver==1.4.4
Using cached kiwisolver-1.4.4-cp310-cp310-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (1.6 MB)
Collecting lxml==4.9.2
Using cached lxml-4.9.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.manylinux_2_24_x86_64.whl (7.1 MB)
Collecting matplotlib==3.6.3
Using cached matplotlib-3.6.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (11.8 MB)
Collecting matplotlib-inline==0.1.6
Using cached matplotlib_inline-0.1.6-py3-none-any.whl (9.4 kB)
Collecting multidict==6.0.4
Using cached multidict-6.0.4-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (114 kB)
Collecting nest-asyncio==1.5.6
Using cached nest_asyncio-1.5.6-py3-none-any.whl (5.2 kB)
Collecting numpy==1.24.1
Using cached numpy-1.24.1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (17.3 MB)
Collecting openai==0.26.1
Using cached openai-0.26.1.tar.gz (55 kB)
Installing build dependencies: started
Installing build dependencies: finished with status 'done'
Getting requirements to build wheel: started
Getting requirements to build wheel: finished with status 'done'
Preparing metadata (pyproject.toml): started
Preparing metadata (pyproject.toml): finished with status 'done'
Collecting packaging==23.0
Using cached packaging-23.0-py3-none-any.whl (42 kB)
Collecting pandas==1.5.2
Using cached pandas-1.5.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.1 MB)
Collecting parso==0.8.3
Using cached parso-0.8.3-py2.py3-none-any.whl (100 kB)
Collecting pexpect==4.8.0
Using cached pexpect-4.8.0-py2.py3-none-any.whl (59 kB)
Collecting pickleshare==0.7.5
Using cached pickleshare-0.7.5-py2.py3-none-any.whl (6.9 kB)
Collecting Pillow==9.4.0
Using cached Pillow-9.4.0-cp310-cp310-manylinux_2_28_x86_64.whl (3.4 MB)
Collecting pipreqs==0.4.11
Using cached pipreqs-0.4.11-py2.py3-none-any.whl (32 kB)
Collecting platformdirs==2.6.2
Using cached platformdirs-2.6.2-py3-none-any.whl (14 kB)
Collecting plotly==5.12.0
Using cached plotly-5.12.0-py2.py3-none-any.whl (15.2 MB)
Collecting prompt-toolkit==3.0.36
Using cached prompt_toolkit-3.0.36-py3-none-any.whl (386 kB)
Collecting psutil==5.9.4
Using cached psutil-5.9.4-cp36-abi3-manylinux_2_12_x86_64.manylinux2010_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (280 kB)
Collecting psycopg2==2.9.5
Using cached psycopg2-2.9.5.tar.gz (384 kB)
Preparing metadata (setup.py): started
Preparing metadata (setup.py): finished with status '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-f2skvrol/psycopg2.egg-info
writing /tmp/pip-pip-egg-info-f2skvrol/psycopg2.egg-info/PKG-INFO
writing dependency_links to /tmp/pip-pip-egg-info-f2skvrol/psycopg2.egg-info/dependency_links.txt
writing top-level names to /tmp/pip-pip-egg-info-f2skvrol/psycopg2.egg-info/top_level.txt
writing manifest file '/tmp/pip-pip-egg-info-f2skvrol/psycopg2.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.

Environment

ubuntu 22.04.2

Logs, links