-
-
Notifications
You must be signed in to change notification settings - Fork 7
/
rds.tf
46 lines (39 loc) · 1.53 KB
/
rds.tf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
# RDS postgres database
resource "aws_db_instance" "postgres-db" {
allocated_storage = 25
max_allocated_storage = 200
engine = "postgres"
engine_version = var.engine_version
instance_class = var.rds_instance_class
db_name = "${var.db_name}${var.environment}"
identifier = "${var.db_name}-${var.environment}"
username = "main"
password = random_password.db-password.result
skip_final_snapshot = true
publicly_accessible = false
vpc_security_group_ids = [aws_security_group.rds-postgres-sg.id]
ca_cert_identifier = "rds-ca-rsa2048-g1"
backup_window = "00:00-00:30"
backup_retention_period = 7
db_subnet_group_name = var.db_subnet_group_name
auto_minor_version_upgrade = true
performance_insights_enabled = true
allow_major_version_upgrade = var.allow_major_version_upgrade
storage_type = "gp3"
parameter_group_name = aws_db_parameter_group.parameter-group.name
tags = {
Name = "${var.environment}-rds"
Environment = "var.environment"
}
}
resource "aws_db_parameter_group" "parameter-group" {
name = "${var.db_name}-${var.environment}-parameter-group-${split(".",var.engine_version)[0]}"
family = "postgres${split(".",var.engine_version)[0]}"
lifecycle {
create_before_destroy = true
}
parameter {
name = "random_page_cost"
value = "1.1"
}
}