In case anyone else encounters problems installing psycopg2 on a Mac. The problem was created by outdated libcrypto and libssl lib files in /usr/lib. Fixed the problem by copying the newer files from PostgreSQL/9.1/lib, deleting aliases pointing at the old files and creating new ones to replace them.
Example: sudo ln -s /usr/lib/libssl.1.0.0.dylib /usr/lib/libssl.dylib after making sure that libssl.1.0.0.dylib had been copied into /usr/lib and the old libssl.dylib alias had been removed. A little apprehensive about how this will affect some of my other applications, but at least web2py is now working with Postgres. On Saturday, August 18, 2012 8:38:27 PM UTC-4, Mike Girard wrote: > > Apparently there is something wrong with my installation of the driver. > Going to see if I can sort that before coming back. Consider this closed. > > On Saturday, August 18, 2012 8:16:36 PM UTC-4, Mike Girard wrote: >> >> I am attempting to move from SQLLite to Postgres because I was having >> table locking issues.. >> >> I downloaded and installed Postgres and the Psycopg2-2.4.5. They work. I >> am able to administer Postgres and the installation of the driver was >> uneventful. >> >> I first encountered the self-drivers error (documented elsewhere in this >> group) and changed gluon/dal.py in accordance with the instructions. After >> doing that, the home page of my app loaded up as did default/appadmin. >> However. when I attempted to add a record to the database, I got the error >> "global name 'psycopg2_adapt' is not defined". >> >> Is there something else I need to do? >> >> I am running the latest stable release from source. >> >> Thanks. >> >> --
