New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"Invalid DB engine" when creating AWS/RDS Postgresql instance #4492

Closed
hashibot bot opened this Issue May 9, 2018 · 5 comments

Comments

Projects
None yet
6 participants
@hashibot
Copy link

hashibot bot commented May 9, 2018

This issue was originally opened by @a9tm as hashicorp/terraform#18009. It was migrated here as a result of the provider split. The original body of the issue is below.


I'm trying to launch a RDS Postgres instance but failed.

Terraform Version

Terraform v0.11.7
+ provider.aws v1.17.0

Terraform Configuration Files

resource "aws_db_subnet_group" "postgres" {
  name       = "postgres-subnets"
  subnet_ids = ["${var.net_priv_a_var}", "${var.net_priv_b_var}"]

  tags {
    Name = "Postgres DB subnet group"
  }
}
resource "aws_db_instance" "postgres" {
  allocated_storage    = 10
  storage_type         = "gp2"
  engine               = "postgresql"
  db_subnet_group_name = "${aws_db_subnet_group.postgres.id}"
  engine_version       = "9.6.6"
  instance_class       = "db.t2.small"
  name                 = "***"
  username             = "***"
  password             = "***"
}

Debug Output

Crash Output

Expected Behavior

RDS instance be created

Actual Behavior

* aws_db_instance.postgres: Error creating DB Instance: InvalidParameterValue: Invalid DB engine
        status code: 400, request id: 8f7e8cd3-94fb-45a6-b295-xxx

Steps to Reproduce

Additional Context

References

@VEBERArnaud

This comment has been minimized.

Copy link
Contributor

VEBERArnaud commented May 9, 2018

Hi,
Have you tried with postgres engine (instead of postgresql) ?

Valid engines are listed here (https://docs.aws.amazon.com/cli/latest/reference/rds/create-db-instance.html), at the --engine section

@a9tm

This comment has been minimized.

Copy link

a9tm commented May 15, 2018

postgres works instead of postgresql, I hope terraform docs mention this piece. On the other thought, I wonder why it's not mys instead of mysql?

@antonbabenko

This comment has been minimized.

Copy link
Contributor

antonbabenko commented Jun 21, 2018

This is how AWS decided to call it. Terraform AWS provider is using AWS SDK.

The complete list of engines is listed here under "Engine" section.

@radeksimko

This comment has been minimized.

Copy link
Contributor

radeksimko commented Jun 21, 2018

As @antonbabenko rightly mentioned we have the link to supported engines in relevant docs.
I don't believe there's more we can do at this point so I'm going to close this.

Thanks

@radeksimko radeksimko closed this Jun 21, 2018

@avengers009

This comment has been minimized.

Copy link

avengers009 commented Jun 21, 2018

usage:
engine = "postgres"

Should fix. @radeksimko thanks for closing :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment