resource "aws_db_parameter_group" "default" {
  name        = "${var.environment == "production" ? "production-" : ""}qa-reports-postgresql-params"
  family      = "postgres9.6"
  description = "RDS default cluster parameter group"

  parameter {
    name  = "log_min_duration_statement"
    value = 500
  }
}

resource "aws_db_instance" "default" {
    allocated_storage = 50
    storage_type = "gp2" # SSD
    apply_immediately = true
    engine = "postgres"
    instance_class = "db.${var.db_host_size}"
    name = "${var.environment}qareports"
    username = "qareports"
    password = "${var.rds_db_password}"
    availability_zone = "${element(keys(var.availability_zone_to_subnet_map), 0)}"
    db_subnet_group_name = "${aws_db_subnet_group.default.name}"
    parameter_group_name = "${aws_db_parameter_group.default.name}"
    multi_az = false
    backup_retention_period = 7 # days
    backup_window = "23:20-23:50"
    maintenance_window = "Sun:20:00-Sun:23:00"
    vpc_security_group_ids = ["${aws_security_group.qa-reports-db-sg.id}"]
}


~ module.rds.aws_db_parameter_group.default
      parameter.#:                       "3" => "1"
      parameter.176433.apply_method: "immediate" => "immediate"
      parameter.176433.name:         "log_min_duration_statement" => "log_min_duration_statement"
      parameter.176433.value:        "500" => "500"
      parameter.179042.apply_method: "immediate" => ""
      parameter.179042.name:         "log_statement" => ""
      parameter.179042.value:        "none" => ""
      parameter.49069.apply_method:  "immediate" => ""
      parameter.49069.name:          "auto_explain.log_min_duration" => ""
      parameter.49069.value:         "500" => ""