使用psycopg2创建一个Postgresql数据库

我正在尝试使用python脚本创建一个postgres数据库。一些研究表明，使用psycopg2模块可能是实现此目的的一种方法。我安装了它，并在 pg_hba.conf 文件中进行了所需的更改。我使用以下代码创建了数据库：

I'm trying to create a postgres DB using a python script. Some research showed that using the psycopg2 module might be a way to do it. I installed it and made the required changes in the pg_hba.conf file. I used the following code to create the DB:

#!/usr/bin/python
# -*- coding: utf-8 -*-

from psycopg2 import connect
import sys
from psycopg2.extensions import ISOLATION_LEVEL_AUTOCOMMIT

con = None
con = connect(user='****', host = 'localhost', password='****')

dbname = "voylla_production1710"

con.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)
cur = con.cursor()
cur.execute('CREATE DATABASE ' + dbname)
cur.close()
con.close()

我尝试替换 con = connect（user ='nishant'，host = 'localhost'，password ='everything'） with con = connect（user ='nishant'，password ='everything'）

I tried replacing con = connect(user='nishant', host = 'localhost', password='everything') with con = connect(user='nishant', password='everything')

但是出现以下错误：

con = connect(user='nishant', host = 'localhost', password='everything') 
 File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect
connection_factory=connection_factory, async=async)
 psycopg2.OperationalError: FATAL:  database "nishant" does not exist

有人可以告诉我正确的做法。
谢谢

Could someone please tell me the right way of doing it. Thanks