resource "aws_db_parameter_group" "mpub-stage-db-config-pg14" {
  name   = "mpub-stage-db-config-pg14"
  family = "postgres14"

  parameter {
    apply_method = "pending-reboot"
    name         = "autovacuum_naptime"
    value        = "30"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "huge_pages"
    value        = "off"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "log_duration"
    value        = "1"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "log_error_verbosity"
    value        = "verbose"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "log_min_duration_statement"
    value        = "3600000"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "log_min_error_statement"
    value        = "log"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "log_min_messages"
    value        = "error"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "log_rotation_age"
    value        = "1440"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "log_rotation_size"
    value        = "0"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "log_statement"
    value        = "ddl"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "max_connections"
    value        = "2500"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "max_prepared_transactions"
    value        = "2500"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "rds.force_ssl"
    value        = "1"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "search_path"
    value        = "\"$user\",public,mpub"
  }

  parameter {
    apply_method = "pending-reboot"
    name         = "rds.logical_replication"
    value        = "1"
  }

  lifecycle {
    create_before_destroy = true
  }
}

resource "aws_db_parameter_group" "msrv-rds-stage-db-pg-80" {
  name   = "msrv-rds-stage-db-pg-80"
  family = "aurora-mysql8.0"
  description = "Custom instance parameter group for Aurora MySQL 8.0"

  parameter {
    apply_method = "pending-reboot"
    name  = "init_connect"
    value = "CALL mysql.change_time_zone"
  }

  parameter {
    apply_method = "pending-reboot"
    name  = "max_connections"
    value = "2500"
  }
}