如何在Python上使用“pip”安装psycopg2 ?

我正在使用virtualenv，我需要安装“psycopg2”。

我做了以下几点:

pip install http://pypi.python.org/packages/source/p/psycopg2/psycopg2-2.4.tar.gz#md5=24f4368e2cfdc1a2b03282ddda814160

我有以下信息:

Downloading/unpacking http://pypi.python.org/packages/source/p/psycopg2/psycopg2
-2.4.tar.gz#md5=24f4368e2cfdc1a2b03282ddda814160
  Downloading psycopg2-2.4.tar.gz (607Kb): 607Kb downloaded
  Running setup.py egg_info for package from http://pypi.python.org/packages/sou
rce/p/psycopg2/psycopg2-2.4.tar.gz#md5=24f4368e2cfdc1a2b03282ddda814160
    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'.
    Complete output from command python setup.py egg_info:
    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'

warning: manifest_maker: standard file '-c' not found

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

----------------------------------------
Command python setup.py egg_info failed with error code 1
Storing complete log in C:\Documents and Settings\anlopes\Application Data\pip\p
ip.log

我的问题是，我只需要这样做来让psycopg2工作?

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

当前回答

在OSX上使用macports:

sudo port install postgresql96
export PATH=/opt/local/lib/postgresql96/bin:$PATH

2017-03-17 14:07:24

其他回答

运行下面的命令应该没问题

$ apt-get update
$ apt install python3-dev libpq-dev
$ pip3 install psycopg2

2021-06-18 11:04:50

在Ubuntu上，我只需要postgres开发包:

sudo apt-get install postgresql-server-dev-all

*在virtualenv中测试

2016-01-04 14:47:29

我可以在windows机器上安装它，并通过以下命令使用Anaconda/Spyder和python 2.7:

 !pip install psycopg2

然后建立到数据库的连接:

 import psycopg2
 conn = psycopg2.connect(dbname='dbname',host='host_name',port='port_number', user='user_name', password='password')

2016-04-11 08:52:15

我有这个问题，主要原因是安装了2个相同的版本。postgres写的。一个是HomeBrew的。

如果您选择只保留APP:

brew unlink postgresql
pip3 install psycopg2

2019-07-10 20:48:31

我之前已经这样做过，在windows中，你首先安装到你的基本python安装中。

然后，手动将已安装的psycopg2复制到virtualenv安装中。

这并不漂亮，但很有效。

2012-02-27 03:35:21

如何在Python上使用“pip”安装psycopg2 ?

推荐文章

最新文章

标签