title: Trouble installing psycopg2 on CentOS
body: <p>I'm trying to install psycopg2 on CentOS, I followed everything on this <a href="http://thebuild.com/blog/2009/10/17/wordpress-to-djangopostgresql-part-3-installing-apache-python-2-6-psycopg2-and-mod_wsgi/" rel="noreferrer">tutorial</a> from "On with it: Installing Python 2.6" all the way to when it imports psycopg2, but when I try to import I get the following error:</p>
  
  <pre><code> Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
    File "/opt/python2.6/lib/python2.6/site-packages/psycopg2/__init__.py", line 69, in &lt;module&gt;
      from _psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
  ImportError: libpq.so.5: cannot open shared object file: No such file or directory
  </code></pre>
  
  <p>How to troubleshoot this?</p>