Now connecting to Google cloud SQL from pgAdmin becomes so simple with this article. At Bobcares, with our Google Cloud Platform Support Services, we can handle your GCP SQL issues.

Connecting to Google cloud SQL from pgAdmin

The main steps involved in connecting to Google cloud SQL from pgAdmin are the following:

1. Configure GCP and create a database instance in GCP.
2. Install PgAdmin on the remote computer.
3. Connect to GCP Database Instance from PgAdmin.

Step 1

In order to configure GCP and create a GCP database instance, follow the below steps:

1. Firstly, access GCP with the credentials.
2. Now click on “console”. Soon the console will appear.
3. Click the hamburger icon in the upper left corner, then “SQL” in the left nav bar.
4. On the loading page, create the “Create Instance” button.
5. Now choose “PostgreSQL”.
6. Now, on the new page, enter the preferred name for the instance and set the password. Also, keep the password in mind. By default, the password is for the user “Postgres.” It may take a little while for the creation process to complete.

Step 2

In order to install pgAdmin, navigate to the pgAdmin official site and download pgAdmin compatible with the system OS.

Step 3

1. Firstly, on the system, open pgAdmin.
2. Now click on Servers → Create → Server
3. Give this new connection a name. Any preferred name can be used. To complete the process, we have to provide either the Hostname, Address, or Service.
4. So click on “SQL” to see the instance details. Note the hostname OR IP Address & password from GCP.
5. Now add the instance IP address and the password( which is noted while creating the instance) and click “save”.
6. Now an error message prompt will appear. To fix it, find the IP address.
   
7. Then navigate back to GCP and click on the instance → connections.
8. Then click “add network,” which will bring up a form where we can enter the local computer’s IP address in the specified text field. Names are optional. When finished, click “save.”
9. Now go back to the PgAdmin on the computer and try connecting again.
10. The connection is established successfully. Now we can create databases, tables, etc using the PgAdmin tool.

[Searching for an answer to a different question? We’re here to help.]

Conclusion

In this article, we provide some simple steps from our Tech team to connect to Google Cloud SQL from pgAdmin.