Azure PostgreSQL

Azure Database for PostgreSQL is a relational database service based on the open-source Postgres database engine. It's a fully managed database-as-a-service that can handle mission-critical worklo

Example Usage

---

Terraform

azure-postgresql-integration.tf

resource "apono_integration" "azure-postgresql-integration" {
  name                     = "Azure PostgreSQL"
  type                     = "azure-postgresql"
  connector_id             = "apono-connector-id"
  connected_resource_types = ["azure-postgresql-database"]
  metadata = {
    hostname = "<Hostname>"
    port = "<Port>"
    dbname = "<Database Name>"
    sslmode = "<SSL Mode>"
  }
  kubernetes_secret = {
    name      = "name_template_value"
    namespace = "namespace_template_value"
  }
}

Terraform V2

azure-postgresql-integration.tf

resource "apono_resource_integration" "azure-postgresql-integration" {
  name                     = "Azure PostgreSQL"
  type                     = "azure-postgresql"
  connector_id             = "apono-connector-id"
  connected_resource_types = ["azure-postgresql-database"]
  integration_config = {
    hostname = "<Hostname>"
    port = "<Port>"
    dbname = "<Database Name>"
    sslmode = "<SSL Mode>"
  }
  secret_store_config = {
    kubernetes = {
      name      = "name_template_value"
      namespace = "namespace_template_value"
    }
}

Public API

azure-postgresql-integration.json

{
    "azure-postgresql-integration": {
        "name": "Azure PostgreSQL",
        "type": "azure-postgresql",
        "connector_id": "apono-connector-id",
        "connected_resource_types": [
            "azure-postgresql-database"
        ],
        "integration_config": {
            "hostname": "<Hostname>",
            "port": "<Port>",
            "dbname": "<Database Name>",
            "sslmode": "<SSL Mode>",
        },
	"secret_store_config": {
    	    "name": "name_template_value",
    	    "namespace": "namespace_template_value"
  	    }
    }
}

Schema

---

• type azure-postgresql

• connected_resource_types List of resource types to sync.

Available resource types you can use

• azure-postgresql-database

• azure-postgresql-table

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