PostgreSQL

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

Example Usage


postgresql-integration.tf
resource "apono_integration" "postgresql-integration" {
  name                     = "PostgreSQL"
  type                     = "postgresql"
  connector_id             = "apono-connector-id"
  connected_resource_types = ["postgresql-database"]
  metadata = {
    hostname = "<Hostname>"
    port = "<Port>"
    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)>"
  }
  kubernetes_secret = {
    name      = "name_template_value"
    namespace = "namespace_template_value"
  }
}

Schema


  • type postgresql

  • connected_resource_types List of resource types to sync.

Available resource types you can use
  • postgresql-database

  • postgresql-table

  • postgresql-role

Integration Config


  • hostname (Required | String) Hostname

  • port (Required | String) Port

    • Default value: 5432

  • dbname (Required | String) Database Name

    • Default value: postgres

  • sslmode (Required | String) SSL Mode

    • Default value: disable

    • 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)

Last updated

Was this helpful?