Solution:Step 1: Proxy port forwardingThe proxy listens on localhost:5432 and forwards connections to Cloud SQL.Step 2: psql connectionpsql connecting to 127.0.0.1:5432 will connect through the proxy to Cloud SQL.Final Answer:psql connects successfully to the Cloud SQL PostgreSQL instance via the pr

[Solved] If you run:cloud_sql_proxy -instances=my-project:us-central1:my-instance=tcp:5432and then execute:psql -h 127.0.0.1 -p 5432 -U user dbnamewhat is the expected outcome? | GCP

GCP - Cloud SQL and Databases

If you run:
cloud_sql_proxy -instances=my-project:us-central1:my-instance=tcp:5432
and then execute:
psql -h 127.0.0.1 -p 5432 -U user dbname
what is the expected outcome?

Apsql fails because port 5432 is not forwarded by the proxy

Bpsql connects successfully to the Cloud SQL PostgreSQL instance via the proxy

Cpsql connects to a local PostgreSQL server instead of Cloud SQL

Dpsql returns a syntax error due to incorrect command

Step-by-Step Solution

Solution:

Step 1: Proxy port forwarding
The proxy listens on localhost:5432 and forwards connections to Cloud SQL.
Step 2: psql connection
psql connecting to 127.0.0.1:5432 will connect through the proxy to Cloud SQL.
Final Answer:
psql connects successfully to the Cloud SQL PostgreSQL instance via the proxy -> Option B
Quick Check:
Proxy forwards port 5432 for PostgreSQL [OK]

Quick Trick: psql connects via proxy on forwarded port [OK]

Common Mistakes:

Assuming port 5432 is not forwarded
Thinking psql connects locally by default
Confusing command syntax

Master "Cloud SQL and Databases" in GCP

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More GCP Quizzes

If you run:

Step 1: Proxy port forwarding

Step 2: psql connection

Final Answer:

Quick Check:

Want More Practice?