How to Fix pg_config Executable Not Found Error When Installing Psycopg2 with \'pip\' in Python?

Installing Psycopg2 with "pip" in Python

When using Python with virtual environments to install the database driver psycopg2, users may encounter errors related to the absence of the pg_config executable. To resolve this issue, additional steps are necessary.

Error Message:

Error: pg_config executable not found.

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

Solution:

There are two main approaches to install psycopg2 successfully:

Option 1: Install Binary Wheels

For users on Windows, it is recommended to install the psycopg2-binary package, which provides pre-built binaries for various Python versions. This simplifies the installation process:

pip install psycopg2-binary

Option 2: Build from Source (Linux/Mac)

Prerequisites:

To build psycopg2 from source, install the following dependencies:

• Debian/Ubuntu:

  • Python 3: sudo apt install libpq-dev python3-dev
  • Python 2: sudo apt install libpq-dev python-dev

Steps:

1. Download the psycopg2 source code:

   wget https://pypi.python.org/packages/source/p/psycopg2/psycopg2-2.8.6.tar.gz

2. Extract the archive:

   tar xvf psycopg2-2.8.6.tar.gz

3. Navigate to the extracted directory:

   cd psycopg2-2.8.6

4. Configure the build by passing the path to the pg_config executable:

   python setup.py build_ext --pg-config /path/to/pg_config

5. Install the package:

   sudo python setup.py install

6. Verify the installation:

   python -c "import psycopg2; print(psycopg2.__version__)"

Note:

• For more information, refer to psycopg2's official documentation: https://www.psycopg.org/docs/installation.html
• Replace /path/to/pg_config with the actual path to the pg_config executable on your system.

The above is the detailed content of How to Fix pg_config Executable Not Found Error When Installing Psycopg2 with \'pip\' in Python?. For more information, please follow other related articles on the PHP Chinese website!