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.