Trouble Shooting a connection

bwinter's profile image bwinter posted 4 years ago in General Permalink

This may be an issue with Google Cloud, but I'm having difficultly connecting to a postgres database, but I was able to connect to the same project using a Mysql database. I've permitted all IPs to access my DB, and I set my password super-short simply to remove the possibility of password errors and so I can manually type it while testing.

I can connect to the postgres DB using the cloud shell. I can connect on commandline from my local system.

Network Type : PostgreSQL(TCP/IP) Library : libpq-12.dll User : postgres ( I've confirmed this ) Port : 5432 ( Also confirmed this )

Error : I am getting a long period of the application hang, followed by the following error.

could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host {IP} and accepting TCP/IP connections on port 5432

My Google Cloud firewall is configured to allow that connection.

I don't expect this to be enough to figure out why it's not working, but I'm sort of at my wits end on trying to get an extremely basic set up to work right with default settings. Any insight on landmines I should look out for would be appreciated.

Hootie's profile image Hootie posted 4 years ago Permalink

I think that the problem may be in the transmission packets themselves or in the port that may be closed.

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