安装好了django,部署过项目之后,配置setting.py文件,

修改database数据:

保存配置,返回到项目根目录下,运行 python manage.py shell,执行如下命令:

   >>> from django.db import connection

   >>> cursor = connection.cursor()

这种方式验证的时候,报错

  File "<frozen importlib._bootstrap>", line 2254, in _gcd_import

  File "<frozen importlib._bootstrap>", line 2237, in _find_and_load

  File "<frozen importlib._bootstrap>", line 2226, in _find_and_load_unlocked

  File "<frozen importlib._bootstrap>", line 1200, in _load_unlocked

  File "<frozen importlib._bootstrap>", line 1129, in _exec

  File "<frozen importlib._bootstrap>", line 1471, in exec_module

  File "<frozen importlib._bootstrap>", line 321, in _call_with_frames_removed

  File "/opt/python3.4.1/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/db/backends/postgresql_psycopg2/base.py", line 27, in <module>

    raise ImproperlyConfigured("Error loading psycopg2 module: %s" % e)

django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 module: libpq.so.5: cannot open shared object file: No such file or directory

使用解决办法:

下载libpq.so.5安装包:

wget ftp://ftp.muug.mb.ca/mirror/centos/5.11/os/x86_64/CentOS/postgresql84-libs-8.4.20-1.el5_10.i386.rpm


然后安装:

 rpm -ivh postgresql84-libs-8.4.20-1.el5_10.i386.rpm 

问题解决,由于数据库版本是91,但是该补丁是支持84的数据库版本,可能会出现兼容性问题。