Problem
User when When connecting a Private CDF instance to a Private PostgreSQL, you see the following connection.
Connection to :5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
...
Assuming the private CDF instance is create created as per instructions here and also the private Cloud SQL or PostgreSQL is created as required.
Now that both the instances are setupset up, create a private GCE VM (with only internal IP) using the following
gcloudcommand:
...
Once the VM is created with a static IP, now use this as the host for the mysql or postgresql database to be accessed from Cloud Data Fusion.
...