Spring Boot + PostgreSQL on Google Cloud Run

Why Cloud Run?

Fully managed container hosting, scales down to 0, with minimal DevOps overhead.

Stack

• Spring Boot
• PostgreSQL (Cloud SQL)
• Google Cloud Run

Dockerfile for Cloud Run

dockerfileCopy
FROM eclipse-temurin:17-jdk
COPY target/demo.jar app.jar
ENTRYPOINT ["java", "-jar", "app.jar"]

Connect to Cloud SQL Securely

Use a Cloud SQL Auth Proxy sidecar:

bashCopy
gcloud sql connect mydb --user=postgres --quiet

Add Cloud SQL JDBC URL:

yamlCopy
spring:
  datasource:
    url: jdbc:postgresql://localhost:5432/mydb
    username: postgres
    password: yourpassword

Deploy to Cloud Run

bashCopy
gcloud run deploy demo \
  --source . \
  --region us-central1 \
  --set-env-vars SPRING_PROFILES_ACTIVE=prod

Result

✅ Minimal setup ✅ Easy rollback ✅ Secure SQL connection