I am having trouble connecting to a postgresql database hosed on my local host. I have gotten a python script to connect and connected through the command line, but for the life of me cant connect to a the database from QGIS. Here is the python code i got to work:
import psycopg2try: conn = psycopg2.connect("dbname='mb_sed_class' user='postgres' host='localhost' password='Daniel'")except: print "I am unable to connect to the database"print ("I connected to the database")And here is how i connected to it from the command line:
psql -d mb_sed_clsss -U postgresThe command line prompted me to input my password and it opened the psql interpreter.
A screen shot of my Create a New PostGIS Connection dialog can be found here. When i try an connect with those inputs I get the error
FATAL: pssword Authentication failed for user "postgres"Any ideas on why this might be happening? I am running QGIS 2.8.2 and PostgreSQL 9.4 on windows 8 64 bit machine.
Thanks
أكثر...
import psycopg2try: conn = psycopg2.connect("dbname='mb_sed_class' user='postgres' host='localhost' password='Daniel'")except: print "I am unable to connect to the database"print ("I connected to the database")And here is how i connected to it from the command line:
psql -d mb_sed_clsss -U postgresThe command line prompted me to input my password and it opened the psql interpreter.
A screen shot of my Create a New PostGIS Connection dialog can be found here. When i try an connect with those inputs I get the error
FATAL: pssword Authentication failed for user "postgres"Any ideas on why this might be happening? I am running QGIS 2.8.2 and PostgreSQL 9.4 on windows 8 64 bit machine.
Thanks
أكثر...