05-postgres.tf 911 B

12345678910111213141516171819202122232425262728293031323334353637
  1. # ==========================
  2. # YC MDB Postgress Resources
  3. # ==========================
  4. resource "yandex_mdb_postgresql_cluster" "pg_cluster" {
  5. name = var.pg_db_name
  6. environment = "PRODUCTION"
  7. network_id = yandex_vpc_network.network-keycloak.id
  8. config {
  9. version = 14
  10. resources {
  11. resource_preset_id = "s2.micro"
  12. disk_type_id = "network-ssd"
  13. disk_size = 10
  14. }
  15. }
  16. host {
  17. zone = var.zone
  18. subnet_id = yandex_vpc_subnet.keycloaksubnet[0].id
  19. }
  20. }
  21. resource "yandex_mdb_postgresql_user" "pg_user" {
  22. cluster_id = yandex_mdb_postgresql_cluster.pg_cluster.id
  23. name = var.pg_db_user
  24. password = var.pg_db_pass
  25. }
  26. resource "yandex_mdb_postgresql_database" "pg_db" {
  27. cluster_id = yandex_mdb_postgresql_cluster.pg_cluster.id
  28. name = var.pg_db_name
  29. owner = yandex_mdb_postgresql_user.pg_user.name
  30. lc_collate = "en_US.UTF-8"
  31. lc_type = "en_US.UTF-8"
  32. }