Testing Postgres Connection

testing_postgres_conn.py

#!/usr/bin/python

import psycopg2
import sys

host = ''
dbname = ''
user = ''
password = ''
port = 5432


conn_string = "host='%s' dbname='%s' user='%s' password='%s' port='%i'"\
              % (host, dbname, user, password, port)

print "Connecting to database\n ->%s" % (conn_string)

try:
    conn = psycopg2.connect(conn_string)
    cursor = conn.cursor()
    print "Connected!\n"
except:
    exceptionType, exceptionValue, exceptionTraceback = sys.exc_info()
    sys.exit("Database connection failed!\n ->%s" % (exceptionValue))