Error pg_config executable not found when trying to install psycopg2-binary

landon

I have Python 3.5 setup per the instructions here: https://community.opalstack.com/d/204-howto-install-a-newer-or-older-version-of-python

When I go to install psycopg2-binary with pip install psycopg2-binary I get this error:

Complete output from command python setup.py egg_info:
running egg_info
creating pip-egg-info/psycopg2_binary.egg-info
writing dependency_links to pip-egg-info/psycopg2_binary.egg-info/dependency_links.txt
writing pip-egg-info/psycopg2_binary.egg-info/PKG-INFO
writing top-level names to pip-egg-info/psycopg2_binary.egg-info/top_level.txt
writing manifest file 'pip-egg-info/psycopg2_binary.egg-info/SOURCES.txt'
/home/<redacted>/opt/lib/python3.5/distutils/dist.py:261: UserWarning: Unknown distribution option: 'p
roject_urls'
warnings.warn(msg)
/home/<redacted>/opt/lib/python3.5/distutils/dist.py:261: UserWarning: Unknown distribution option: 'p
ython_requires'
warnings.warn(msg)
warning: manifest_maker: standard file '-c' not found

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>).

sean

landon The latest psycopg2-binary package can't be used with Python 3.5 so you'll need to install an older version. According to their changelog the last version to support Python 3.5 was 2.8.6 so try:

pip install psycopg2-binary==2.8.6

If it still complains then please try setting your shell PATH like so:

export PATH=/usr/pgsql-11/bin/:$PATH

... then attempt the installation again.

landon

That got it. Thanks!