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. — Matthew Schuchard
– Matthew Schuchard, Commented May 2, 2019 at 13:08

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

6

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.

answered May 3, 2019 at 9:09

simon Le Ster

9811 gold badge7 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

StephenG · Accepted Answer · 2019-05-02 21:03:41Z

3

aurora-postgresql is an AWS managed DB and does not offer storage_type as a configuration parameter.

If storage_type is a required configuration, using AWS RDS postgres is probably best.

If Aurora management is desired, the DB instance type can be configured for maximum performance.

answered May 2, 2019 at 21:03

StephenG

2,8911 gold badge20 silver badges37 bronze badges

Collectives™ on Stack Overflow

storage type error with terraform and aurora postgresql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related