I see you posted the question on StackOverflow as well. A quick search turned up the same problem there, with a solution that allegedly works:
http://stackoverflow.com/questions/14863723/psycopg2-import-error-due-to-failure-to-load-libraries -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.