I am not able to connect through pgAdmin4 to Google Cloud SQL. Following are the credentials I am providing and getting the error messege:
1
-
Are you configuring access for public IP connections?Nibrass H– Nibrass H2020-02-07 12:39:30 +00:00Commented Feb 7, 2020 at 12:39
Add a comment
|
4 Answers
To connect with Google Cloud SQL using pgadmin client, you should use cloud_sql_proxy
These are the steps you need to follow:
Note: on Linux, the proxy is often called cloud_sql_proxy, on Windows, it is typically cloud-sql-proxy, or cloud-sql-proyx.x64. Make sure the binary is accessible through your PATH.
Get the connection string, or connection name from GCP here:
Establish connection to Postgres.
a) On older cloud proxy versions:
cloud_sql_proxy -instances=<connection_string>=tcp:5433b) on recent (2024 and later) cloud proxy versions:
cloud-sql-proxy <connection_string> --port 5433 --run-connection-test(the added
--run-connection-testwill ensure that the connection works by testing the connection, otherwise the proxy will exit).If you receive an error on the port, it may be in use. Choose a different port like 5434 or anything, really.
After executing
cloud_sql_proxy, you will see something like this
Now create a new server connection using pgadmin client. Use the port number you specified in step (2).
If you followed those steps properly it will connect and you can use it as if you were using a local pgadmin install.
Comments
If you are configuring access for public IP connections, follow the next steps to connect with PgAdmin:
1) Create your PostgreSQL instance in Google Cloud Platform.
2) While creating the instance,
In Instance ID tab, write a name for your instance
In Default user password tab, write a password.
Choose the region.
Click on configuration options, go to Connectivity, enable Public IP, under Authorized networks, add network and their write the IP address of your PC. You can check the IP address in the link .
- Click on create.
Then in PgAdmin:
1) In Host name/address put Public IP address of the instance.
1 Comment
John Hanley
This is a good answer. One suggestion is to show how to use the Cloud SQL Proxy which improves security.
Nibrass H has perfectly answered this question. But I would like to add that if you have already created the Instance, then you can click on 'Edit Instance' and Add your IP in 'Connections'.
Adding some Images to help you.
Comments
When I received Unable to connect to server: timeout expired error, the following steps helped:
- Opened up GCP
- then into your db instance > connections
- Under Network you'll see Add new network
- Enter any name and enter your IP to allow local host connections. ( your ip can be found here at: https://whatismyipaddress.com/
For more info refer to this helpful doc.
