# # Anthony Vitale Nov 21, 2023 Change Database versions from 14.7 to 14.9 # # # Anthony Vitale Dec 11, 2023 change lsd-rds-pganalyze-01-instance-1 instance ca_cert_identifier to rds-ca-rsa2048-g1 # # # Anthony Vitale Feb 12, 2024 change # # 1) lsd-rds-musicbrainz-01-instance-2 instance ca_cert_identifier to rds-ca-rsa2048-g1 # 2) lsd-rds-pgdbstbmg1-dev-03 instance ca_cert_identifier to rds-ca-rsa2048-g1 # # # Anthony Vitale Feb 21, 2024 change # # # Anthony Vitale Jan 27, 2025 Changed lsd-rds-pganalyze-01 from version 14.9 to 16.6 # # Anthony Vitale June 6, 2025 Adjusted Instance Class of lsd-rds-musicbrainz-01-instance-2 and lsd-rds-pganalyze-01-instance-1 # # Anthony Vitale Aug 18, 2025 Changed # 1) instance_class from db.r6g to db.r7g. # # # Anthony Vitale Aug 25, 2025 Altered lsd-rds-pganalyze-01-instance-1 to version 17 # # # Anthony Vitale Sept 8, 2025 Altered lsd-rds-musicbrainz-01-instance-2 to version 17 # # #Anthony Vitale Sept 24 2025 # Changed instance lsd-rds-pgdbsismed-demo-02 and lsd-rds-pgdbstbmg1-dev-03 from v14 to v17 # # # Anthony Vitale Jan 21, 2026 # Change Aurora Clusters auto_minor_version_upgrade to false to Correct Drift # # # Anthony Vitale Feb 9 2026 # 1) Updated lsd-rds-musicbrainz-01-instance-2 from 17.5 to 17.7 to correct Drift # # # Anthony Vitale March 2 2026 # Change Aurora Clusters auto_minor_version_upgrade to true to Correct Drift # Change lsd-rds-pgdbstbmg1-dev-03 to version 17.7 to Correct Drift # # # Anthony Vitale Removed specific minor version from Cluster lsd-rds-musicbrainz-01 to see if TF handles it correctly. # # # Anthony Vitale Resolve Drift on instance classes for Cluster instance lsd-rds-pgdbsismed-demo-02 and lsd-rds-pgdbstbmg1-dev-03 # # aws_rds_cluster_instance.lsd-rds-musicbrainz-01-instance-2: resource "aws_rds_cluster_instance" "lsd-rds-musicbrainz-01-instance-2" { auto_minor_version_upgrade = true availability_zone = "eu-central-1a" ca_cert_identifier = "rds-ca-rsa2048-g1" cluster_identifier = "lsd-rds-musicbrainz-01" copy_tags_to_snapshot = false db_parameter_group_name = "default.aurora-postgresql17" db_subnet_group_name = "grps-d2-rds-sng" engine = "aurora-postgresql" engine_version = "17" identifier = "lsd-rds-musicbrainz-01-instance-2" instance_class = "db.r7g.2xlarge" monitoring_interval = 5 monitoring_role_arn = "arn:aws:iam::230315258045:role/rds-monitoring-role" performance_insights_enabled = true performance_insights_kms_key_id = "arn:aws:kms:eu-central-1:230315258045:key/21f2d419-2da2-4671-a1d0-67e4ea00a693" performance_insights_retention_period = 7 promotion_tier = 1 publicly_accessible = false tags = { Team-Name = "GRPS-RDX-RDXTRXMGR" } tags_all = { Team-Name = "GRPS-RDX-RDXTRXMGR" } } # aws_rds_cluster_instance.lsd-rds-pganalyze-01-instance-1: resource "aws_rds_cluster_instance" "lsd-rds-pganalyze-01-instance-1" { apply_immediately = null auto_minor_version_upgrade = true availability_zone = "eu-central-1b" ca_cert_identifier = "rds-ca-rsa2048-g1" cluster_identifier = "lsd-rds-pganalyze-01" copy_tags_to_snapshot = false db_parameter_group_name = "default.aurora-postgresql17" db_subnet_group_name = "grps-d2-rds-sng" engine = "aurora-postgresql" engine_version = "17.7" identifier = "lsd-rds-pganalyze-01-instance-1" identifier_prefix = null instance_class = "db.r7g.xlarge" monitoring_interval = 5 monitoring_role_arn = "arn:aws:iam::230315258045:role/rds-monitoring-role" performance_insights_enabled = true performance_insights_kms_key_id = "arn:aws:kms:eu-central-1:230315258045:key/21f2d419-2da2-4671-a1d0-67e4ea00a693" performance_insights_retention_period = 7 preferred_backup_window = "22:11-22:41" preferred_maintenance_window = "sun:04:27-sun:04:57" promotion_tier = 1 publicly_accessible = false tags = { devops-guru-analysis-boundary = "lsd-rds-pganalyze-01" Team-Name = "GRPS-RDX-RDXTRXMGR" } tags_all = { devops-guru-analysis-boundary = "lsd-rds-pganalyze-01" Team-Name = "GRPS-RDX-RDXTRXMGR" } } # aws_rds_cluster_instance.lsd-rds-pgdbsismed-demo-02: resource "aws_rds_cluster_instance" "lsd-rds-pgdbsismed-demo-02" { auto_minor_version_upgrade = true availability_zone = "eu-central-1a" ca_cert_identifier = "rds-ca-rsa2048-g1" cluster_identifier = "lsd-rds-pgdbsismed-demo-01-cluster" copy_tags_to_snapshot = false db_parameter_group_name = "default.aurora-postgresql17" db_subnet_group_name = "grps-d2-rds-sng" engine = "aurora-postgresql" engine_version = "17.7" identifier = "lsd-rds-pgdbsismed-demo-02" instance_class = "db.r8g.4xlarge" monitoring_interval = 5 monitoring_role_arn = "arn:aws:iam::230315258045:role/rds-monitoring-role" performance_insights_enabled = true performance_insights_kms_key_id = "arn:aws:kms:eu-central-1:230315258045:key/21f2d419-2da2-4671-a1d0-67e4ea00a693" performance_insights_retention_period = 7 promotion_tier = 0 publicly_accessible = false tags = { Team-Name = "GRPS-RDX-RDXTRXMGR" } tags_all = { Team-Name = "GRPS-RDX-RDXTRXMGR" } } # aws_rds_cluster_instance.lsd-rds-pgdbstbmg1-dev-03: resource "aws_rds_cluster_instance" "lsd-rds-pgdbstbmg1-dev-03" { auto_minor_version_upgrade = true availability_zone = "eu-central-1b" ca_cert_identifier = "rds-ca-rsa2048-g1" cluster_identifier = "lsd-rds-pgdbstbmg1-dev-01-cluster" copy_tags_to_snapshot = false db_parameter_group_name = "default.aurora-postgresql17" db_subnet_group_name = "grps-d2-rds-sng" engine = "aurora-postgresql" engine_version = "17.7" identifier = "lsd-rds-pgdbstbmg1-dev-03" instance_class = "db.r8g.4xlarge" monitoring_interval = 5 monitoring_role_arn = "arn:aws:iam::230315258045:role/rds-monitoring-role" performance_insights_enabled = true performance_insights_kms_key_id = "arn:aws:kms:eu-central-1:230315258045:key/21f2d419-2da2-4671-a1d0-67e4ea00a693" performance_insights_retention_period = 7 promotion_tier = 1 publicly_accessible = false tags = { "devops-guru-analysis-boundary" = "lsd-rds-pgdbstbmg1-dev-01-cluster" "Team-Name" = "GRPS-RDX-RDXTRXMGR" } tags_all = { "devops-guru-analysis-boundary" = "lsd-rds-pgdbstbmg1-dev-01-cluster" "Team-Name" = "GRPS-RDX-RDXTRXMGR" } }