I am a newbie here, and am trying to connect to a Postgresql database in Debian 10 from Windows 10. Code is as below:
import psycopg2
try:
dbConnection = psycopg2.connect(
user = "", # user is here
password = "", # password is here
host = "192.168.56.30",
port = "5432",
database = "postgres")
dbConnection.set_isolation_level(0) # AUTOCOMMIT
dbCursor = dbConnection.cursor()
dbCursor.execute("CREATE DATABASE weather")
dbCursor.close()
print("Job done!!")
except (Exception , psycopg2.Error) as dbError :
print ("Error while connecting to PostgreSQL", dbError)
finally:
print("")
# if(dbConnection): dbConnection.close()
I am getting the below error : "Error while connecting to PostgreSQL could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "192.168.56.30" and accepting TCP/IP connections on port 5432?"
I have added listen_addresses = ’*’ to my postgresql.conf file.
I have added under IPV4 connections in my pg_hba.conf file I have added the below : host all all 192.168.56.1/32 md5
I have enabled and started the DB: sudo systemctl enable postgresql@11-main sudo systemctl start postgresql@11-main
What else could I be doing wrong here?
Here is the VirtualBox settings (as I am convinced the problem is the host connection), now I have messed around with them a bit trying to get it to work!
I have added listen address to the postgresql.conf file as below
And an extract from the pg_hba.conf file is as below:
As I am new to this, all help would be much appreciated.
User contributions licensed under CC BY-SA 3.0