How to create Cloud SQL Postgres Db Instance on GCP and Connect from Local PC using PgAdmin4

In this tutorial we will look at how to create Cloud SQL Postgres Database Instance on Google Cloud Platform (GCP).
We will also look at how to access this remote Cloud SQL Postgres Database Instance on GCP from the local PC with the help of PgAdmin4.

Contents
00:00 Intro
00:22 Login to the GCP
00:32 Create a new Project
01:09 Enable Cloud Engine API
01:40 Create Cloud SQL database of type PostgreSQL
01:47 Instance Info
02:31 Choosing a Configuration to start with
04:08 Customize your Instance
04:15 Choosing the Machine Type
04:43 Choosing the Storage Type
05:35 Configuring Connections on a Cloud SQL Database Instance
05:55 Authorize Client IP address of local PC on Cloud SQL Database Instance
06:28 Defining Data Protection on Cloud SQL Instance
07:06 Defining Maintenance window for Cloud SQL Instance
09:16 Resources for Installing PgAdmin on Local PC
10:06 Navigating to Cloud SQL Database Instance
11:33 Reset Forgot Password or Change Password of Database User on Cloud SQL
12:00 Create Database User
12:39 Register a Server on PgAdmin that connects to Cloud SQL on GCP
13:55 Create a database on Cloud SQL Database Instance from PgAdmin
14:16 Verify DB Created on Cloud SQL Instance from GCP
14:50 Delete a database on Cloud SQL Database Instance from PgAdmin
15:12 Verify DB Deleted on Cloud SQL Instance from GCP
15:20 Outro

This video is a part of the series "ASP.NET Core on Google Cloud Platform ⛈️"

#googlecloud #postgresql #pgadmin4 #CloudSQL

@googlecloud @GoogleDevelopers @GoogleDeveloperGroups
------------------------------------------------------------------------------------------------

(っ◔◡◔)っ Share this video with your friends and colleagues and let them know you are up to date with latest tech-trends

Thanks 🙏

Follow us to keep updated with latest trends in Tech:

[arcadior]

Excelente tutorial, funciono a la primera

[giannissavvidis]

When trying to connect usign instance's public IP I get a connection timeout, while if I try to connect using the Outgoing IP address it connects successfully. Do you know why that happens?

[emmanuelumeh]

i keep getting timeouts as well when trying to connect