storage type error with terraform and aurora postgresql

Question

I am currently working on deploying a Aurora postgres instance in AWS thanks to Terraform.

Here is my declaration

resource "aws_db_instance" "postgreDatabase" {
  name = "validName"
  storage_type = "gp2"
  allocated_storage = "25"
  engine = "aurora-postgresql"
  engine_version = "10.5"
  instance_class = "db.r4.large"
  username = "validUsername"
  password = "validPassword"

}

Using this declaration throws the following error:

aws_db_instance.postgreDatabase: Error creating DB Instance: StorageTypeNotSupported: Invalid storage type: gp2

If i change the engine to

engine = "postgres"

, it works fine but i need an aurora instance.

Any idea on what is wrong with my declaration here ?

Thank you very much.

The error message seems to imply that gp2 storage is incompatible with Arurora Postgres. — Matt Schuchard

simon Le Ster simon Le Ster · Accepted Answer · 2019-05-03T09:09:42

Thank you for the help.

I found the solution. Indeed the storage type is not needed for an aurora instance. But it must be created inside a DB cluster. So you first have to create the cluster then create the db instance with the proper cluster identifier.

storage type error with terraform and aurora postgresql

2 Answers