I have created a Data Fusion instance and a PostgreSQL database in Google Cloud. When I make the connection from Data Fusion to the database in order to make a pipeline I get the following error:
Failed to create connection to database via connection string: jdbc:postgresql://IP/postgres and arguments: {user=USER}. Error: SocketTimeoutException: connect timed out. Make sure you specify the correct connection properties.
I have tried to modify permissions in IAM but I am not able to solve the problem. In case it was a PostgreSQL problem, I also tried to do it with SQL and I get the same problem.
Could someone please help me?