1
resource "mws_vpc_network" "network" {
2
  network = var.network_name
3
}
4

5
resource "mws_vpc_subnet" "subnet" {
6
  subnet  = var.subnet_name
7
  network = mws_vpc_network.network.network
8
  cidr    = var.subnet_cidr
9
}
10

11
resource "mws_vpc_address" "cluster_primary_address" {
12
  address = "${var.cluster_name}-primary-address"
13
  network = mws_vpc_network.network.network
14
  subnet  = mws_vpc_subnet.subnet.metadata.id
15
}
16

17
resource "mws_mpostgres_cluster" "cluster" {
18
  cluster = var.cluster_name
19
  version = "17"
20
  active  = true
21

22
  metadata = {
23
    display_name = "Standalone Postgres Cluster"
24
    description  = "A standalone PostgreSQL cluster"
25
  }
26

27
  endpoints = [
28
    {
29
      name    = "primary-endpoint"
30
      network = mws_vpc_network.network.metadata.id
31
      primary_addresses = [
32
        {
33
          ref = mws_vpc_address.cluster_primary_address.metadata.id
34
        }
35
      ]
36
    }
37
  ]
38

39
  instance_template = {
40
    vm_type = "vmTypes/gen-2-8"
41
    disk = {
42
      size = "20GB"
43
      type = "NETWORK_STANDARD_SSD"
44
    }
45
  }
46

47
  instances = [
48
    {
49
      count = 1
50
      zone  = "ru-central1-a"
51
    }
52
  ]
53
}
54

55
resource "mws_mpostgres_cluster_user" "user" {
56
  cluster          = mws_mpostgres_cluster.cluster.cluster
57
  user             = var.user_name
58
  password         = var.user_password
59
  password_version = 1
60
  role             = "DB_OWNER_USER"
61
}
62

63
resource "mws_mpostgres_cluster_database" "db" {
64
  cluster             = mws_mpostgres_cluster.cluster.cluster
65
  database            = var.database_name
66
  owner               = mws_mpostgres_cluster_user.user.metadata.id
67
  deletion_protection = false
68
}
69

70
variable "cluster_name" {
71
  type        = string
72
  default     = "my-pg-cluster"
73
  description = "Postgres cluster name"
74
}
75

76
variable "database_name" {
77
  type        = string
78
  default     = "example"
79
  description = "Database name"
80
}
81

82
variable "user_name" {
83
  type        = string
84
  default     = "my-pg-cluster-user"
85
  description = "Database user name"
86
}
87

88
variable "user_password" {
89
  type        = string
90
  description = "Database user password"
91
  sensitive   = true
92
}
93

94
variable "network_name" {
95
  type        = string
96
  default     = "my-pg-cluster-network"
97
  description = "Network name"
98
}
99

100
variable "subnet_name" {
101
  type        = string
102
  default     = "my-pg-cluster-subnet"
103
  description = "Subnet name"
104
}
105

106
variable "subnet_cidr" {
107
  type        = string
108
  default     = "192.168.10.0/24"
109
  description = "Subnet CIDR"
110
}