I'm trying to connect to a postgres database with psycopg2:

import psycopg2try:conn = psycopg2.connect("dbname='puppetdb' user='puppetdb' host='172.17.0.1' port='5432' password='puppetdb'")
except Exception, e:print "I am unable to connect to the database"print e

Which returns:

I am unable to connect to the database
'module' object has no attribute 'connect'

I've made sure that psycopg2 is installed with pip install psycopg2 and it seems like this should work according to the documentation.

Am I doing this wrong?

This could be a name shadowing issue.

If your file is called psycopg2.py or if you have a psycopg2.py/psycopg2.pyc file in that directory then it will import your script over the actual pyscopg2 module.

If that's the issue then rename your file to something else.