PostgreSQL connection with Data Fusion

[andres_artm]

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?

[shaaland · Accepted solution]

Hi @andres_artm ,

Please repost this to the data analytics topic with the Label for Cloud Data Fusion to ensure you get to the right set of product experts for Cloud Data Fusion:
https://www.googlecloudcommunity.com/gc/forums/filteredbylabelpage/board-id/cloud-data-analytics/lab... 

I know there is a Cloud SQL proxy which may be required for connectivity?  But I'll let the Data Fusion experts guide you to the right answer.