centos7 pip3 安装psycopg2出错

命令：pip3 install psycopg2

error：

Collecting psycopg2

  Using cached psycopg2-2.9.1.tar.gz (379 kB)

    ERROR: Command errored out with exit status 1:

    command: /usr/local/bin/python3.9 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-wz20lo5h/psycopg2/setup.py'"'"'; __file__='"'"'/tmp/pip-install-wz20lo5h/psycopg2/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /tmp/pip-pip-egg-info-nlj2yilc

        cwd: /tmp/pip-install-wz20lo5h/psycopg2/

    Complete output (23 lines):

    running egg_info

    creating /tmp/pip-pip-egg-info-nlj2yilc/psycopg2.egg-info

    writing /tmp/pip-pip-egg-info-nlj2yilc/psycopg2.egg-info/PKG-INFO

    writing dependency_links to /tmp/pip-pip-egg-info-nlj2yilc/psycopg2.egg-info/dependency_links.txt

    writing top-level names to /tmp/pip-pip-egg-info-nlj2yilc/psycopg2.egg-info/top_level.txt

    writing manifest file '/tmp/pip-pip-egg-info-nlj2yilc/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>).

    ----------------------------------------

ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.

WARNING: You are using pip version 20.2.3; however, version 21.2.3 is available.

You should consider upgrading via the '/usr/local/bin/python3.9 -m pip install --upgrade pip' command.

解决方案：

yum install postgresql-devel