terraform/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
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
# }