Failure connecting to remote PostgreSQL DB

DParker75089's profile image DParker75089 posted 1 year ago in General Permalink

When using a Windows 10 Heidi SQL installation and attempting to connect to a remote (AWS RDS) PostgreSQL DB using the remote IP address and port 5432 the attempt fails with the following "Connection failed" message:

connection to server at "127.0.0.1", port 3307 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections?

Since the connection is configured as a PostgreSQL type using the libpq15.dll library, with the remote AWS RDS instance IP address and port 5432, why in the world is Heidi trying to connect on 127.0.0.1:3307, which would be a locally running MySQL server?

ansgar's profile image ansgar posted 1 year ago Permalink

You have likely set it up as a connection over SSH.

DParker75089's profile image DParker75089 posted 1 year ago Permalink

You have likely set it up as a connection over SSH.

No, I have it set up as a straight TCP/IP connection.

DParker75089's profile image DParker75089 posted 1 year ago Permalink

OK, never mind...you were correct. I created it as a TCP/IP connection but someone in my office tried to use it and inadvertently changed it to SSH.

Please login to leave a reply, or register at first.