I have FC14 with two versions of Python installed, one in /usr and another in /usr/local. The one that works with PostgreSQL in the one in /usr/local. (I wrote a little python script to test connection to postgres and it works with #!/usr/local/bin/python and fails with #!/usr/bin/python). I was successful in creating the Trac project connected to the postgres db.
I wound up installing Trac in both paths (should only need it in /usr/local with postgres) and can not get trac to use the one in /usr/local. I get the subject error when trying to access the url. From the trace.log:
2012-10-11 18:56:17,580 Trac[env] ERROR: Exception caught while checking for upgrade:
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/Trac-1.0-py2.7.egg/trac/env.py", line 837, in open_environment
needs_upgrade = env.needs_upgrade()
File "/usr/lib/python2.7/site-packages/Trac-1.0-py2.7.egg/trac/env.py", line 669, in needs_upgrade
with self.db_query as db:
File "/usr/lib/python2.7/site-packages/Trac-1.0-py2.7.egg/trac/db/api.py", line 165, in __enter__
db = DatabaseManager(self.env).get_connection(readonly=True)
File "/usr/lib/python2.7/site-packages/Trac-1.0-py2.7.egg/trac/db/api.py", line 248, in get_connection
connector, args = self.get_connector()
File "/usr/lib/python2.7/site-packages/Trac-1.0-py2.7.egg/trac/db/api.py", line 299, in get_connector
raise TracError(connector.error)
TracError: Cannot load Python bindings for PostgreSQL