We are using 0.12.26 version of terraform and tested the upgrade with 3.40, 3.74 and 4.13.0 providers.
upgrade from 10.20 to 12.10 as well as 10.20 to 11.15 failing with below same error .
Error: error modifying RDS Cluster Instance (depten-aps-dbd): InvalidParameterCombination: The Parameter Group dbf-aurora-postgresql12 with DBParameterGroupFamily aurora-postgresql12 cannot be used for this instance. Please use a Parameter Group with DBParameterGroupFamily aurora-postgresql10
status code: 400, request id: 3a1d4560-9c18-4147-b805-a1cf1be7fa30
module “aurora” {
providers = {
aws = aws.region
}
source = “…/modules/aurora_db12”
cluster_identifier = “{local.cluster_identifier}"
global_cluster_identifier = "{local.global_cluster_identifier}”
global_cluster_required = “${var.global_cluster_required}”
environment = “{var.environment}"
application_id = "{var.application_id}”
account_id = “{data.aws_caller_identity.current.account_id}"
master_password = "{local.master_password}”
master_username = “{local.master_username}"
engine = "{var.engine}”
instance_flavour = “{var.instance_flavour}"
db_subnet_group_name = "{var.db_subnet_group_name}”
region = “{var.region}"
source_region = "{var.source_region}”
enable_replica = “{var.enable_replica}"
ca_cert_identifier = "{var.ca_cert_identifier}”
kms_key_id = “{data.aws_kms_alias.kms.target_key_arn}"
securitygroup_id = "{local.rds_securitygroups}” //“{local.rds_securitygroups}",
db_cluster_parameter_group_name = "{var.db_parameter_group_name}”
db_parameter_group_name = “{var.db_parameter_group_name}"
snapshot_identifier = "{var.snapshot_identifier}”
storage_encrypted = “{var.storage_encrypted}"
multi_az = "{var.multi_az}”
publicly_accessible = “{var.publicly_accessible}"
allow_major_version_upgrade = "{var.allow_major_version_upgrade}”
auto_minor_version_upgrade = “{var.auto_minor_version_upgrade}"
apply_immediately = "{var.apply_immediately}”
iam_database_authentication_enabled = “false”
skip_final_snapshot = “{var.skip_final_snapshot}"
copy_tags_to_snapshot = "{var.copy_tags_to_snapshot}”
backup_retention_period = “{var.backup_retention_period}"
postgre_parameter_group_name = "{var.postgre_parameter_group_name}”
id_dbrole = “{var.id_dbrole}"
postgre_version = "{var.postgre_version}”
postgre_port = “{var.postgre_port}"
id_dbengine = "{var.id_dbengine}”
monitoring_interval = “{var.monitoring_interval}"
monitoring_role = "{var.monitoring_role}”
storage_type = “{var.storage_type}"
preferred_backup_window = "{var.preferred_backup_window}”
cluster_preferred_maintenance_window = “{var.cluster_preferred_maintenance_window}"
instance_preferred_maintenance_window = "{var.instance_preferred_maintenance_window}”
replica_preferred_maintenance_window = “{var.replica_preferred_maintenance_window}"
backup_window = "{var.backup_window}”
database_name = “{local.database_name}"
instance_class = "{var.instance_class}”