PostgreSQL Blog by Greg Clough: 2020

Friday 18 September 2020

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-2
"DBEngineVersionDescription": "PostgreSQL 10.11-R1"
"DBEngineVersionDescription": "PostgreSQL 10.12-R1"
"DBEngineVersionDescription": "PostgreSQL 10.13-R1"
"DBEngineVersionDescription": "PostgreSQL 11.6-R1"
"DBEngineVersionDescription": "PostgreSQL 11.7-R1"
"DBEngineVersionDescription": "PostgreSQL 11.8-R1"
"DBEngineVersionDescription": "PostgreSQL 12.2-R1"
"DBEngineVersionDescription": "PostgreSQL 12.3-R1"

REGION: us-east-1
"DBEngineVersionDescription": "PostgreSQL 10.11-R1"
"DBEngineVersionDescription": "PostgreSQL 10.12-R1"
"DBEngineVersionDescription": "PostgreSQL 10.13-R1"
"DBEngineVersionDescription": "PostgreSQL 11.6-R1"
"DBEngineVersionDescription": "PostgreSQL 11.7-R1"
"DBEngineVersionDescription": "PostgreSQL 11.8-R1"
"DBEngineVersionDescription": "PostgreSQL 12.2-R1"
"DBEngineVersionDescription": "PostgreSQL 12.3-R1"

REGION: us-west-1
"DBEngineVersionDescription": "PostgreSQL 10.11-R1"
"DBEngineVersionDescription": "PostgreSQL 10.12-R1"
"DBEngineVersionDescription": "PostgreSQL 10.13-R1"
"DBEngineVersionDescription": "PostgreSQL 10.14-R1"
"DBEngineVersionDescription": "PostgreSQL 11.6-R1"
"DBEngineVersionDescription": "PostgreSQL 11.7-R1"
"DBEngineVersionDescription": "PostgreSQL 11.8-R1"
"DBEngineVersionDescription": "PostgreSQL 11.9-R1"
"DBEngineVersionDescription": "PostgreSQL 12.2-R1"
"DBEngineVersionDescription": "PostgreSQL 12.3-R1"
"DBEngineVersionDescription": "PostgreSQL 12.4-R1"

REGION: us-west-2
"DBEngineVersionDescription": "PostgreSQL 10.11-R1"
"DBEngineVersionDescription": "PostgreSQL 10.12-R1"
"DBEngineVersionDescription": "PostgreSQL 10.13-R1"
"DBEngineVersionDescription": "PostgreSQL 11.6-R1"
"DBEngineVersionDescription": "PostgreSQL 11.7-R1"
"DBEngineVersionDescription": "PostgreSQL 11.8-R1"
"DBEngineVersionDescription": "PostgreSQL 12.2-R1"
"DBEngineVersionDescription": "PostgreSQL 12.3-R1"

... etc.

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.