<p>Env=python 2.7.10(cygwin发行版),Windows 7,cygwin 64</p>
<p>1)pip install psycopg2失败,因为我没有pip
调试</p>
<p>2)从此处安装pip:pip.pypa.io/en/stable/installing/在</p>
<p>3)pip install psycopg2由于“no pg_config…”而失败</p>
<p>4)win的psycopg2安装程序(www.stickpeople.com/projects/python/win-psycopg/)失败的原因是我使用的是cygwin的python安装,而不是机器注册表中的python,而且这个安装程序不允许用户安装在Windows注册的python之外的任何地方
(安装程序成功了,但文件不是我需要的地方。)
(“复制”文件不起作用。)</p>
<p>5)这个(<a href="https://github.com/nwcell/psycopg2-windows" rel="nofollow">https://github.com/nwcell/psycopg2-windows</a>)pip安装“有效”(没有出错),但是当我尝试导入时,我收到了消息:
“ImportError:没有名为psycopg2的模块”</p>
<p>6)pip卸载psycopg2</p>
<p>7)尝试pip安装libpq dev和python dev
“找不到满足libpq dev要求的版本(来自版本:)
找不到与libpq dev匹配的发行版“</p>
<p>8)从这里安装Postgres&pg_config <a href="http://www.enterprisedb.com/products-services-training/pgdownload#windows" rel="nofollow">http://www.enterprisedb.com/products-services-training/pgdownload#windows</a></p>
<p>9)将pg_config添加到路径</p>
<p>10)pip install psycopg2现在可以工作了</p>
<p>11)在.py文件中导入psycopg2导致核心转储</p>
<p>堆栈跟踪:
帧函数参数
006001A5A60 0018007261A(000FFE3F4,0000000 E514,00000000000000FFFFDE50)
006001A5B00 00180073DD0(00077801FD6,0000000000000000000140100000000000)
006001A5D50 0018012EF8F(00600010540,00000000000,003DB05FDB0,6FFFFF28050)
006001A6040 0018012BC70(000000000D,000000000000000000000000018013D7DA)
000000000000018012C139(006001A60303630303030303030363030363003000000
00000亿英镑)
000000000000018012C30C(0000000000010000000A8E73,6F007000650072,61006C0074
0072)
0000000000000180127BFB(0000000000010000000A8E73,6F007000650072,61006C0074
0072)
00000000000000180071169(010000000010000000000000000000000FFFFCE00)
000FFFFAA00 00180073D11(B64000B00630079,00000000088,1D17578E1C375D4,1D17578
E16661AE)
52004F00520052 64006F00630072(00000000088,1D17578E1C375D4,1D17578E16661AE,1
D175A09055FB4F)
52004F00520052 70002E00730065(1D17578E1C375D4、1D17578E16661AE、1D175A09055FB4
F、 1D175A09055FB4F)
52004F00520052 B64000B00630079(1D17578E16661AE,1D175A09055FB4F,1D175A09055FB
4F,0000000180B)
52004F00520052 00000000088(1D175A09055FB4F,1D175A09055FB4F,0000000180B,0000
0002000年)
52004F00520052 1D17578E1C375D4(1D175A09055FB4F,0000000180B,00000002000001A0
0000020)
52004F00520052 1D17578E16661AE(0000000180B,00000000200002001A000002045001600
百万)
52004F00520052 1D175A09055FB4F(0000000 2000、01A00000020、4500160000000、4E004
500540058)
堆栈结束跟踪(可能会出现更多堆栈帧)</p>
<p>(上述过程耗时约2天。)</p>
<p>12)管道安装pg8000工作</p>
<p>13)将pg8000导入.py文件并连接到数据库
(第12步和第13步耗时约20分钟。)</p>