Recipe

postgres-cloud-sql

PostgreSQL on Google Cloud SQL, as one instance with a private IP address in the operator's VPC network, realized by the postgresql module of the terraform-google-modules project's published Cloud SQL module, terraform-google-modules/sql-db/google at v28.3.0, Apache-2.0, fetched from its git repository at that tag; entity.lock pins the tag's commit and archive digest. Reach for it where the database is a Cloud SQL instance in the operator's Google Cloud project, reached over a VPC network that already has private services access to Cloud SQL; on AWS, reach for the terraform/postgres-rds Recipes, and for the helm or compose Recipes where PostgreSQL runs as a container. The project, region and network are the operator's, named in infra.overrides.project_id, region and private_network, and the Recipe emits none of them. The instance gets no public address. Point-in-time recovery is on, as Cloud SQL's high availability needs, unless the core/backup attachment sets infra.point_in_time_recovery to false, which halts beside infra.ha.enabled. The user values.user names logs in with the core/random-password attachment on the password slot, handed over as a Terraform reference, or, with none attached, a password the module draws; either way the rendered files carry no password, and another credential halts naming the slot. host publishes a reference to the instance's private address, or the DNS name in infra.overrides.host; port is 5432, the one port the service serves. An encoding or locale the service cannot set, init scripts, a raw configuration file and another infra.port halt naming the key; compute.cpu and compute.memory are not read, because infra.overrides.tier sizes the instance.

Provenance

OfficialSigned by a signing identity this catalog recognizes as an official publisher.
Content digest
sha256:c9d3dd24b606e80e399802755b779ac183ede802376675979175645f6351df7b
Published
2026-11-10T10:28:37Z
Signing identity
https://token.actions.githubusercontent.com/https://github.com/aggrega-ai/aggrega-hub/.github/workflows/catalog-publish-sign.yml@refs/heads/main

Signature

  • Officialapplication/vnd.dev.sigstore.bundle.v0.3+json

    https://token.actions.githubusercontent.com/https://github.com/aggrega-ai/aggrega-hub/.github/workflows/catalog-publish-sign.yml@refs/heads/main

    sha256:390c657b527afd6da69e2a91d6831841fba780b04b9827c804e4b0c3ae32f8b0

Reference at this version

oci://hub.aggrega.ai/recipe/terraform/postgres-cloud-sql:1.0.0
Target
—
Implements
core/datastore/postgres:1.0.0

Provides

Deterministic pointer templates this recipe wires for consumers.

NameTemplate
host{{ if .locals.operator_host }}{{ .locals.operator_host }}{{ else }}${module.{{ .context.instance_id }}.private_ip_address}{{ end }}
port5432
user{{ .values.user }}
database{{ .values.database }}
protocolpostgres
metrics_pod_selector
metrics_pod_port
metrics_path

Workload

No workload template declared.

Locals

NameTemplate
major{{ $v := toString .infra.engine_version }}{{ if regexMatch `^9\.6(\.|$)` $v }}9_6{{ else }}{{ regexFind `^[0-9]+` $v }}{{ end }}
edition{{ optional (optional .infra "overrides" dict) "edition" "ENTERPRISE" }}
tier{{ optional (optional .infra "overrides" dict) "tier" "db-custom-1-3840" }}
disk_type{{ default "PD_SSD" (optional .infra.storage "type" "") }}
operator_host{{ $h := optional (optional .infra "overrides" dict) "host" "" }}{{ if typeIs "string" $h }}{{ $h }}{{ end }}
native_backupCloud SQL automated backups

Values mapping

No values mapping declared.

Relationships

Typed edges to and from other published entities. A reference with no published target renders as a broken edge rather than a link.

Uses

  • implementsimplementscontract compatible

    core/datastore/postgres:1.0.0

    All required outputs are satisfied and every provided output is named in the contract.

Used by

Nothing in the catalog depends on this entity.

Recipe concept reference →

The Aggrega catalog — an open index of components, features, recipes, and the plugins that render them.

Built with the shared Aggrega design system.

Privacy