Google Cloud SQL - PostgreSQL

An open-source relational database management system emphasizing extensibility and SQL compliance.

Example Usage

---

Terraform

gcp-cloud-sql-postgresql-integration.tf

resource "apono_integration" "gcp-cloud-sql-postgresql-integration" {
  name                     = "Google Cloud SQL - PostgreSQL"
  type                     = "gcp-cloud-sql-postgresql"
  connector_id             = "apono-connector-id"
  connected_resource_types = ["gcp-cloud-sql-postgresql-instance"]
  metadata = {
    auth_type = "<Auth Type>"
    gcp_project_id = "<Project ID>"
    gcp_region = "<Region>"
    gcp_instance_id = "<Instance ID>"
    gcp_instance_id_user_override = "<Instance ID User Override>"
    dbname = "<Database Name>"
    sslmode = "<SSL Mode>"
    credentials_rotation_period_in_days = "<Credentials rotation period (in days)>"
    credentials_cleanup_period_in_days = "<User cleanup after access is revoked (in days)>"
  }
  gcp_secret = {
    project    = "project_template_value"
    secret_id  = "gcp_secret_id_template_value"
  }
}

Terraform V2

Public API

Schema

---

• type gcp-cloud-sql-postgresql

• connected_resource_types List of resource types to sync.

Available resource types you can use

• gcp-cloud-sql-postgresql-instance

• gcp-cloud-sql-postgresql-database

• gcp-cloud-sql-postgresql-table

• gcp-cloud-sql-postgresql-role

Integration Config

---

• auth_type (Required | String) Auth Type

  • Possible values: gcp-iam-auth, user-password

• gcp_project_id (Required | String) Project ID

• gcp_region (Required | String) Region

• gcp_instance_id (Required | String) Instance ID

• gcp_instance_id_user_override (Optional | String) Instance ID User Override

• dbname (Required | String) Database Name

  • Default value: postgres

• sslmode (Optional | String) SSL Mode

  • Possible values: disable, allow, prefer, require, verify-ca, verify-full

• credentials_rotation_period_in_days (Optional | String) Credentials rotation period (in days)

• credentials_cleanup_period_in_days (Optional | String) User cleanup after access is revoked (in days)