Hello, I am trying to connect to a PostgreSQL database remotely.
I have read the documentation for PostgreSQland pgAdmin, but apparently it is not sinking in or making sense. My situation is: I am running PostgreSQL 15 on a Windows 10 Pro virtual machine on VirtualBox. The virtual machine also has a Host Only Network besides the NAT Network. I want to connect to the database from my desktop that is hosting the VM with VirtualBox using pgAdmin. I can connect to the database on the virtual machine on VirtualBox using pgAdmin. Here is the connection string: "host=localhost port=5432 dbname=googleLens user=postgres password=XXXXXXX sslmode=prefer connect_timeout=10". Do I need to remove the sslmode to connect remotely? The postgresql.conf contains listen addresses = '*'. I have tried so many combinations in the pg_hba.conf that I am almost going blind. I can not connect using pgAdmin on the desktop. In the Register - Server windows under the General tab can the Name be anything? Under the Connection tab is the Host name/address the Host Only Network of the machine the server is running on? Everytime I try to connect I get an "Unable to connect to server, connection timeout expired" error! I would appreciate any and all help. Or point me to a clear resource. Please DO NOT tell me to RTFM because I HAVE done so numerous times. Thank you. Frank Gunseor
