03-basics: Error creating the database instance

[carlos-salinas]

Executing terraform apply in the web-app folder the database instance provisioning fails:

aws_db_instance.db_instance: Creating...
╷
│ Error: Error creating DB Instance: InvalidParameterCombination: Cannot find version 9.5 for postgres
│       status code: 400, request id: 9085a882-f29c-4d65-a328-597a9ffa17ba
│ 
│   with aws_db_instance.db_instance,
│   on main.tf line 200, in resource "aws_db_instance" "db_instance":
│  200: resource "aws_db_instance" "db_instance" {
│ 

[sidpalas]

Do you have a requirement to use 9.5? I don't think RDS supports it anymore.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.DBVersions

[carlos-salinas]

Correct! I modified manually the previous snippet trying to put back 12.5 and incorrectly I set 9.5 because I tried with several versions and none of then worked. Moreover, I checked the version drop-down at AWS Console and seems 12.5 is not available anymore.

[DmitriKonnovNN]

Unfortunately, available DB-versions varies in RDS-service from region to region. This confuses.

[MarcPadrosJimenez]

In relation to this open issue, I am dealing with the following error:
Error: Error creating DB Instance: InvalidParameterCombination: RDS does not support creating a DB instance with the following combination: DBInstanceClass=db.t2.micro, Engine=postgres, EngineVersion=12.19, LicenseModel=postgresql-license. For supported combinations of instance class and database engine version, see the documentation. │ status code: 400, request id: dd8cce7e-1c08-4a4b-9a73-580b58af8955 │ │ with aws_db_instance.db_instance, │ on main.tf line 205, in resource "aws_db_instance" "db_instance": │ 205: resource "aws_db_instance" "db_instance" {

How can I solve it? I checked for AWS documentation, but I didn't find which is a compatible PostgreSQL version for db.t2.micro.
I hope someone can give me any clue.
Thank you.