resource "postgresql_database" "main" {
  name       = local.database
  owner      = local.owner
  encoding   = "UTF8"
  lc_collate = "en_US.UTF-8"
  lc_ctype   = "en_US.UTF-8"
}

resource "postgresql_database" "pd_etldb" {
  name       = "pd_etldb"
  owner      = postgresql_role.pd_etldb_owner.name
  encoding   = "UTF8"
  lc_collate = "en_US.UTF-8"
  lc_ctype   = "en_US.UTF-8"
}