blob: 88783b76b5f0e44985c74622e78fbde16ebd3b00 (
plain)
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
data "aws_availability_zones" "available" {}
module "vpc" {
source = "terraform-aws-modules/vpc/aws"
version = "5.12.1"
name = var.project_name
cidr = "10.0.0.0/16"
azs = data.aws_availability_zones.available.names
public_subnets = ["10.0.4.0/24", "10.0.5.0/24", "10.0.6.0/24"]
enable_dns_hostnames = true
enable_dns_support = true
}
resource "aws_db_subnet_group" "Terrific-Totes-sub-gr" {
name = "tt-db-subnet"
subnet_ids = module.vpc.public_subnets
tags = {
Name = "${var.project_name}"
}
}
resource "aws_security_group" "rds" {
name = "${var.project_name}-rds"
vpc_id = module.vpc.vpc_id
ingress {
from_port = 5432
to_port = 5432
protocol = "tcp"
cidr_blocks = ["0.0.0.0/0"]
}
egress {
from_port = 5432
to_port = 5432
protocol = "tcp"
cidr_blocks = ["0.0.0.0/0"]
}
tags = {
Name = "${var.project_name}-rds"
}
}
resource "aws_db_parameter_group" "Terrific-Totes-param-gr" {
name = "tt-db-param"
family = "postgres14"
parameter {
name = "log_connections"
value = "1"
}
}
resource "aws_db_instance" "terrific-totes-rds" {
db_name = var.project_name
instance_class = "db.t3.micro"
allocated_storage = 5
engine = "postgres"
engine_version = "14.10"
username = "totes"
password = "totes123"
# username = "user credentials for the root user" # we could use .env here
# password = "user password for the root user" # we could use .env here
### alternatively to providing username nad password we can specify:
# resource "aws_kms_key" "example_key" {
# description = "Example KMS Key"
# }
# within the resource:
# manage_master_user_password = true
# master_user_secret_kms_key_id = aws_kms_key.example.key_id
# }
db_subnet_group_name = aws_db_subnet_group.Terrific-Totes-sub-gr.name
vpc_security_group_ids = [aws_security_group.rds.id]
parameter_group_name = aws_db_parameter_group.Terrific-Totes-param-gr.name
publicly_accessible = false
skip_final_snapshot = true
}
|
