#
# Anthony Vitale Nov 21, 2023 Change Database versions from 14.7 to 14.9
#
#
# Anthony Vitale Feb 12, 2024 change 
#
# 1) lsd-rds-pgdbstbmg1-dev-global-instance-2 instance ca_cert_identifier to rds-ca-rsa2048-g1
#
#
# Anthony Vitale Feb 21, 2024 change 
#
# 1) lsd-rds-pgdbsibmg1-int-global-instance-2 instance ca_cert_identifier to rds-ca-rsa2048-g1
#
#
#Anthony Vitale Sept 24 2025
#  Changed Instance lsd-rds-pgdbstbmg1-dev-global-instance-2 from V14 to V17
#
#
# Anthony Vitale Oct 8, 2025 Updated Instance lsd-rds-pgdbsibmg1-int-global-instance-2 to Version V17 
#
# Anthony Vitale Jan 21, 2026 
# Change Aurora Clusters auto_minor_version_upgrade to false to Correct Drift
#
#
# Anthony Vitale March 2 2026 
# Change Aurora Clusters auto_minor_version_upgrade to true to Correct Drift
# Change lsd-rds-pgdbsibmg1-int-global-cluster-1 to V17.7 in next maint window
#


resource "aws_rds_cluster_instance" "lsd-rds-pgdbsibmg1-int-global-instance-2" {
  apply_immediately                     = null
  auto_minor_version_upgrade            = true
  availability_zone                     = "us-east-1b"
  ca_cert_identifier                    = "rds-ca-rsa2048-g1"
  cluster_identifier                    = "lsd-rds-pgdbsibmg1-int-global-cluster-1"
  copy_tags_to_snapshot                 = false
  db_parameter_group_name               = "default.aurora-postgresql17"
  db_subnet_group_name                  = "grpsnv-d3-rds-sng"
  engine                                = "aurora-postgresql"
  engine_version                        = "17.7"
  identifier                            = "lsd-rds-pgdbsibmg1-int-global-instance-2"
  identifier_prefix                     = null
  instance_class                        = "db.r7g.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:us-east-1:230315258045:key/efa04e80-b138-435d-aece-85e6f9cb9bce"
  performance_insights_retention_period = 7
  preferred_backup_window               = "08:12-08:42"
  preferred_maintenance_window          = "sun:03:40-sun:04:10"
  promotion_tier                        = 1
  publicly_accessible                   = false
  tags = {
    Team-Name = "GRPS-RDX-RDXTRXMGR"
  }
  tags_all = {
    Team-Name = "GRPS-RDX-RDXTRXMGR"
  }
}

resource "aws_rds_cluster_instance" "lsd-rds-pgdbstbmg1-dev-global-instance-2" {
  apply_immediately                     = null
  auto_minor_version_upgrade            = true
  availability_zone                     = "us-east-1b"
  ca_cert_identifier                    = "rds-ca-rsa2048-g1"
  cluster_identifier                    = "lsd-rds-pgdbstbmg1-dev-global-cluster-1"
  copy_tags_to_snapshot                 = false
  db_parameter_group_name               = "default.aurora-postgresql17"
  db_subnet_group_name                  = "grpsnv-d3-rds-sng"
  engine                                = "aurora-postgresql"
  engine_version                        = "17.7"
  identifier                            = "lsd-rds-pgdbstbmg1-dev-global-instance-2"
  identifier_prefix                     = null
  instance_class                        = "db.r7g.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:us-east-1:230315258045:key/efa04e80-b138-435d-aece-85e6f9cb9bce"
  performance_insights_retention_period = 7
  preferred_backup_window               = "05:00-05:30"
  preferred_maintenance_window          = "sat:06:39-sat:07:09"
  promotion_tier                        = 1
  publicly_accessible                   = false
  tags = {
    Team-Name = "GRPS-RDX-RDXTRXMGR"
  }
  tags_all = {
    Team-Name = "GRPS-RDX-RDXTRXMGR"
  }
}