【Py】解决mac安装psycopg2报错

在mac上安装psycopg2时报错

>>> pip3 install psycopg2

Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple
Collecting psycopg2
  Using cached https://pypi.tuna.tsinghua.edu.cn/packages/aa/8a/7c80e7e44fb1b4277e89bd9ca509aefdd4dd1b2c547c6f293afe9f7ffd04/psycopg2-2.9.1.tar.gz (379 kB)
    ERROR: Command errored out with exit status 1:
     command: /usr/local/opt/python@3.8/bin/python3.8 -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/zy/mrl8lxzn0k38zl59kszbhnv80000gn/T/pip-install-5ket726k/psycopg2_f57f2dc854d549fd9c34415057728ca4/setup.py'"'"'; __file__='"'"'/private/var/folders/zy/mrl8lxzn0k38zl59kszbhnv80000gn/T/pip-install-5ket726k/psycopg2_f57f2dc854d549fd9c34415057728ca4/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /private/var/folders/zy/mrl8lxzn0k38zl59kszbhnv80000gn/T/pip-pip-egg-info-77s_piiq
         cwd: /private/var/folders/zy/mrl8lxzn0k38zl59kszbhnv80000gn/T/pip-install-5ket726k/psycopg2_f57f2dc854d549fd9c34415057728ca4/
    Complete output (23 lines):
    running egg_info
    creating /private/var/folders/zy/mrl8lxzn0k38zl59kszbhnv80000gn/T/pip-pip-egg-info-77s_piiq/psycopg2.egg-info
    writing /private/var/folders/zy/mrl8lxzn0k38zl59kszbhnv80000gn/T/pip-pip-egg-info-77s_piiq/psycopg2.egg-info/PKG-INFO
    writing dependency_links to /private/var/folders/zy/mrl8lxzn0k38zl59kszbhnv80000gn/T/pip-pip-egg-info-77s_piiq/psycopg2.egg-info/dependency_links.txt
    writing top-level names to /private/var/folders/zy/mrl8lxzn0k38zl59kszbhnv80000gn/T/pip-pip-egg-info-77s_piiq/psycopg2.egg-info/top_level.txt
    writing manifest file '/private/var/folders/zy/mrl8lxzn0k38zl59kszbhnv80000gn/T/pip-pip-egg-info-77s_piiq/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>).

解决办法就是先用homebrew安装postgresql

>>> brew install postgresql
>>> pip3 install psycopg2

参考：https://stackoverflow.com/a/24645416/7151777