Cloud SQL Listening Port

[Ronald Ruijs]

Hello,

I have a Cloud SQL Postgresql instance running. 

Anyone who knows how to get/set the port on the instance is listening via CGP Console?

Best regards, Ronald

[George (Cloud Platform Support)]

Hello Ronald, 

You may use the gcloud sql instances patch [INSTANCE_NAME] --assign-ip command to ad an IP address, as indicated on the "Configuring Public IP Connectivity" page. It all depends on where do you connect from; you can connect to a Cloud SQL instance using the following methods:

• By using the proxy
• By configuring access for one or more public IP addresses
• By using the JDBC Socket Factory (for the Java programming language)
• By using the Cloud SQL Proxy library (for the Go programming language)

You may have a further look at the "Connecting to Cloud SQL from External Applications" documentation page. Most of the methods do not rely heavily on specific IP address configuration, and you can choose the method that best works for you. 

[Ronald Ruijs]

Hi George,

Thanks for your reply. My question was how to get/set port number, not ip-address.

Can that be done using GCP Console and/or REST API?

Regards, Ronald

Op maandag 17 december 2018 17:36:33 UTC+1 schreef Ronald Ruijs:

[yka...@google.com]

Hello Ronald,

There is no way to set or get the port on your Postgres Cloud SQL instance through the API or the console since Cloud SQL uses the default PostgreSQL port, 5432.