psycopg2==2.9.6 - pg_config not found

[Captain-Bacon]

Collecting psycopg2==2.9.6 (from -r requirements.txt (line 9))
Using cached psycopg2-2.9.6.tar.gz (383 kB)
Preparing metadata (setup.py) ... error
error: subprocess-exited-with-error

× python setup.py egg_info did not run successfully.
│ exit code: 1
╰─> [25 lines of output]
/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/setuptools/config/setupcfg.py:508: SetuptoolsDeprecationWarning: The license_file parameter is deprecated, use license_files instead.
warnings.warn(msg, warning_class)
running egg_info
creating /private/var/folders/8_/91fb2xx1191gcq8jtvctckk00000gn/T/pip-pip-egg-info-jp1es49t/psycopg2.egg-info
writing /private/var/folders/8_/91fb2xx1191gcq8jtvctckk00000gn/T/pip-pip-egg-info-jp1es49t/psycopg2.egg-info/PKG-INFO
writing dependency_links to /private/var/folders/8_/91fb2xx1191gcq8jtvctckk00000gn/T/pip-pip-egg-info-jp1es49t/psycopg2.egg-info/dependency_links.txt
writing top-level names to /private/var/folders/8_/91fb2xx1191gcq8jtvctckk00000gn/T/pip-pip-egg-info-jp1es49t/psycopg2.egg-info/top_level.txt
writing manifest file '/private/var/folders/8_/91fb2xx1191gcq8jtvctckk00000gn/T/pip-pip-egg-info-jp1es49t/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.

I'm running this in a new Conda environment.

Macbook Pro, Apple Silicone M2 Max

[Captain-Bacon]

Not sure what the issue with Conda is, but when I Venv it, it works.

[CyKiller]

I switched to psycopg2-binary==2.9.7 - works with both.