Monday, 14 September 2020

WARNING: AWS Aurora PostgreSQL v10.12, v10.13, and v11.8 have been removed

If you are using RDS Aurora PostgreSQL v10.12, v10.13, or v11.8, please be aware that they have been removed from the catalog and you can no longer create new clusters with these versions.  It will probably give you an error like this:

Error: error creating RDS cluster: InvalidParameterCombination:
Cannot find version 10.12 for aurora-postgresql
status code: 400, request id:

database error - Dr Evil meme | Meme Generator


They used to exist:

https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-aurora-supports-postgresql-11-8-10-13-and-9-6-18/

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Updates.20180305.html

Topics

Version 3.3, Compatible with PostgreSQL 11.8
Version 3.2, Compatible with PostgreSQL 11.7
Version 3.1, Compatible with PostgreSQL 11.6
Version 3.0, Compatible with PostgreSQL 11.4
Version 2.6, Compatible with PostgreSQL 10.13
Version 2.5, Compatible with PostgreSQL 10.12
Version 2.4, Compatible with PostgreSQL 10.11
Version 2.3, Compatible with PostgreSQL 10.7
Version 2.2, Compatible with PostgreSQL 10.6
Version 2.1, Compatible with PostgreSQL 10.5
Version 2.0, Compatible with PostgreSQL 10.4


But not now:

$ aws rds describe-db-engine-versions --engine aurora-postgresql | grep "DBEngineVersionDescription"
"Aurora PostgreSQL (compatible with PostgreSQL 9.6.3)"
"Aurora PostgreSQL (compatible with PostgreSQL 9.6.6)"
"Aurora PostgreSQL (compatible with PostgreSQL 9.6.8)"
"Aurora PostgreSQL (compatible with PostgreSQL 9.6.9)"
"Aurora PostgreSQL (compatible with PostgreSQL 9.6.11)"
"Aurora PostgreSQL (compatible with PostgreSQL 9.6.12)"
"Aurora PostgreSQL (Compatible with PostgreSQL 9.6.16)"
"Aurora PostgreSQL (Compatible with PostgreSQL 9.6.17)"
"Aurora PostgreSQL (Compatible with PostgreSQL 9.6.18)"

"Aurora PostgreSQL (compatible with PostgreSQL 10.4)"
"Aurora PostgreSQL (compatible with PostgreSQL 10.5)"
"Aurora PostgreSQL (compatible with PostgreSQL 10.6)"
"Aurora PostgreSQL (compatible with PostgreSQL 10.7)"
"Aurora PostgreSQL (compatible with PostgreSQL 10.7)"
"Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"

"Aurora PostgreSQL (Compatible with PostgreSQL 11.4)"
"Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
"Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"


Bug Details

The problem relates to "NOT EXISTS" queries, insomuch as v10.12 ignores the "NOT" part, and gives you the exact opposite result.  One workaround is to add "AND <column> is NOT NULL" to all affected queries. I have no information if this also affects v10.13 or v11.8, but I suspect it does as these versions were all pulled from the catalogue at the same time.

If you can't change your code, then you can either: * Downgrade to Aurora PostgreSQL v10.11, either by "pg_dump" or DMS
* Upgrade to Aurora v11.6, as this is the current "preferred minor engine version" for Aurora.



Update 16/09/2020 @ 21:15 (GMT)

v10.12 is back in some regions, but v10.13, and v11.8 are still missing:

REGION: us-east-2
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
REGION: us-east-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: us-west-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: us-west-2
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: ap-south-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: ap-northeast-2
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: ap-southeast-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: ap-southeast-2
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
REGION: ap-northeast-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
REGION: ca-central-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: eu-central-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
REGION: eu-west-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: eu-west-2
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
REGION: eu-west-3
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
REGION: eu-north-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
REGION: sa-east-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"


Update 17/09/2020 @ 10:30 (GMT)

It looks like Aurora PostgreSQL v10.12 / v11.7 is back everywhere... and v10.13 / v11.8 is back in ap-south-1

REGION: us-east-2
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: us-east-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: us-west-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: us-west-2
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: ap-south-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)"
REGION: ap-northeast-2
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: ap-southeast-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: ap-southeast-2
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: ap-northeast-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: ca-central-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: eu-central-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: eu-west-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: eu-west-2
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: eu-west-3
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: eu-north-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"
REGION: sa-east-1
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)"
  "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)"



Update 18/09/2020 @ 11:00 (GMT)

All versions are back in all regions.

REGION: us-east-2 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: us-east-1 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: us-west-1 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: us-west-2 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: ap-south-1 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: ap-northeast-2 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: ap-southeast-1 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: ap-southeast-2 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: ap-northeast-1 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: ca-central-1 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: eu-central-1 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: eu-west-1 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: eu-west-2 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: eu-west-3 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: eu-north-1 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)" REGION: sa-east-1 "Aurora PostgreSQL (Compatible with PostgreSQL 10.11)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.12)" "Aurora PostgreSQL (Compatible with PostgreSQL 10.13)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.6)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.7)" "Aurora PostgreSQL (Compatible with PostgreSQL 11.8)"
at

1 comment:

  1. Unknown16 September 2020 at 13:16

    I have reports that Aurora v11.7 has also been pulled in various regions... so best you stick with v11.6 at present.

    ReplyDelete

Subscribe to: Post Comments (Atom)

New PostgreSQL RDS versions - v10.14 , v11.9, and v12.4

It appears that new patch versions of PostgreSQL RDS are being rolled out in AWS.. so we should expect an announcement soon: REGION: us-east...