python安裝psycopg2 報錯 ERROR: Command errored out with exit status 1

使用pip install psycopg2 報錯如下：

Collecting psycopg2

Downloading https://pypi.tuna.tsinghua.edu.cn/packages/84/d7/6a93c99b5ba4d4d22daa3928b983cec66df4536ca50b22ce5dcac65e4e71/psycopg2-2.8.4.tar.gz (377kB)

|████████████████████████████████| 378kB 41.4MB/s

ERROR: Command errored out with exit status 1:

command: /usr/bin/python2 -c ‘import sys, setuptools, tokenize; sys.argv[0] = ‘"’"’/tmp/pip-install-YZ7EqO/psycopg2/setup.py’"’"’; file=’"’"’/tmp/pip-install-YZ7EqO/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 pip-egg-info

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

Complete output (27 lines):

/usr/lib64/python2.7/distutils/dist.py:267: UserWarning: Unknown distribution option: ‘project_urls’

warnings.warn(msg)

/usr/lib64/python2.7/distutils/dist.py:267: UserWarning: Unknown distribution option: ‘python_requires’

warnings.warn(msg)

running egg_info

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

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

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

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

writing manifest file ‘pip-egg-info/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
<http://initd.org/psycopg/docs/install.html>).

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

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

解決方法：

先安裝postgresql-devel*

yum install postgresql-devel*

再用pip安裝psycopg2 解決問題