Chris Chris - 10 months ago 45
Python Question

How to install psycopg2 with pg_config error?

I've tried to install psycopg2 (PostgreSQL Database adapater) from this site, but when I try to install after I cd into the package and write

python install

I get the following error:

Please add the directory containing pg_config to the PATH

or specify the full executable path with the option:

python build_ext --pg-config /path/to/pg_config build ...

or with the pg_config option in 'setup.cfg'.

I've also tried 'sudo pip install psycopg2' and I got the same message.

After reading through the docs, it asks to look at the setup.cfg file (which is below):


# PSYCOPG_DISPLAY_SIZE enable display size calculation (a little slower)
# HAVE_PQFREEMEM should be defined on PostgreSQL >= 7.4
# PSYCOPG_DEBUG can be added to enable verbose debug information

# "pg_config" is required to locate PostgreSQL headers and libraries needed to
# build psycopg2. If pg_config is not in the path or is installed under a
# different name uncomment the following option and set it to the pg_config
# full path.

# Set to 1 to use Python datetime objects for default date/time representation.

# If the build system does not find the mx.DateTime headers, try
# uncommenting the following line and setting its value to the right path.

# For Windows only:
# Set to 1 if the PostgreSQL library was built with OpenSSL.
# Required to link in OpenSSL libraries and dependencies.

# Statically link against the postgresql client library.

# Add here eventual extra libraries required to link the module.

However, I'm not sure if I'm suppose to edit this file, since the documentation states the following:

then take a look at the setup.cfg file.

Some of the options available in setup.cfg are also available as command line arguments of the build_ext sub-command. For instance you can specify an alternate pg_config version using:

$ python build_ext --pg-config /path/to/pg_config build

Use python build_ext --help to get a list of the options supported.

I've gotten the list of options supported but I'm not sure where to go from there


If you are on Ubuntu try

sudo apt-get install python-psycopg2

Otherwise you need to find and install the Postgresql client packages for your distribution. psycopg2 installation from source